From: | Arthur Zakirov <a(dot)zakirov(at)postgrespro(dot)ru> |
---|---|
To: | hmidi slim <hmidi(dot)slim2(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Spelling dictionaries |
Date: | 2017-11-10 09:36:22 |
Message-ID: | 20171110093622.GA5812@zakirov.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Nov 10, 2017 at 10:16:06AM +0100, hmidi slim wrote:
> Hi,
> I'm using Full Text search and I'm interested on using spelling dictionary.
> I found a website that has a special functionality, for example when I
> enter the word 'activities' it gives me the suggestions containing this
> word. But when I enter the word 'activityns' it returns 'No result for
> 'activityns'' But it gives me some suggestions contained the word
> 'activities'.
> In cas I entered the word 'activityng' it returns the same message 'No
> result for 'activityng' ' But I got some suggestions containing the word
> 'activity'.
> Does this the behaviour of the lspell dictionary, because I didn't
> understand how does he give suggestions when the word is wrong.
You can try pg_trgm extension [1].
Also we have a little demo web-site [2]. It uses pg_trgm. You can look at its code [3].
1 - https://www.postgresql.org/docs/current/static/pgtrgm.html#idm46428634444576
2 - http://tsdemo.postgrespro.ru/search?pattern=Galaksy&order=rank&rank_func=ts_rank
3 - https://github.com/postgrespro/apod_fts/blob/master/apod.py
--
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
From | Date | Subject | |
---|---|---|---|
Next Message | chiru r | 2017-11-10 13:25:24 | Client Authentication methods |
Previous Message | hmidi slim | 2017-11-10 09:16:06 | Spelling dictionaries |