SOUNDEX

All functions > STRING > SOUNDEX

Returns a four-character Soundex code representing the phonetic sound of a string.

Signatures

Returns: Four-character Soundex code representing the phonetic sound

SOUNDEX(string: VARCHAR) → VARCHAR

Notes

• Used for fuzzy string matching based on pronunciation
• Words that sound similar have the same Soundex code
• Result is always a letter followed by three digits
• Useful for matching names despite spelling variations

Examples

SELECT
    f1 := SOUNDEX('Smith'),  -- Common surname
    f2 := SOUNDEX('Smythe'),  -- Similar sound to Smith
    f3 := SOUNDEX('Johnson'),  -- Another surname
    f4 := SOUNDEX('Jonson'),  -- Similar to Johnson
    f5 := SOUNDEX('Williams'),  -- Different pattern
    f6 := SOUNDEX('Robert')  -- First name example
;