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 “twiddling” 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.

123 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
twiddling154308(None) 
twaddling1552711twaddling
widdling14228741_widdling
diddling12228742_diddling
dwindling15123792dwindling
fiddling14217872_fiddling
griddling1333932griddling
middling13249342_middling
piddling13208952_piddling
riddling11249442_riddling
swaddling1543812swaddling
swindling14135832swindling
toddling11187002t_oddling
treddling1234422treddling
trindling1137132trindling
tweedling1442532tweedling
twiddlier1441862twiddlier
twilling12268672twi_lling
twinkling1743642twinkling
twirling12246242twi_rling
waddling14237932_waddling
wildling13248082_wildling
windling132212262_windling
addling10229833__addling
bidding123613513_bidd_ing
bridling122610583bri_dling
coddling13258473_coddling
cuddling13287653_cuddling
daddling12258233_daddling
dindling112411163_dindling
fuddling14247153_fuddling
giddying1533783_giddying
girdling1146823_girdling
huddling14227293_huddling
idling8912883__i_dling
kidding14389773_kidd_ing
kindling14229623_kindling
lidding103611433_lidd_ing
meddling13257933_meddling
middlings14194313_middlings
muddling13268593_muddling
noddling11237263_noddling
paddling13218643_paddling
peddling13217973_peddling
pindling122110983_pindling
puddling13218033_puddling
raddling11229773_raddling
reddling112911813_reddling
ridding103314193_ridd_ing
ridgling11258203_ridgling
ruddling11228553_ruddling
saddling11239593_saddling
sideling101012183_sideling
sidling9915423_si_dling
skidding1535463skidd_ing
spindling13136273spindling
straddling1343643straddling
swilling123511933swi_lling
swingling14156203swingling
swirling12249143swi_rling
swiveling1634573swiveling
swizzling2142493swizzling
tailing82923103tai__ling
tedding103210883t_edd_ing
thirling12248583thi_rling
thudding1433983thudd_ing
tickling15309433t_ickling
tiding83520093t_i_d_ing
tidying1238513t_i_dying
tiling73426553t_i__ling
tilling83522783t_i_lling
tingling102210823t_ingling
tinkling13239233t_inkling
tippling13196703t_ippling
tirling83315733t_i_rling
titling83715793t_i_tling
toiling83219023toi__ling
treadling1137503treadling
trickling1647723trickling
trifling122411503tri_fling
trilling92815963tri_lling
tripling112712553tri_pling
trundling1135003trundling
twangling1434453twangling
twattling1332693twattling
twiddle12305483twiddl__e
twiddled14284633twiddl_ed
twiddler13244873twiddl_er
twiddlers14313693twiddlers
twiddles13265613twiddl_es
twiddliest1542023twiddliest
twiddly15233773twiddl__y
twigging14305673twi_gging
twillings13234913twi_llings
twingeing14143393twingeing
twinging13278423twi_nging
twining113211443twi__ning
twinklings1841883twinklings
twinning12367043twi_nning
twisting12427813twi_sting
twitching1834243twitching
twitting12307223twi_tting
unriddling1342633unriddling
wadding133711943_wadd_ing
waddying17204723_waddying
wedding133411873_wedd_ing
wedeling1338773_wedeling
whidding1734573whidd_ing
widening13237833_widening
widowing1635183_widowing
wielding13286863_wielding
wiggling14217293_wiggling
wilding123814293_wild_ing
wildlings14244923_wildlings
wiling103024293_wi__ling
willing113821613_wi_lling
wimbling16186543_wimbling
wimpling16207483_wimpling
winding123517913_wind_ing
windlings14236723_windlings
winkling16298293_winkling
wintling12249923_wintling
witling113215813_wi_tling

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 Limit1486411237.28320409.3
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.74923059.9
 
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.