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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

104 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
windlass1226608(None) 
windless123310861windless
kindless13289242kindless
mindless11319442mindless
rindless92510192rindless
windbags1544522windbags
windblast1543902windblast
windblasts1652852windblasts
windflaws1942402windflaws
windlassed1552032windlassed
windlasses1443052windlasses
windles113518492windl_es
windways1845042windways
wineglass1343142wineglass
wineless112711172wineless
wingless122910022wingless
winless103212282win_less
aidless83612073ai_dless
bindles104016453bindl_es
bondless1148813bondless
dindles93817243dindl_es
dwindles13366023dwindl_es
endless839833_endless
finless102810783fin_less
handless123512063handless
inclasp1145303_inclasp
inclasps1244353_inclasps
inkless11348713_inkless
inlays9389873_in_lays
innless7288293_innless
inulase739413_inulase
inulases838763_inulases
isinglass1042293isinglass
kindlers13318483kindlers
kindles123614843kindl_es
kindness13236653kindness
kingless13288693kingless
kinless113310273kin_less
landless94011173landless
landmass1144423landmass
lidless8309273li_dless
lineless82711943lineless
lintless82710013lintless
minilabs12124573minilabs
misclass1246843misclass
nonclass1046243nonclass
pingrass1146003pingrass
qindars17267423qind_ars
sandglass1143723sandglass
sandless93212343sandless
sinless73014213sin_less
sunglass945093sunglass
swindlers13306033swindlers
swindles12319503swindl_es
tintless8239863tintless
wardless12249303wardless
weedless12287963weedless
weldless12285813weldless
wickless1736083wickless
widdles123514343widdl_es
wifeless14277483wifeless
wigless11359673wi_gless
wildcats1444173wildcats
wildland1353843wildland
wildlands1443273wildlands
wildness1236203wildness
windage1237933wind_age
windages1338263windages
windbag1444123windba_g
winders113721263wind_ers
windfall1544203windfall
windfalls1643723windfalls
windflaw1842293windfla_w
windgall1343853windgall
windgalls1443133windgalls
windiest122213233windiest
windigos13484903windigos
windiness1337373windiness
windings13329973windings
windlassing1651823windlassing
windle104617953windl__e
windled123713483windl_ed
windlessly1743243windlessly
windling132212263windling
windlings14236723windlings
windowless1742353windowless
windows1447743wind_ows
windrows1546163windrows
winds95425603wind___s
windups1334783wind_ups
windward1665513windward
windwards1764513windwards
windway1745153windwa_y
winesaps1364553winesaps
winglets12299593winglets
winkles143412773winkl_es
wintles103414983wintl_es
wireless11249633wireless
wiseass1035823wi_seass
wishless1435993wishless
witless103310983wi_tless
woodless12278453woodless
wordless12258843wordless
woundless1334033woundless

Search took 7 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 Filter1786911461620.453394461.4
2DLD Change Limit1461621046.34323043.0
3Display Results1041040.0462260.9
 (SQL Overall)1786911046.84226116.8
 
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.