About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Last updated: Feb 11, 2025
SoundEx is a method used to find strings when the sound is known but the precise spelling isn't known.
Developed in 1918, the method searches out words with similar sounds based on
phonetic assumptions about how certain letters are pronounced. SoundEx can be used to search names
in a database (for example, where spellings and pronunciations for similar names may vary). The
basic SoundEx algorithm is documented in a number of sources and, despite known limitations (for
example, leading letter combinations such as
and ph
won't match
even though they sound the same), is supported in some form by most databases. f
Function | Result | Description |
---|---|---|
|
Integer | Returns the four-character SoundEx code for the specified STRING. |
|
Integer | Returns an integer between 0 and 4 that indicates the number of characters that are the same in the SoundEx encoding for the two strings, where 0 indicates no similarity and 4 indicates strong similarity or identical strings. |
Was the topic helpful?
0/1000