I realized shortly after I sent this email that I could use a synonym dictionary to solve problem #2. To construct it myself I'd have to determine the common misspellings and create synonyms for them. So I have two more questions: 2.1 Are there any canned synonym dictionaries available the deal with misspellings in English and/or French? 2.2 Are there any clever linguistic algorithms that can partly solve the same problem? -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Don Walker Sent: April 28, 2006 15:11 To: pgsql-general@xxxxxxxxxxxxxx Subject: [GENERAL] Use of ISpell dictionaries with tsearch2 - what is the point? I'm new to using tsearch2 and am trying to understand why I would want to use an ISpell dictionary before the stemming dictionary. I'd originally hoped that ISpell would suggest corrections for misspelled words as the documents that I will be indexing will contain a lot of spelling mistakes.