postgresql. full text search for queries with misprints

Question

Is it possible to implement full text search using postgresql when queries can be with misprints? I couldn't find it in manual.

Answer 1

I'm not totally sure what you mean by misprint.

If you are looking for fuzzy string matching, the fuzzystrmatch extension is what you want.

fuzzystrmatch is a module, you must "install" it by running :

CREATE EXTENSION fuzzystrmatch;

This way of installing extensions exists since PostgreSQL 9.1.

For previous versions, you needed to run the sql script in the contrib dir for that extension against your database.