Soundex Coding Guide - Advanced SQL Engine - Teradata Database

SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-30
dita:mapPath
tpt1555966086716.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1145
lifecycle
previous
Product Category
Teradata Vantage™

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.