pg_trgm

Built-in PostgreSQL extension providing trigram-based similarity matching via similarity(), word_similarity(), and GIN/GiST indexes. The standard Postgres mitigation for weak typo tolerance — enables fuzzy string search without a dedicated search engine.

Often paired with unaccent for accent-insensitive matching.