Microsoft KB Archive/67754

-

{|
 * width="100%"|

The information in this article applies to: - Microsoft SQL Server version 4.2 for OS/2

SUMMARY
The following is a description of the functionality of the SQL SOUNDEX algorithm and examples of its abilities and limitations in distinguishing between words of similar length and/or phonetic structure.

MORE INFORMATION
The SOUNDEX function returns a four-character code that describes the phonetic characteristics of the word that was used as an argument to the function. The first character of this code returns the first letter of the word, and the remaining three characters are single digits that describe the phonetic &quot;value&quot; of the first three syllables of the word. As an example, a possible return from the SOUNDEX function might be the value &quot;A123&quot;. This is translated as follows:

&quot;A&quot; is the first letter of the word. &quot;1&quot; is the phonetic value of the first syllable. &quot;2&quot; is the phonetic value of the second syllable. &quot;3&quot; is the phonetic value of the third syllable. Unfortunately, the SOUNDEX algorithm suffers from some serious limitations, which are imposed by the fact that it can only record nine possible phoneme patterns. the SOUNDEX algorithm was not designed to distinguish between such sound alike words as &quot;string&quot; and &quot;sing&quot; (and it doesn't), but it also cannot register differences between vowel sounds. For example, the value &quot;B300&quot; is returned for all of the following words: &quot;bit,&quot; &quot;bite,&quot; &quot;bat,&quot; &quot;bait,&quot; &quot;boat,&quot; &quot;beet.&quot;
 * }

-

Last reviewed: April 25, 1997

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.