It can be partial or full. The best would be to return by accuracy. For example, returns all item_ids, which are 80% similar to the keyword.
I know full-text searching works well with tsearch2 (oacs pkg). I'll need to build the integration though. https://openacs.org/doc/tsearch2-driver/
Is that path you were trying to go?