Use of ISpell dictionaries with tsearch2 - what is the point?

From: "Don Walker" <don(dot)walker(at)versaterm(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Use of ISpell dictionaries with tsearch2 - what is the point?
Date: 2006-04-28 19:11:09
Message-ID: 001701c66af7$81c75af0$dbd849c6@donxp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.
>From what I now understand ISpell dictionaries only recognize properly
spelled words. This means that any misspelled word will be handled by the
stemming dictionary and usually just passed as is.

1. If I am correct about this then what is the point of using the ISpell
dictionary in the first place?

2. Is there a solution for correcting spelling mistakes in the documents you
index? I have seen the readme files for pg_trgm,
http://www.sai.msu.su/~megera/postgres/gist/, which would allow me to
suggest other terms for a query if the misspellings were common enough. I'd
rather fix the problem at index time so that querying with the proper term
would find any misspelled terms (within reason).

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2006-04-28 19:15:05 Re: Autovacuum Logging
Previous Message Robert Treat 2006-04-28 17:52:14 Re: Alternative for vacuuming queue-like tables