We just need a fuzzy dictionary for each one, have a user poll for generating the fuzzy names for them or something.
I was having flashbacks to doing fuzzy matches in sql, then realized that the number of emojis isn’t too crazy. Could probably cache the common searches people are doing too.
Oh yeah, I guess fuzzy search is the wrong term to use as it implies the SQL tools. What would really work is just a list of alternative names that the emote goes by attached to it’s record.
Or if possible a hashed table where each alternative name returns a pointer to the correct name.
Oh yeah, I guess fuzzy search is the wrong term to use as it implies the SQL tools
Nah, that’s not what I meant. I’ve just had to do fuzzy search before in sql, and the issue is that fuzzy matching doesn’t scale well. It’s nightmarish how long it takes if you don’t do proper filtering ahead of time (and have a table with 10s of millions of rows).
