| From: | "andres(dot)pascal" <andrespascal22(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Fastest Index/Algorithm to find similar sentences |
| Date: | 2013-08-20 23:06:08 |
| Message-ID: | 1377039968546-5768127.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
As I understand, you need to search strings by similarity (using levenshtein
or any other metric distance). In that case, you can use metric indexes like
FHQT or FQA (this is better if you are using a relational database, like
postgres). But they are not implemented yet in most DBMS, so you need to
program the index. It s not too hard, but you need to understand the base
concepts. You can look for "searching in metric spaces" to read about it. If
you are in a hurry, you can mail me and maybe I can help you.
Andres.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Index-for-Levenshtein-distance-tp5764546p5768127.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2013-08-20 23:18:09 | Re: Fastest Index/Algorithm to find similar sentences |
| Previous Message | Aram Fingal | 2013-08-20 20:11:43 | Alternate input for user defined data type |