fuzzystrmatch is a PostgreSQL extension for comparing names that may be misspelled, altered, or represented by aliases. It supports phonetic matching and Levenshtein-based similarity for OFAC screening and other financial-institution checks. section 11.7.2
Fuzzystrmatch
fuzzystrmatch is a PostgreSQL extension that provides string-similarity and phonetic-matching functions.
How Build Financial Software with Generative AI (From Scratch) covers it
- How deep it goes
- Walks through installation, name normalization, score calculation, phonetic tests, result combination, and threshold filtering.
- Examples
- Uses PPD and IAT transaction names, SDN names and aliases, normalized scores, Daitch–Mokotoff matches, and an 80-point threshold.
- What it assumes
- Assumes basic SQL filtering and joins while introducing fuzzy matching beyond ILIKE and wildcard searches.
- What you can do after
- Apply it via PostgreSQL to identify potentially altered or misspelled names during transaction and customer screening.
- How it connects
- Connects PostgreSQL queries with phonetic matching, Soundex, Metaphone, Levenshtein distance, aliases, CTEs, and OFAC screening.
Related concepts
- edit distanceuses · Edit distance is the minimum number of permitted operations needed to transform one string or sequence into another, commonly counting insertions, deletions, and substitutions.
This explainer was generated by Manning's knowledge graph from the text of Build Financial Software with Generative AI (From Scratch). The section links point to the parts of the book it draws on.