Upgrade Guide > Upgrade Guide > D. Features Introduced in Ingres 10.0 > DBMS Server Enhancements > Daitch-Mokotoff Soundex Function
Was this helpful?
Daitch-Mokotoff Soundex Function
The SOUNDEX_DM function uses the Daitch-Mokotoff phonetic algorithm for finding similar sounding strings.
The Daitch-Mokotoff soundex function can return multiple soundex codes for a name. It returns one or more six-character codes in a comma-separated varchar string, up to a maximum of 16 codes. For example:
Name
Codes Returned
Moskowitz
645740
Peterson
739460,734600
Jackson
154600,454600,145460,445460
The function syntax is:
SOUNDEX_DM('string')
For details, see the SOUNDEX_DM section under String Functions in the SQL Reference Guide.
Last modified date: 01/30/2023