PostgreSQL enables me to configure what dictionaries I would like to use when preforming a fulltext search. The following types of dictionaries can be set:

  • stop
  • ispell
  • simple
  • snowball
  • synonym
  • thesaurus

It comes with some .stop dictionaries and example files included, if you install the .deb file through PostgreSQL's servers. Yet nothing to fancy. Are there any locations that one can get good filed dictionaries in any of these categories? I am searching for Dutch dictionaries in particular.

So far I found ispell dictionaries for many languages:

Any links to good sources?


So far I managed to find the following:

PostgreSQL ships with Snowball and Stop dictionaries for a lot of languages (for sure Dutch, English and German), I have no clue how up-to-date they are.

To get good Ispell/Hunspell dictionaries I would refer you to the following post: "Wrong affix file formate for flag" while loading dictionaries from LibreOffice in PostgreSQL 9.3. In short quite okay once ship with Linux (Debian at least) check out the link on how to set it up.

For Thesaurus and Synonyms I am still hoping for input and my search continues. If I find something be for I hear something I will post it here.

  • You can use the hunspell dictionaries from the OpenOffice/LibreOffice project: hunspell.sourceforge.net – a_horse_with_no_name Oct 20 '14 at 11:32
  • @a_horse_with_no_name Can this be used for all types of dictionaries? – WillyBurb Oct 20 '14 at 17:16
  • The hunspell dictionary en_us of Liberty Office contains errors and can't be loaded by PostgreSQL – WillyBurb Oct 21 '14 at 10:17
  • I used the German dictionary from OpenOffice a while ago and that worked without problems. Maybe LibreOffice changed something in their dictionaries. – a_horse_with_no_name Oct 21 '14 at 10:18
  • I checked the Dutch and English(US) of LibreOffice 4.3 and 3.3 both give errors. The de_de_frami.dict of libreOffice 4.3 is not UFT8. In the en_US I could even find a syntax error. Reporting it to LibreOffice also failed since their bug submission form doesn't seem to work. – WillyBurb Oct 21 '14 at 12:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.