Order SQL search results by how many fields match

Order SQL search results by how many fields match

My question is, if I have fields like: rooms, district, bathrooms,
floor_material etc. then how can I order my Query results by the number of
field matches?
How do I check before echoing, how many fields match? Also, I don't want
to display results, where all fields match, but also results where 50%
result match, these should be in the bottom.
Also the script should show what fields don't match.
Where should I start?
Thanks in advance, Otto