CODEWITHSUNDEEP
pythondjangopostgresql
Mukesh'python-php
Mukesh'python-php

Reputation: 143

How to Customize the full text search function provided by postgresql

I am trying to customize the postgresql full text search functionality so that

For example, I can enter "Stouffers" and get a match on Stouffer's frozen foods. If I leave off one of the "f"s and spell it "Stoufers" I don't get a match. That's one of the things that the customized text search is supposed to handle. It converts all the text into a phonetic type code and searches on that.

Please help me in this how i can achive that. i found some help that i need to write a custom parser in C for doing this but i am very poor in C.

Upvotes: 0

Views: 525

Answers (2)

Dominique Guardiola
Dominique Guardiola

Reputation: 3431

Or get a standalone search engine such as Solr or Xapian with stemming, spelling, phonetic etc.
Django-haystack brings you both of them.

Upvotes: 0

cnu
cnu

Reputation: 37205

Maybe you can try using the ISpell dictionary for postgresql or Tsearch2 which has some spelling correction module.

Upvotes: 1

Related Questions