Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group