...

• Ignore case: Ignore differences in case between values in the join key columns. MyValue matches with MYVALUE. 
• Ignore special characters: Ignore special characters that appear in the join key values. 
• Ignore whitespace: Ignore spaces, tabs, and other whitespace values that may appear in join key values.

Create fuzzy join

A fuzzy join

...

 applies a fuzzy matching algorithm to String values in the join key column to account for slight differences in how values are written.

This algorithm relies on the

...

doublemetaphone function, which attempts to normalize text values based on how the string is spoken by an English speaker. For more information, see https://en.wikipedia.org/wiki/Metaphone#Double_Metaphone.

• Fuzzy match: Enable fuzzy matching based on English language pronunciation using the doublemetaphone function.

Create range join

...