Performing search on a column by query
Postgres Text Search supports prefix search

select 'housewarming'::tsvector @@ 'hou:*'::tsquery; --true


I looked at amazon's search, and guess what? ta doesn't return entertainment