Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “checkerboards” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

52 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
checkerboards276120(None) 
checkerboard2661301checkerboard_
centerboards1752603c_enterboards
beaverboards20142124_beaverboards
centerboard1652874c_enterboard_
chalkboards2352554chalk__boards
checkerberries277964checkerberries
checkerberry286834checkerb_erry
chessboards1951914che__ssboards
leaderboards1652054_leaderboards
rekeyboards2151894_re_keyboards
teeterboards1551904_teeterboards
backboards2146195_back__boards
beaverboard19142265_beaverboard_
blackboards2253835black__boards
buckboards2143615_buck__boards
chalkboard2252635chalk__board_
checkbooks22102355check__bo_oks
checkered2144685checker___ed_
checkers19317845checke____r_s
checkmarks2251985check___marks
checkrooms2352875check_r_o_oms
checkrowed2551865check_r_owed_
checkrows2342765check_r_o__ws
cheerleads1692515che__erlea_ds
chessboard1852005che__ssboard_
chipboards2093785ch___ipboards
chokebores2153025ch_oke_bo_res
corkboards1944115c_ork__boards
duckboards2042725_duck__boards
fiberboards1952615__fiberboards
fingerboards1951775_fingerboards
flutterboards1961285flutterboards
freeboards1644475fre__e_boards
headboards1744335_he__adboards
keyboards1943965____keyboards
kickboards1843355_kick__boards
leaderboard1552255_leaderboard_
leeboards1244795_le__e_boards
linerboards1452505__linerboards
motherboards2052315_motherboards
packboards2144445_pack__boards
paperboards1863655__paperboards
peckerwoods2351585_peckerwo_ods
plasterboards1881735plasterboards
rekeyboard2052045_re_keyboard_
scoreboards1653125__scoreboards
superboards1645715__superboards
tackboards1944365_tack__boards
teeterboard1452135_teeterboard_
wakeboards2044495__wake_boards
weatherboards2262605weatherboards

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911247900.390458182.1
2DLD Change Limit124790528.91014005.6
3Display Results52520.0301733.3
 (SQL Overall)178691529.33019152.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.