PostgreSql Full-Text Search forms of

Question

Is it possible to do Full-text search in PostgreSql using morphological forms as it is done in Microsoft SQL Server with FORMSOF clause?

E.g. the field contains 'drank', I search 'drink' and find it.

Answer 1

The answer is "yes". Postgres does this by providing dictionaries, which are explained here.

Dictionaries come in different types, such as stop-words, synonyms, thesaurus, and ispell. The latter does what you are looking for.