[SOLVED] Document Search => Fuzzy Search

Hi,

Is there any way to do some fuzzy search for an attribute in my database ? I want to search for some users but with approximation, so if this is not possible any idea to bypass that ?

Thanks.

Hi, so I checked with the team, we do not have that feature established already BUT you could maybe have to try some tweaking on your own, you could try https://www.meilisearch.com/ with Appwrite. One of the key features of Appwrite is the ease with which it can be integrated with other frameworks and services!

hum ok, so the main idea behind is to create a function that is triggered each time my collection have modification to import all into meilisearch, and then use a webservice exposed by meilisearch to search my content ?

quite the idea, however you can also (at the start when you define your database) write your own segregation and store them, for example, if you know you might need to search for emails with the help of the string after the "@" symbol, then at the time of storage, you can write something that splits the string and stores as you require. This might require previous knowledge of your search type which is not the ideal case always, hence the external search engine

Have you tried fulltext index btw?

I think most of the time, you'll get enough hits with fulltext indexes

Like it'll do partial matches

Idk what degree of "fuzziness" you need

I'll publish a first version with partial matches, but in a later release i want to gave more result to the users, for exemple when he search "mikael" I want to retrieve some result with "mickael", and I don't think it is possible with fulltext

makes sense, then an external search service can be helpful

🤔 Yeah that sounds about right. You could also access the mariadb instance directly, too.

Periodically craw the DB and add it to like meilisearch, elasticsearch, what ever you wanna use

Bypass some of the API overhead

@Mickaël LT is your query answered? If not, please let us know how we can help you better and if it is, shall I mark this thread as solved?

Yes, you can mark this solved, I'll complete later if I found a good implementation for this use case

awesome!

[SOLVED] Document Search => Fuzzy Search