Returns a two-element array of primary and secondary phonetic encodings for an input string, based on the Double Metaphone algorithm.
The Double Metaphone algorithm processes an input string to render a primary and secondary spelling for it. For English language words, the algorithm removes silent letters, normalizes combinations of characters to a single definition, and removes vowels, except from the beginnings of words. In this manner, the algorithm can normalize inconsistencies between spellings for better matching. For more information, see https://en.wikipedia.org/wiki/Metaphone.
Tip: This function is useful for performing fuzzy matching between string values, such as between potential join key values.
Source values can be string literals, column references, or expressions that evaluate to strings.
String literal reference example:
derive type:single DOUBLEMETAPHONE('My String') as:'double_metaphone'
Output: See below.
Column reference example:
derive type:single value:DOUBLEMETAPHONE(string1) as:'double_metaphone'
Output: Generates a new
double_metaphone column containing the evaluation of
string1 column values through the Double Metaphone algorithm.
derive type:single value:DOUBLEMETAPHONE(string_ref)
|string_ref||Y||string||Name of column or string literal to apply to the function|
String literal, column reference, or expression whose elements you want to filter through the Double Metaphone algorithm.
|Required?||Data Type||Example Value|
|Yes||String literal, column reference, or expression evaluating to a string|