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

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

146 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
walking15401330(None) 
balking143717351balking
calking144617781calking
talking123815821talking
waking144821381wa_king
waling104525301wal_ing
walkings16327311walkings
walling113520971walling
wanking154216781wanking
warking153519571warking
wauking153410011wauking
alkine104916802_alkine
asking116017232_asking
awaking1547812awaking
backing165523442backing
baking135626622ba_king
balding114015062balding
baling94829692bal_ing
balling104424762balling
banking144621352banking
barking144724182barking
basking144718612basking
baulking1536002baulking
bilking144413552bilking
bulking143815122bulking
caking134624672ca_king
calkin123515492calkin_
calkings15289222calkings
calkins133814872calkins
calling103826772calling
calming123915972calming
calving134113502calving
carking144322852carking
casking144317352casking
caulking1536802caulking
chalking183310062chalking
darking134217342darking
erlking1236702erlking
faking145520982fa_king
falling113621582falling
flaking154114492flaking
galling93921962galling
gasking134415912gasking
gawking16398822gawking
hacking173720612hacking
haling104229782hal_ing
haloing113814132haloing
halting114419072halting
halving143511542halving
hanking154619102hanking
harking154120942harking
hawking183711422hawking
holking153512312holking
hulking153910982hulking
jacking214515262jacking
jauking19418322jauking
lacking143821542lacking
laking115027042la_king
lalling83519622lalling
larking123718252larking
making134823852ma_king
malkin122913152malkin_
malkins133311802malkins
malling103623662malling
malting103219082malting
marking144020132marking
masking145116612masking
milking143712762milking
narking124015382narking
packing164420722packing
paiking143814812paiking
paling93530132pal_ing
palling104024482palling
palming123914012palming
palping124112872palping
parking143423042parking
racking144323662racking
raking114728422ra_king
ranking124320882ranking
sacking144122702sacking
salting84120792salting
salving113913152salving
silking123715592silking
slaking123717472slaking
stalking133512222stalking
sulking124514312sulking
swanking16399962swanking
tacking144421482tacking
taking114725952ta_king
talcing103111632talcing
talcking1567082talcking
talkings13358402talkings
tanking123918792tanking
tasking124616322tasking
valuing11298842valuing
valving14368552valving
wadding133711942wadding
wading114619532wa_ding
waffing173710242waffing
wafting143911662wafting
wagging133313352wagging
waging114318382wa_ging
waifing142910892waifing
wailing113620902wailing
wairing113414312wairing
waiting113618952waiting
waiving14329632waiving
waltzing2134262waltzing
waning103623802wa_ning
wanning113816212wanning
wanting114220172wanting
wapping153514602wapping
warding123918142warding
waring105029442wa_ring
warming133515082warming
warning113717092warning
warping133715182warping
warring113717972warring
washing145119282washing
wasting114422842wasting
wauling112713112wauling
waving134018202wa_ving
wawling143810962wawling
waxing174215282wa_xing
waxwing2154722waxwing
weakling16106762weakling
welding123213252welding
welkin1337312welkin_
welkins1437172welkins
welling112920312welling
welting113615312welting
whacking21377482whacking
whaling143910772whal_ing
wicking173414772wicking
wilding123814292wilding
wiling103024292wil_ing
willing113821612willing
wilting113515912wilting
winking153317962winking
wolfing14277892wolfing
working153813252working
wracking18349962wracking
wyling13368552wyl_ing
yacking174315682yacking
yakking14376422yakking
yanking154512462yanking

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 Filter1786911076710.1401276364.3
2DLD Change Limit1076711467.59614174.7
3Display Results1461460.0632317.5
 (SQL Overall)1786911467.79922912.0
 
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.