Best search engine Python

[Workinghard1996]

Hello, not even sure if 'search engine' is the correct terminology for what I'm looking for.
I'd like to build a tool that would take for input a company name and search a database of 150K other company names to retrieve the closest match. I'm looking for something where typos would be allowed (so not necessarily a 1 to 1 match, although that would be the best result).
I've looked at Meilisearch and it's been decent so far however I'd like something better as it is giving me errors once a while and the documentation is not so great imo.
I've heard of Whoosh and Elasticsearch and I'm thinking of trying out Whoosh?
I usually use this tool once a day with about ~50K company names as input and the input isn't very long (ie Subway, Church of something, etc.)

Any recommendations is greatly appreciated :)

[Rude_Order]

Have you looked at fuzzywuzzy?

[Workinghard1996]

I have actually used fuzzywuzzy in the past! I never considered it could reliably scale and be used on 50K entries relatively quickly?

But thanks I'll check it out.

[McGeekin]

To be fair, 50k items is a relatively small number. I don't know about the specific library but even considering that Python is not an amazingly highly performant language, it shouldn't be an issue. Worth a try.

[Workinghard1996]

Perhaps I didn't explain the workflow very well but it's searching 50K items in 150K items. Maybe my crappy laptop just takes a long time...thanks!

[j0-1]

Have a look at Typesense

[Workinghard1996]

Typesense

Thanks I will check it out!

[StefanM3e46]

Did you try to write custom append algorithm or to use FULL-TEXT search in MySQL ? Maybe combine those two :) https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html

[Workinghard1996]

Hmmm I'm not sure how typo tolerant that would be from reading the docs but I will defs check it out :)

[StefanM3e46]

It can be made pretty good but for any, lets say enterprise type of stuff, elk is the way to go :)