>>>Hi,
>>>Is there anyone who knows something about phonetic text search ?
>>>
>>>Regards,
>>
>>Look at SOUNDEX()
>
>Actually, I read an article a few months back (can't recall where, probably VBPJ) about soundex. It gave a list of words (not complete) that were very similar in sound (and phoeneticaly as well) which the SOUNDEX() function couldn't evaluate as a close or identical match.
>
>I'll try to find the article and post the sample words list they had (if I can survive the search in my home office that is... everything is perfectly organized in random and harmless (unless looked at or touched) piles and stacks.
>
>Makes tax-time SO much more interesting!
>
>Hugo
There are known problems with SOUNDEX, as you've described.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer