Let's say I have table like below
1 aktiv gesellschaft
2 aktien gesellschaft
I'd like to ask if there is any way where I could do a fuzzy search with OR like :
SELECT TO_DECIMAL(SCORE(),3,2) AS score, id, companyname FROM companies WHERE CONTAINS(companyname, 'aktiv OR gesellschaft') ORDER BY score DESC, id;
and get score of 1 for both records (since both of them do contain aktiv OR gesellschaft), basically I'm interested to get score of 1.0 if any of the predicates in fuzzy search is present.