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 “chessboards” with Change Limit: [1] [2] [3] [4] [5]

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

39 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
chessboards195191(None) 
chessboard1852001chessboard_
pressboards1652242pressboards
chalkboards2352553chalkboards
chipboards2093783ch_ipboards
headboards1744333_headboards
pressboard1553033pressboard_
baseboards1545214_baseboards
bedboards15114874_be_dboards
breadboards1752504breadboards
callboards1544974c_allboards
cardboards1645334c_ardboards
chalkboard2252634chalkboard_
checkerboards2761204checkerboards
chipboard1973994ch_ipboard_
chresards1543274chres__ards
clapboards17113674c_lapboards
clipboards17103014c_lipboards
corkboards1944114c_orkboards
crossbars1344434crossb_ar_s
crossroads1353064crossroa_ds
crosswords1643604crosswo_rds
cupboards1643814c__upboards
cusswords1542644c_usswo_rds
dashboards1743484_dashboards
flashboards2052474flashboards
freeboards1644474fre_eboards
fretboards1643674fre_tboards
hardboards1745164_hardboards
headboard1644934_headboard_
keyboards1943964_ke_yboards
leeboards1244794_le_eboards
pegboards1544024_pe_gboards
preboards1446424pre__boards
reboards1138774_re__boards
seaboards1246444_se_aboards
shipboards1894104sh_ipboards
teaboards1245394_te_aboards
washboards1944094_washboards

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 Filter1786911488190.1731032896.0
2DLD Change Limit148819399.50015665.2
3Display Results39390.0162437.5
 (SQL Overall)178691399.68918442.7
 
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.