Re: Improving partial lookup results

On Thu, Sep 19, 2019 at 08:23:31PM -0300, David Bremner wrote:
> Olly Betts <[email protected]> writes:
> 
> > Incidentally, if you're actually aiming to match different forms of a
> > name (Peter vs Pete, Ann vs Anne vs Annette) then you might find the
> > synonym feature a better option than wildcarding.
> 
> What about a custom stemmer?

That would work too, and probably makes for faster queries.

But it achieves that by doing some of the work at index time, and a
consequential drawback is that with a custom stemmer you'd need to
perform a full reindex for changes to name mappings to properly take
effect, whereas with synonyms you can add or remove synonyms at any
time.

Cheers,
    Olly