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.
Teradata SQL to Extract Records Based on Approximate String Matching
3.5k Views Asked by Samir Parmar At
1
There are 1 best solutions below
Related Questions in TERADATA
- Kafka Connect JDBC Connector not working with teradata
- Spool Space Error while using LEFT JOIN in TERADATA
- Teradata query to Calculate Start and End dates Based on a condition
- whether it is possible to overwrite the result of the UNION operation to the name of the first table
- Failure 2673 The source parcel length does not match data that was defined
- Dynamic starting position in substring and dynamic length
- How to set default role for Teradata User?
- How can I create a secure connection with teradatasql
- issue with case statement
- Visual Studio 2022 connection to Teradata ODBC Driver 17.10 from Server Explorer
- Sql - Rolling up multiple rows to one row
- issue with QUALIFY RANK
- SSIS Teradata connection not appearing when creating new connection manager
- Exception criteria exceeded : CPU time in SAS . How to resolve this error?
- Query usage metadata from Teradata
Related Questions in LEVENSHTEIN-DISTANCE
- Stop OpenSearch from counting mispelled words (from fuzziness) in score when a correct word is matched
- Reduce the amount of entries read for the smallest Levenshtein distance in a data bank
- Jaccard vs Cosine similarity for addresses string comparison
- Python aligning audio transcription to script for subtitles using word similarity
- C#: of two methods which calculate Levenshtein distance, why does the heap-allocated "cost" array outperform the stack-allocated "cost" array?
- How does Oracle DB compute edit distance and similarity with non-ASCII characters?
- How can I get this LAMBDA function to accept an array as input?
- Levenshtein Distance using Azure Search
- How do I figure out which word sounds most similar to a given word?
- Mutation/mismatch counts among sequences/strings in Python
- Levenshtein distance for words from list in Bigquery
- Meaning behind 'thefuzz' / 'rapidfuzz' similarity metric when comparing strings
- How to find the changes from levenshtein string distance
- Match county names to predefined list
- The theoretical complexity of Tries and the distances of Levenshtein to suggest similar words
Related Questions in FUZZY
- Fill blanks on the column based on the remaining two columns and data present on the blanks column
- Excel FuzzyLookup: Similarity Check works fine, but wrong values in cells of other columns
- Find the Closest Match in Excel
- AttributeError: 'numpy.ndarray' object has no attribute 'plot' when visualize rule on pyFTS library
- module 'thefuzz' has no attribute 'partial_ratio' and other odd errors
- Why the fuzzy pinyin can't take effect in fcitx5-rime input method engine?
- How to configure sorted fuzzy search without fuzzy operand in the query in SOLR
- Issue running the RESTler image from docker hub (proc/1/stat error related)
- How can plain string comparison be made less error prone?
- How do I implement Python's mock ANY in Golang
- How to use fuzzy join to find elements with similar strings, also on the condition that certain columns match
- how can I write fuzzy logic for a stock market data
- Perform Fuzzy match in power query across multiple workbooks or tables without combining them
- weight inputs in Fuzzy Logic System
- R: How to handle missings in a fuzzy matching setting with fedmatch?
Related Questions in METAPHONE
- What is the minemum percentage in Metaphone3 that I can use it to tell these names are matched
- Name Matching using Double Metaphone on BigQuery
- Performance for join table with string comparison
- configure double metaphone in french java apache
- Why is Java's Double Metaphone only giving four letter codes?
- variables equal with doublemetaphone on pyspark
- How to make a fulltext search
- How to decide which Encoder to use for which language in Elasticsearch "Phonetic Token filter"?
- Populate Rows in CSV with jellyfish.metaphone() value of row
- MySQL select possible regular expression question
- Difference between Metaphone 3 and Double Metaphone
- Double Metaphone algorithms for Full Names
- Soundex or Metaphone algorithm for typos in search term
- I want to use double metaphone algorithm in stored procedure does oracle have any inbuilt function for this?
- PostgreSQL: Address matching using fuzzymatch from two tables
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Teradata 14.x supports the Damerau-Levenshtein Distance algorithm via the
EDITDISTANCE()function and n-gram pattern matching via theNGRAM()function.You can find information about the EDITDISTANCE function here and the NGRAM() function here.