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, whole thread or download thread mbox)
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,, 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).


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-2017 The PostgreSQL Global Development Group