Database full text search capabilities/limits?

Ahh… So, probably some misunderstanding on my part here. I thought that you meant that the database couldn’t differentiate between an exact match and a contains match.

In the context of prioritizing matches in topic titles, as we were originally discussing:

  • I’d actually call all three of your examples “Exact matches” for the purpose of my intent.
  • “There is a term you can Search” would be a “contains” match.

  • Your three examples are equal in ranking. Just list them in the order that they are found.
  • My example ranks below them
  • They all, though, rank before any posts that are matching/relevant only because of post content without the title.

If you’re concerned that top search results will get flooded with “Title” matches, only use the title search when the search term has reached a minimum complexity level. Target is at most 4/5 “Title” matches at the top of search results. (Though I see that would probably be difficult to figure out)