How to make a synonymous search for an online store?

Question

Online shopping

Good time of the day. We have a new project www.efurshet.com - food delivery in Kyiv. About 20 thousand products have been uploaded and there was a problem finding these products. Let's describe this problem with an example:
The query "Raffaello sweets" can be searched for by many options - rafaelo, raffaelo, rafaelo, raffaelo, raffaello, raffaello, hfaftkkj, etc.
The question is how to collect and automate the database of synonyms, who has any ideas? Or maybe it already exists somewhere.

Answer 1

Make a "synonyms" field for each product, enter all possible options there, separated by a space, and then search through sphinx, taking into account this field. This is about search automation.

Answer 2

I think if this is not a super-serious project, then it will be much faster and cheaper to come up with a social mechanism for adding synonyms.
Somehow encourage the user to write that "Raffaello candy" is both rafaello and rafaello, etc.
It seems to me that even if a similar automatic synonym search system is developed, the number of errors in it will outweigh the positive effect

Answer 3

the fact that the field was created a synonym for the product is clear. the question is where to get the database of synonyms, the last idea is interesting, we will try