select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Full-text search

fuzzystrmatch

determine similarities and distance between strings

pgext.cloud · Website · Documentation · License text · Control file

Overview

Packagefuzzystrmatch
Version1.2
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPostgreSQL contrib
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedYes
Latest commit2026-05-14
Latest release2026-05-14
Catalogue updated2026-07-29

Related extensions

Required by

fuzzywuzzyfuzzywuzzy ratio for postgres
postgis_tiger_geocoderPostGIS tiger geocoder and reverse geocoder

See also

pg_trgmtext similarity measurement and index searching based on trigrams
pg_similaritysupport similarity queries
smlarEffective similarity search
pgpcrePerl Compatible Regular Expression functions
re2ClickHouse-compatible regex functions using RE2
pg_bigmcreate 2-gram (bigram) index for faster full text search.
biscuitIAM-LIKE pattern matching with bitmap indexing
unaccenttext search dictionary that removes accents
citextdata type for case-insensitive character strings