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 intended to suggest names of people (search field "person's
> name" in web form). it would be great if it does its work smarter than
> simple LIKE.
>
> also, i'd be happy to listen opinions from people who have experience
> of usage of such things like soundex.
>
> --
> Best regards,
> Nikolay
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
--
Teodor Sigaev E-mail: teodor@sigaev.ru
WWW: http://www.sigaev.ru/