Hi there, @another… do the keywords need to be in separate fields? If you store the keywords as a list and you have a list of keywords you are searching for, you could get the desired result (if I understand your last reply correctly) by doing a count of the intersect between the lists in 3 merged searches.
The first search would return users where a count of the intersect between their list of keywords and the list of keywords in the search is 3, the second merged search would return users where the count is 2, and the third merged search would return users where the count is 1.
True, the counts would have to be done in advanced filters, and having 3 merged searches with 3 advanced filters could have a performance impact. Still, it should produce the desired result of users with more matching keywords appearing first, so I didn’t think it could hurt to throw it out there as food for thought.
Best…
Mike