Netezza Phonetic

nysiis
Returns a Soundex representation of "string_expression" using the New York State Identification and Intelligence System (NYSIIS) variation of Soundex.
dbl_mp
Returns a composite 32-bit value of "string_expression".
pri_mp
Returns the 4 character primary metaphone string from "numeric_expression" returned by dbl_mp.
sec_mp
Returns the 4 character secondary metaphone string from "numeric_expression" returned by dbl_mp.
score_mp
Returns a score for how closely "numeric_expression" and "numeric_expression2" match.

Parent topic: Netezza