On duplicate checks of type 'Fuzzy matching', you can apply phonetic search algorithms. You can use a phonetic search algorithm to check on duplicate names that sound similar, for example, John and Jon.

To apply a phonetic search algorithm to a duplicate check, set up a phonetic search rule and link it to a field in a duplicate check.

The supported phonetic search algorithm is Metaphone. You can apply these versions of the Metaphone algorithm:

  • Double metaphone
  • Metaphone 3

Advanced setup

You are advised to start applying phonetic search with the basic setup, that is with the selected Phonetic search algorithm.

Based on testing and experience, you can finetune the phonetic search rule setup by defining:

  • A maximum length: The maximum number of characters for a phonetic search key. The shorter a phonetic search key is, the fuzzier the duplicate check result is.
  • Words to be ignored: You can define the words for which you do not want to create a phonetic search key.


Standard procedure

1. Go to Data quality studio > Setup > Phonetic search rules.
2. Click New.
3. In the Phonetic search rule field, type a value.
4. In the Phonetic search algorithm field, select an option.
5. Sub-task: Set phonetic search rule parameters.
  5.1 Expand the Parameters section.
  5.2 In the Phonetic key maximum length field, enter a number.
6. Sub-task: Define words for which no phonetic search key is desired.
  6.1 Expand the Ignored words section.
  6.2 Click Add line.
  6.3 In the Word field, type a value.
Related to Notes

Set up duplicate check

 

See also

Provide feedback