Hi, Jan. On Mon, 12 Feb 2007 03:05:24 -0600, Jan Vanbrabant <[EMAIL PROTECTED]> wrote:
>In this context, we are looking for a a "phonetic translation" tool. >An example where this is used : >The insurance call center needs to find a customer record and tries to >look it up using the last name. It sounds like "teu..." but this means >that it could be written like "teu...", "theu...", "deu..." etc. >Entering "teu..." on the query panel would have to display all customer >records that match the phonetic "teu..." > [snip....] You might try the soundex algorithm. From wikipedia "Soundex is a phonetic algorithm for indexing names by their sound when pronounced in English. The basic aim is for names with the same pronunciation to be encoded to the same string so that matching can occur despite minor differences in spelling. Soundex is the most widely known of all phonetic algorithms and is often used (incorrectly) as a synonym for "phonetic algorithm". (see: http://en.wikipedia.org/wiki/Soundex). Hope this is of some help. Have a good one. DJ ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html