How to make the search take into account misspelled words?

Question

PHP

There is an online store with spare parts for phones. There is a product in the database, for example, with the name "Touch screen for 4Good T700i", you need to search for "GT700i" in the results with the product "Touch screen for 4Good T700i" + Cyrillic must be taken into account. what tool can do this? tried SOUNDS LIKE or SOUNDEX() in mysql and it doesn't work in my case. single output only elastic search , right?

Answer 1

https://habr.com/post/140943/