Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Fuzzy Search Testing on Card Database #82

AlanOC91 opened this issue Jul 8, 2019 · 3 comments


Copy link

commented Jul 8, 2019

I've implemented v1 of Fuzzy Search testing on our Card Database.

This does not apply to the filters in advanced card search.

The main search bar (top of the page) but homepage search bar will be using this.


  • This example assumes the user is not using our auto-complete feature.
  • The user uses the following search term: "blue eyes white dragon".
  • The system does an exact card name match against the database.
  • Normally this would fail with 0 results since the actual card is "Blue-Eyes White Dragon".
  • Since 0 results are returned, it uses it's fallback option which is MySQL Full Text Search.
  • This will return cards based on relevance of the keywords entered. In this case, "Blue-Eyes White Dragon" is returned as the card with the highest relevance.
  • Finally, if MySQL Full Text Search also returns 0 results, bring the user to the search page.

Examples so far:

  • blue eyes white dragon = Blue-Eyes White Dragon
  • dark magic girl = Dark Magician Girl
  • genie of the lamp = La Jinn the Mystical Genie of the Lamp
  • inspector board = Inspector Boarder
  • ultimate moth = Perfectly Ultimate Great Moth
  • borreload = Borreload Dragon
  • called grave = Called by the Grave

And so on.
This is a work in progress but should enhance the search system.


This comment has been minimized.

Copy link
Owner Author

commented Jul 11, 2019

Plans for the next version include:

  • An exact match is done on the card but but it will also do an exact match minus special characters (- , . # ' : )
  • It will then move on and do the MySQL Full Text Search

I'm also looking at refining the Full Text Search results slightly.


This comment has been minimized.

Copy link
Owner Author

commented Jul 22, 2019

New updated to make "Number" cards easily accessible. These cards don't work with Fuzzy Searching because the actual number is ignored.

So typing "Number 42" is seen simply as "Number" and will provide a random number card.

I'm pushing out an update within the next hour that fixes this.

So by then, typing "Number 42" will bring you to "Number 42: Galaxy Tomahawk"


This comment has been minimized.

Copy link
Owner Author

commented Jul 22, 2019

Number change is now live.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
None yet
1 participant
You can’t perform that action at this time.