title: Teradata SQL to Extract Records Based on Approximate String Matching
body: <p>We are on version TD 14 and I come from Netezza / Postgre(Redshift) background. I have been asked to extract a login data from audit logs to find out records/transactions where the same ip is submitting similar looking usernames with small changes. e.g  Samir --> Samr  --> Amir etc
  To capture phishing activity.
  In POstgres we have fuzzy string functions like '%'  e.g ColA % ColB (where % operator is equivalent to Similar)
  Soundex, Metaphone, levenshtein etc.
  In  Teradata however I have just encountered or I have been able to find just Soundex. Is there any such in built function/method capability with Teradata version 14 to achieve the above string approximation.</p>