19

Clearly, Jon Skeet is a Stack Overflow user, but why doesn't this user name appear when typing "Skeet" on the users page (illustrated below)?


alt text

5

3 Answers 3

7

I was originally going to link some of the earlier posts which explain some of the oddities of the User Search (which prioritizes exact matches, like shown here).

However, it turns out that the algorithm was changed for Stack Overflow at some point. Search now only checks for strings that begin with the specified string. So for example, I won't find myself if I search for "comet".

5
  • 9
    No, the difference is just SO <-> everywhere else; this isn't new. %string% searches aren't indexable, and with a userbase as large as SO, that makes a huge difference.
    – balpha Staff
    Dec 3, 2010 at 14:56
  • 1
    @balpha Ah, so this is by design? Interesting. It makes sense, though.
    – Grace Note StaffMod
    Dec 3, 2010 at 14:56
  • 2
    See this answer by Jeff explaining that SO's user table has become too large to allow to support searching within the name.
    – sepp2k
    Dec 3, 2010 at 15:41
  • 1
    @sepp2k Interesting. August is actually quite a while back, but then again, June is even further back, so...
    – Grace Note StaffMod
    Dec 3, 2010 at 15:48
  • umm, then what is full text search for?
    – quantum
    Jul 7, 2012 at 23:47
10

Probably because the search is:

select username from users where username like '<search_string>%'

not

select username from users where username like '%<search_string>%'
1

A picture's worth a thousand words, right?

alt text

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .