This article describes how to perform fuzzy searches for all the fields in a table using pg_trgm. It illustrates the implementation of a full-table and full-field fuzzy search with an example.
This article looks at row-level full-text searches in PostgreSQL and walks through how you can create one yourself.