D. Features Introduced in Ingres 10.0 : DBMS Server Enhancements : Daitch-Mokotoff Soundex Function
 
Share this page                  
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.