Text search name and name synonims dictionary

On Thu, 29 Jan 2009, Igor Katson wrote:

I have a column, containing the name of the user and there is a need to
organize an indexed search on this column. As far as I understand, I need to
use the full-text search capabilities of postgres.

I would like to attach a dictionary, containing many possible names, and the
short names like:

William Will Bill Billy
James Jim Jimmy

etc., which will give me a possibility to perform indexed search on any of
these names and it will give me all the matches on variations of the name,
regardless of which of them was chosen as a search argument.

1. Is it possible to do that with postgres' full-text search capabilities?

yes, look on contrib/dict_xsyn

2. Does anyone know, if there is a Russian dictionary of these names?

there are printed dictionaries, not sure about electronic versions.

3. What is the name of such kind of dictionary, to know, what to google for?

http://yandex.ru/yandsearch?text=словарь+личных+имен

Thanks in advance, and regards
Igor Katson.

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

Oleg Bartunov wrote:

On Thu, 29 Jan 2009, Igor Katson wrote:

I have a column, containing the name of the user and there is a need
to organize an indexed search on this column. As far as I understand,
I need to use the full-text search capabilities of postgres.

I would like to attach a dictionary, containing many possible names,
and the short names like:

William Will Bill Billy
James Jim Jimmy

etc., which will give me a possibility to perform indexed search on
any of these names and it will give me all the matches on variations
of the name, regardless of which of them was chosen as a search
argument.

1. Is it possible to do that with postgres' full-text search
capabilities?

yes, look on contrib/dict_xsyn

2. Does anyone know, if there is a Russian dictionary of these names?

there are printed dictionaries, not sure about electronic versions.

3. What is the name of such kind of dictionary, to know, what to
google for?

http://yandex.ru/yandsearch?text=О©╫О©╫О©╫О©╫О©╫О©╫О©╫+О©╫О©╫О©╫О©╫О©╫О©╫+О©╫О©╫О©╫О©╫

Thanks in advance, and regards
Igor Katson.

Regards,
Oleg
_____________________________________________________________

Thanks for the help, Oleg!