I have been using Scious Search in my app for 6 months now and its working incredible well. Some of our tables have >100k records. We were using Fuzzy search and it was taking 25 seconds to return a result.
Now, the search is lightening fast. Scious search returns results in a few milliseconds. The plugin also lets us sort data alphabetically and separate it by user using the privacy rules.
We sync to Typsense which is costing us about $10/m. The cost is negligible compared to the performance we now get.
I highly recommend Scious search for anyone looking to hold more than 2K records in their database.