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

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

46 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
boxboards214426(None) 
boxboard2044611boxboard_
bedboards15114872bedboards
bodyboards1943242bodyboards
bombards1536492bomb_ards
mopboards1643752mopboards
backboards2146193backboards
baseboards1545213baseboards
bedboard14115723bedboard_
billboards1544063billboards
boards94616933___boards
boatyards1543963boatyards
bodyboard1843303bodyboard_
bollards11339153bo_llards
bombard1437333bomb_ard_
bombloads1642443bombloa_ds
boneyards1584623boneyards
boobirds1344183boob_irds
boxballs19144233boxb_alls
boxcars1834773box_car_s
boxwoods2144183boxwo_ods
boyards13399323bo__yards
buckboards2143613buckboards
corkboards1944113corkboards
cupboards1643813cupboards
footboards1644083footboards
garboards1346363garboards
inboards1145843_inboards
keyboards1943963keyboards
lapboards14105373lapboards
larboards1246983larboards
leeboards1244793leeboards
moldboards1642793moldboards
mopboard1543983mopboard_
onboard1046503_onboard_
outboards1246213outboards
oxfords1842893_oxfo_rds
pegboards1544023pegboards
preboards1446423preboards
reboards1138773_reboards
rubboards1443283rubboards
seaboards1246443seaboards
skyboards1943773skyboards
snowboards1643693snowboards
tagboards1345133tagboards
teaboards1245393teaboards

Search took 8 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 Filter1786911486410.420425454.8
2DLD Change Limit148641466.70322175.3
3Display Results46460.0301533.3
 (SQL Overall)178691467.15324981.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.