Geek asks and answers

Fuzzy SQL Search and Google-like Improvements

Interesting challenge; my client injects some product information into an SQL database. The work is a picture of the famous Russian composer Rachmaninov. So the name is in the description field. Now, only a few of their customers looking for products know exactly how to spell this name, but most of the time he was mistaken. In addition to spelling, there are also many international clients who simply write this name in a completely different way, like, Rachmaninov, Rachmaninoff, Rachmanin.

If I put any of these spelling errors or translations on Google, he (almost) always knows how to fix this and redirect me directly to the right page.

Does anyone know what my features can get some of these magic in my product search? Is there any API I can use? Some super free text option that I don't know about? Or...

+5
source share
1 answer

We solved a similar problem with rather great success: searching for people (German names) by name given by phone.

: "", "", "", "", "" "" , . "" "" "" , : ", , ", .

, , . ( , ):

{consonant}+ := {consonant}
ie := i
ii := i
dt* := t
y|j := i
{vocal}v := {vocal}f

.., . - , . .

, MySQL Soundex() . , MSSQL - .

+2
source

More articles:


All Articles