Best way to query posts and order by relevancy to query

I don’t think this can be cleanly expressed in WP query API. YOu can query for posts matching all of terms in a set or any of terms in a set, but there is no concept of how many terms matched.

You would need to write either:

  1. Very custom SQL for the query you want which will implement the counting.
  2. Query loosely everything that matches and do the coun on PHP side after getting results.

Related Posts:

  1. Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
  2. WP_Query orderby post__in remains ineffective in the Loop [closed]
  3. WP_Query orderby date not working
  4. Order by optional meta key?
  5. Sorting: custom query with orderby meta_value_num THEN by title
  6. Order by DESC, ASC in custom WP_Query
  7. WP_Query order by multiple meta keys & fields
  8. Secondary Sort (fallback) for WP_Query
  9. Query Posts in a Predefined Order
  10. How to get order of posts?
  11. Order posts by ID in the given order
  12. Custom WP_Query order by post_meta and (author) user_meta
  13. Sorting posts by custom date fields (non standard date format)
  14. Getting all user metadata from user
  15. How to order posts tag by tag?
  16. How do I order pages and categories by ID or name in the same query?
  17. WP_Query ordered by custom field that is a date string?
  18. WP_Query sort by comment meta data
  19. Searching user meta using WP_User_Query
  20. Order posts by tags count?
  21. Merge 2 args in one WP_Query and order it by date
  22. Orderby = none not working [duplicate]
  23. SQL query equivalent to WP User Query
  24. WP_query ‘orderby=none’ Problem
  25. Order posts by date and then by custom field
  26. How to order a post type with meta_value_num and if meta_value_num does not exist then order by date
  27. Revolution Slider Orderby Two Custom Fields
  28. Order posts ascending with number in title
  29. List taxonomy terms plus their latest post ordered by post date
  30. Order by the results of a function with WP_query
  31. How to order posts in wp_query by a meta_value of the corresponding author
  32. Order by menu structure
  33. WP_Query order by date in meta_value
  34. Query wp_usermeta alongside wp_users
  35. How to use order RAND() on WordPress?
  36. Show all parents and children in custom post type in right order
  37. Ordering by meta_value AND date NOT WORKING with wp_query
  38. WP_Query orderby breaks when using AJAX?
  39. Order WP Query posts by custom order calculated from post meta values
  40. Custom Post order for homepage
  41. Meta query with order by another custom field
  42. Change default ordering of taxonomy terms – pre_get_terms
  43. WordPress WP_Query orderby being overwritten
  44. WP_Query Order by Specific Post ID First
  45. Order Posts by meta value AND published date
  46. How can I pick a single post from the latest 3?
  47. Wp query orderby ‘title’ doesn’t work
  48. How can I order Wp_Query hierarchically?
  49. How do I sort posts with multiple pages
  50. Sorting posts DESC based on the number of comments using WP_Query
  51. Order WP_Query by multiple fields, subtracting them from one another
  52. Complex Orderby Parameters: How to query with multiple orderby parameters using meta_value_num?
  53. pre_get_posts order by not working
  54. Minimize database queries to user tables?
  55. WP_Query: custom orderby (not ASC nor DESC)
  56. WP_User_Query not searching numbers?
  57. Order & Orderby clause not working with custom query
  58. How to order posts, that have already been filtered by custom taxonomy, by their category names?
  59. wp_query sorting – one specific meta_key value at last and then sort by create date
  60. query_posts based on a meta_key
  61. Display three sequential posts on each page load, without repeating previous
  62. Order posts by more than one variable (meta_key and publish date AND time)
  63. Create custom order sortby based on array of id
  64. Best way to Order Post in Home without a plugin
  65. orderby in WP_QUERY – Use the order from the Dashboard
  66. Sort by meta key within same day
  67. Find by post_meta, then sort by post_meta, then sort by date (wp_posts)
  68. Query All Attachments and Order by Parent Publish Date
  69. Order Custom Field by Price
  70. WP_Query within save_post doesn’t include the item that triggered the action?
  71. Using orderby with 2 meta keys
  72. Order posts by custom column using pre_get_posts
  73. Add filter to Orderby Parameter using Array
  74. Order WP_Query results in order other than ASC or DESC
  75. Show sticky post before other WP_Query
  76. Custom query to order by multiple taxonomies
  77. Sorting: custom query with orderby meta_value_num THEN by title
  78. query_posts with sorting on a custom datestamp
  79. Get post closest to today
  80. Order by multiple meta keys on wordpress
  81. orderby in WP_query doesn’t works
  82. Posts2Posts, wp_query and orderby issue
  83. WP_Query with several meta_query-statements and order by meta_value
  84. How ‘secure’ are loops?
  85. Order by meta values
  86. Change posts archive ordering
  87. orderby and order filter in get_posts or WP_query function in wordpress not working
  88. Get all user with both meta_value
  89. Get posts that were most recently tagged
  90. Why does wp_query only display the most recent post when using order ASC?
  91. How to put posts with some taxonomy on top of others in `pre_get_posts`
  92. WP_Query sort by ACF date field (newest first) with blank dates first
  93. new WP_Query with order args – no more distinction between categories
  94. Orderby meta _value that is saved as an array
  95. Group users by meta field, with name of meta field as group title
  96. Sort wp_query of two post types using meta datefield for one and date for the other – possible?
  97. Conditionaly move certain posts at the bottom of the query result
  98. WordPress WP_Query custom order_by post_type functionality
  99. How do I group results from wp-query
  100. Custom tag template to list posts in ASC order
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)