Text
Soundex / Phonetic Key
Adds the Soundex code of a name — a letter and three digits for how it sounds — so Robert and Rupert both become R163.
When to use it
Use it to match or group names that are spelled differently but sound the same, as a join key or for Duplicate Grouping.
In a pipeline
File InputSoundex / Phonetic KeyJoin Tables
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Column | select | Yes | Select column… |
| Generate New Column | checkbox | — | true |
| New Column Name | text | — | Default: <column> Soundex |
| Insert After | select | — | After the column |
Example
Names that sound alike
- Column=Name
| Name |
|---|
| Robert |
| Rupert |
| Ashcraft |
| Name | Name Soundex |
|---|---|
| Robert | R163 |
| Rupert | R163 |
| Ashcraft | A261 |
Worth knowing
- Standard American Soundex, the same code Fuzzy Match uses. Metaphone is not offered.
- Only letters count: a value with none gets an empty code.
- Soundex is tuned for English names; expect false matches on short names.