quinta-feira, 11 de maio de 2006 10:41
We have an application we are developing that will run worldwide. When we are searching data for peoples names I would like to use Soundex but I am not sure it works effectivly for any language other than English. Does anyone know if it is effective in Dutch, German, French etc?
Todas as Respostas
sexta-feira, 12 de maio de 2006 16:20
segunda-feira, 24 de setembro de 2012 15:25
segunda-feira, 24 de setembro de 2012 16:02Moderador
The regular soundex works pretty good for Hungarian:
-- Hungarian soundex test SELECT SOUNDEX('Kovacs'),SOUNDEX('Kovats'),SOUNDEX('Kovach') -- K120 K132 K120 SELECT SOUNDEX('Kovács'),SOUNDEX('Kováts'),SOUNDEX('Kovách') -- K120 K132 K120 SELECT SOUNDEX('Széchenyi'),SOUNDEX('Szécsenyi'),SOUNDEX('Szécheni') -- S250 S250 S250 SELECT SOUNDEX('Kossuth'),SOUNDEX('Koshuth'),SOUNDEX('Koshut') -- K230 K230 K230
- Editado Kalman TothMicrosoft Community Contributor, Moderator segunda-feira, 24 de setembro de 2012 16:02
segunda-feira, 24 de setembro de 2012 16:10
Soundex was specifically designed to handle the English pronunciation of names (mostly those of Western European origin) and does not function particularly well outside of that use. Your mileage may vary and will probably be limited for some of the European languages and probably will not work at all for Asian languages or Arabic.
Below is a link that might be useful, especially the variants section, where you may be able to roll your own implementation in CLR: http://en.wikipedia.org/wiki/Soundex
segunda-feira, 24 de setembro de 2012 17:08
The link provided in May, 2006, is not broken for me. When I follow it I get to this page:
Does this help?
Richard Mueller - MVP Directory Services
segunda-feira, 24 de setembro de 2012 17:19ModeradorIt is working now, but didn't work few hours ago. Perhaps it was fixed in the meantime.
For every expert, there is an equal and opposite expert. - Becker's Law