Hi there everyone!
I have been trying to achieve a feature that would make search of a databse collection much more useful for site owners, that is, ranking or sorting query results by relevance/matching to the original input from the user in a search bar.
To further explain what I am trying to achieve, I propose the example:
Lets say that a user has searched for "red fast car" in my site.
Currently, if a user did this, all results that contain the word red, the word fast or the word car would pop up in no specific order, giving the user results, but not exactly what he/she is looking for. Let's say that 13 of my database collection items contain the word "red" or the word "car", two of them contain two words: "red" and "car" and one contains the three words: "red", "fast" and "car."
What I am trying to do is arrange these items so that the item that contains all three words (the most words matching the query, not necesarilly all), appears first, followed by those who contain 2 words, and lastly all other items that have 1 word macthing the query.
I would really appreciate any help I can get with this matter, I have been trying for some time, but no luck whatsoever. I really think this could be an upgrade to any wix site owner's UX and provide a great solution for everyone.
Thanks in advance!