Code the Soundex - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530
  1. Retain the first letter of the name.
  2. Drop all occurrences of the following letters in other positions: A, E, I, O, U, Y, H, W
  3. Assign the following number to the remaining letters after the first letter:
      Letters
    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 rarely used.