I was fairly certain @TechnoBear was on to something with words being in lists, but try as I might, no repro.
I though it might involve re-categorizing a topic somehow breaking the foreign key. But some topics have been, others haven’t
I thought maybe it was the time gap post or other non-post posts. somehow breaking the post numbering. Again, some topics have them, others don’t
I thought it might be a non-English Accept-Language header that didn’t have a matching locale.
allow user locale and enabled
set locale from accept language header then set my browser language to Hindi (hi) in honor of our most frequent visitors, created a new account and made a post.
post_search_data locale field was set to the default en.
I set the default to Spanish (es) had SpanishGuy1 make a post.
Switched the locale bank to English (en)
post_search_data locale field is es.
But words in that post still come up in the in-topic search.
I looked at the profiler queries,
It seems a bit wasteful to hit the database multiple times as the word is being typed out, but such is the cost of a “live” search.
I don’t know how to check it but maybe the multiple queries are crashing something. Or if they are aborting, maybe earlier finds are discarded. eg.
t - r - e - query finds a match
t - r - e - n - new query finds a match
t - r - e - n - d - new query finds a match
t - r - e - n - d - i - last query finds matching words
Not so easy to go simply by post sequence as different matches have different weight.
And then, if you copy - paste which I’m assuming equates to a single “keydown” the results are no different than if the letters were typed singly.