EXAMPLE

This example illustrates how the following Double Metaphone algorithm functions operate in

D s product

r	true

.

DOUBLEMETAPHONE - Computes a primary and secondary phonetic encoding for an input string. Encodings are returned as a two-element array. See DOUBLEMETAPHONE Function.
DOUBLEMETAPHONEQUALS - Compares two input strings using the Double Metaphone algorithm. Returns true if they phonetically match. See DOUBLEMETAPHONEEQUALS Function.

Source:

The following table contains some example strings to be compared.

string1	string2	notes
My String	my string	comparison is case-insensitive
judge	juge	typo
knock	nock	silent letters
white	wite	missing letters
record	record	two different words in English but match the same
pair	pear	these match but are different words.
bookkeeper	book keeper	spaces cause failures in comparison
test1	test123	digits are not compared
the end.	the end….	punctuation differences do not matter.
a elephant	an elephant	a and an are treated differently.

Transformation:

You can use the DOUBLEMETAPHONE function to generate phonetic spellings, as in the following:

D trans

RawWrangle	true
p03Value	'dblmeta_s1'
Type	step
WrangleText	derive type: single value: DOUBLEMETAPHONE(string1) as: 'dblmeta_s1'
p01Name	Formula type
p01Value	Single row formula
p02Name	Formula
p02Value	DOUBLEMETAPHONE(string1)
p03Name	New column name
SearchTerm	New formula

You can compare string1 and string2 using the DOUBLEMETAPHONEEQUALS function:

D trans

RawWrangle	true
p03Value	'compare'
Type	step
WrangleText	derive type: single value: DOUBLEMETAPHONEEQUALS(string1, string2, 'normal') as: 'compare'
p01Name	Formula type
p01Value	Single row formula
p02Name	Formula
p02Value	DOUBLEMETAPHONEEQUALS(string1, string2, 'normal')
p03Name	New column name
SearchTerm	New formula

Results:

The following table contains some example strings to be compared.

string1	dblmeta_s1	string2	compare	Notes
My String	["MSTRNK","MSTRNK"]	my string	TRUE	comparison is case-insensitive
judge	["JJ","AJ"]	juge	TRUE	typo
knock	["NK","NK"]	nock	TRUE	silent letters
white	["AT","AT"]	wite	TRUE	missing letters
record	["RKRT","RKRT"]	record	TRUE	two different words in English but match the same
pair	["PR","PR"]	pear	TRUE	these match but are different words.
bookkeeper	["PKPR","PKPR"]	book keeper	FALSE	spaces cause failures in comparison
test1	["TST","TST"]	test123	TRUE	digits are not compared
the end.	["0NT","TNT"]	the endâ€¦.	TRUE	punctuation differences do not matter.
a elephant	["ALFNT","ALFNT"]	an elephant	FALSE	a and an are treated differently.

Versions Compared