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.

Are you looking for typo / transcription-error resistant full-text search? If so, no, FTS doesn't currently support fuzzy or "similar" searching. — Craig Ringer, Jan 13 '14 at 01:09
auto-correct your queries before using them. use a spell-checker. — Neil McGuigan, Jul 29 '14 at 19:09

score 2 · Answer 1 · edited Jan 13 '14 at 01:11

2

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.

edited Jan 13 '14 at 01:11

Craig Ringer

answered Jan 13 '14 at 00:08

Raphaël Braud

2

Ah, knew I'd seen a blog about it somewhere. There's a similar example here using trigrams: http://tapoueh.org/blog/2013/09/06-pg_trgm-suggestions – Richard Huxton Jan 13 '14 at 09:33

1 Answers1