Re: [GENERAL] sound index

2006-04-12 Thread Alex Mayrhofer
Teodor Sigaev wrote: >> also, i'd be happy to listen opinions from people who have experience >> of usage of such things like soundex. I'm using metaphone() together with levenshtein() to search a place name gazetteer database and order the results. That works reasonably well and gives interestin

Re: [GENERAL] sound index

2006-04-12 Thread Teodor Sigaev
Have a look at contrib/pg_trgm Nikolay Samokhvalov wrote: hello. does anybody know any solutions to the problem of searching words/phrases, which are close to each other by sounding? e.g. soundex index or smth. problem I have: tag suggestion mechanism, similar to google suggest, which is inten

Re: [GENERAL] sound index

2006-04-11 Thread Scott Ribe
>> also, i'd be happy to listen opinions from people who have experience > of usage >> of such things like soundex. > > > Soundex is grossly outdated. It was designed for manual use by 19th century > census takers, and I'm always surprised to see it still used. Metaphone > (google search gets goo

Re: [GENERAL] sound index

2006-04-11 Thread Scott Ribe
> also, i'd be happy to listen opinions from people who have experience of usage > of such things like soundex. Soundex is grossly outdated. It was designed for manual use by 19th century census takers, and I'm always surprised to see it still used. Metaphone (google search gets good results) doe

Re: [GENERAL] sound index

2006-04-11 Thread Martijn van Oosterhout
On Tue, Apr 11, 2006 at 05:28:12AM -0700, Nikolay Samokhvalov wrote: > hello. > > does anybody know any solutions to the problem of searching > words/phrases, which are close to each other by sounding? e.g. soundex > index or smth. Check out contrib/fuzzystrmatch. It has a number of such algorith

[GENERAL] sound index

2006-04-11 Thread Nikolay Samokhvalov
hello. does anybody know any solutions to the problem of searching words/phrases, which are close to each other by sounding? e.g. soundex index or smth. problem I have: tag suggestion mechanism, similar to google suggest, which is intended to suggest names of people (search field "person's name"