title: Sphinx search relevancy. Ranking, ordering, weight, keyword order
body: <p>I'm experiencing problems with relevance in Sphinx. I have a fairly easy out-of-the-box setup using SphinxQL, nothing fancy. My database has around 300k documents. Default ranking mode.</p>
  
  <p>Search query is, for example: "apple imac pro" (apple|imac|pro).</p>
  
  <p><strong>The result contains the following:</strong></p>
  
  <p>1 apple imac ...<br />
  2 apple imac ...<br />
  3-20. apple pro ...</p>
  
  <p>Now, of course there is no such thing as an "apple imac pro" in my database, but why does it skip to "apple pro" results, when there are more "apple imac" and/or "imac apple" results? Why does it skip to the "pro" part if "imac" is closer to the beginning of the line in the original search query?</p>
  
  <p>Does the order of keywords in the field affect the order/weight THAT much?</p>
  
  <p><strong>My expectation for the result would be:</strong></p>
  
  <ol>
  <li>Show all "apple imac pro" - there are none</li>
  <li>Show all "apple imac" or "imac apple" items</li>
  <li>Show all "apple pro" or "pro apple" items / show all "imac pro" or "pro imac" items</li>
  <li>Show all "apple" or "imac" or "pro" items </li>
  </ol>
  
  <p>This sort of thing seemed much easier to accomplish with the MySQL Full Text Search. The results would be much closer to what I expect, than what Sphinx gives me.</p>
  
  <p>I've tried changing the ranking mode to sph04, with no avail. </p>
  
  <p>Is there something I'm doing wrong? Is there anything I can do to "fix" this?</p>
  
  <p>Thanks in advance.</p>