Postgres Fuzzy Search With pg_trgm: Smart Database Guesses What You Want and Returns “Cat Food” When “Pet Food” Not Found

Intelligent search with pg_trgm and Levenshtein distance in Postgres

All images in the article by author

There are three common scenarios in database searches that go beyond the capability of traditional wildcard querying.