Reference Guide > TDV Support for SQL Functions > Phonetic Functions
 
Phonetic Functions
TDV supports the phonetic functions listed in the table. The TDV functions are modeled on Netezza implementations. For further information, follow this link.
Phonetic Function
Comments
DBL_MP
DBL_MP (string_expression) returns a TDV 32-bit numeric expression of the input argument.
NYSIIS
NYSIIS (string_expression) returns a Soundex representation of the input argument using the New York State Identification and Intelligence System (NYSIIS) variation of Soundex.
PRI_MP
PRI_MP (numeric_expression) returns the four-character primary metaphone string from the numeric_expression returned by DBL_MP.
SCORE_MP
SCORE_MP (numeric_expression1, numeric_expression2) returns a score for how closely the two numeric expressions match.
SEC_MP
SEC_MP (numeric_expression) returns the four-character secondary metaphone string from the numeric_expression returned by DBL_MP.
SOUNDEX
SOUNDEX function returns a four-character code to evaluate the similarity of two expressions.
DIFFERENCE
Returns an integer value that indicates the difference between the values returned by the SOUNDEX function for string_exp1 and string_exp2.