Phonetic search on SQL server

Asked

Viewed 1,294 times

7

I need to implement phonetic search for Portuguese (br). Does anyone have any phonetic search solution in SQL Server with c#?

The search should search inside a string using the SOUNDEX function or a similar function that works in en?

c# sql-server
  • 3

    Related: http://answall.com/q/1828/101

  • 1

    I’ve seen a lot of Brazilian clippers using Soundex, but since it’s made for the English language, it doesn’t look good. Although in almost all cases, the entire code was already well in the style of the standard clipper from Brazil, so Soundex was just a detail.

  • But I did a test and it works in Portuguese but I tested the basics. I think it will break a branch, until I implement or find some that works better in en. the problem is how to search between all words.

  • 1

    In a broad sense, "it works"... I’m talking more about working right, not creating an impression, because "in some cases it works".

  • Thank you for informing @Bacco

  • 1

    @Marcoantonioquintal note that the intention is to alert to a potential limitation, which is not always obvious, and in no way a criticism to its attempt to use. Because, the most important step you have taken, which is to ask the question to seek a solution :)

  • If I find something interesting I will publish the reply. Thank you.

  • Take a look at that link @bigown posted above, there are some things there that can give you a sense of the paths already tried. I think a lot of programmers who want to do a better UX have been through this dilemma already. Even there is raised the question of cases where you use for words in general and when it comes to names, which in itself is a separate universe. Imagine how it would complicate an algorithm that understands "uóchinton" and "Washington" as the same thing (name is a problem that goes far beyond the Portuguese language).;

  • I did some tests here but the Soundex function is too bad. You will find nothing.

  • Do you want the solution in SQL Server or do you want in C#? Or both?

  • Long ago I saw some people adapting the metaphone and applying some logics to improve the correct Latin languages, I did not follow and do not know if it evolved, I think at the time was not native to SQL, unfortunately this type of function/ application was little explored for our language, maybe you can improve the results by confronting similarity search algorithms like Levenshtein, of course the pronunciation has nothing to do with how similar two words is written, but in some cases it may be true!

Show 6 more comments

1 answer

3

Browser other questions tagged c# sql-server

You are not signed in. Login or sign up in order to post.