16.20 - Soundex Coding Guide - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2020-03-25
dita:mapPath
xzf1512079057909.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
kby1472250656485

The following process outlines the Soundex coding guide:

  1. Retain the first letter of the name.
  2. Drop all occurrences of the following letters:

    A, E, I, O, U, Y, H, W

    in other positions.

  3. Assign the following number to the remaining letters after the first letter:

    1 = B, F, P, V

    2 = C, G, J, K, Q, S X, Z

    3 = D, T

    4 = L

    5 = M, N

    6 = R

  4. If two or more letters with the same code are adjacent in the original name or adjacent except for any intervening H or W, omit all but the first.
  5. Convert the form “letter, digit, digit, digit,” by adding trailing zeros if less than three digits.
  6. Drop the rightmost digits if more than three digits.
  7. Names with adjacent letters having the same equivalent number are coded as one letter with a single number

    Surname prefixes are generally not used.