All geek questions in one place

Can someone provide me a SOUNDEX similar SQL function that works correctly for INDIAN TITLES?

I need to search indexes from my database (mysql). I tried the SOUNDEX function, but it failed for long index names.

+6
source share
1 answer

In this case, I would suggest using the Double Metaphone algorithm for MySQL. The double metaphone is designed to eliminate the difficulties associated with words from different root languages. It is based on Metaphone, which was designed to fix some of Soundex's flaws. Here is a link to the Double Metaphone website where you can learn more about this and also see examples in several languages, including MySQL:

http://www.atomodo.com/code/double-metaphone

+1
source

Source: https://habr.com/ru/post/887916/

More articles:


All Articles