Postgres does lexemes and all that jazz natively. You want to be looking for tsvector related stuff. I used it a few years ago to do full text search on a sma

Postgres does lexemes and all that jazz natively. You want to be looking for tsvector related stuff. I used it a few years ago to do full text search on a smallish website and it was great, I gather it has improved further since.