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

122 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
twiddly1523377(None) 
tiddly11308781t_iddly
twiddle12305481twiddle
diddly12389572_diddly
fiddly14328482_fiddly
piddly13319142_piddly
thirdly1444632thirdly
tidily102811392t_idily
twaddle12245712twaddle
twiddled14284632twiddled
twiddler13244872twiddler
twiddles13265612twiddles
twinkly1733912twinkly
twirly12427082twi_rly
waddly14478722_waddly
widdle113814842_widdle
widdy136112182_widd_y
widely133311032_widely
wildly13328122_wildly
acidly125211793aci_dly
aridly105513703ari_dly
avidly13548783avi_dly
biddy124612693_bidd_y
blindly1335743blindly
buirdly1334213buirdly
childly1644803childly
cuddly13388413_cuddly
diddle94915213_diddle
diddley13388103_diddley
dwindle12415883dwindle
fiddle113613383_fiddle
giddily1335073_giddily
giddy115810203_gidd_y
griddle1035503griddle
idly85617323__i_dly
kiddy144910283_kidd_y
kindly14358843_kindly
lairdly1134913lairdly
midday13327503_midday
middle103414983_middle
middy124812593_midd_y
mildly12318243_mildly
muddly13418603_muddly
oddly1037163__oddly
piddle103514913_piddle
puddly13438133_puddly
riddle83915713_riddle
skiddy1533633skidd_y
snidely1136813snidely
spindly13257383spindly
staidly1136683stai_dly
swaddle12276743swaddle
swidden1234233swidden
swiftly1633733swiftly
swindle11389183swindle
swirly12439253swi_rly
swithly1634443swithly
tardily11269583tardily
teddy10489493t_edd_y
tepidly1334413tepidly
thickly19415573thickly
thinly1238673thi_nly
thistly1395963thistly
tidal64516443t_idal_
tidally1137933t_idally
tiddler93110003t_iddler
tidy86822423t_i_d_y
timely113410113t_imely
timidly1334593timidly
tingly103815973t_ingly
tinily94014433t_inily
tinkly134811153t_inkly
tiredly1136803tiredly
toddle85811033t_oddle
toddy106812423t_odd_y
towardly1543653towardly
treddle936433treddle
trickly16369893trickly
trigly103810943tri_gly
trimly114410893tri_mly
trindle83311363trindle
triply114211023tri_ply
tritely1039003tritely
tumidly1333743tumidly
twaddled14254623twaddled
twaddler13314643twaddler
twaddles13315723twaddles
tweedle1134193tweedle
tweedy13455933tweed_y
twibil1133563twibil_
twibill1242743twibill
twibils1253113twibils
twiddlers14313693twiddlers
twiddlier1441863twiddlier
twiddling1543083twiddling
twiggy1432933twi_ggy
twill85612723twi__ll
twills9489793twi_lls
twinkle1464773twinkle
twiny116012813twi__ny
twirl85011943twi_rl_
twirls9478123twi_rls
twisty12426863twi_sty
twitchy18393573twitchy
waddle114715303_waddle
waddy135312993_wadd_y
weirdly14274493weirdly
widder112913973_widder
widdie113410733_widdie
widdled133511233_widdled
widdles123514343_widdles
wieldy13476183_wieldy
wifely15429423_wifely
wiggly14559683_wiggly
wilily123310763_wilily
willy115321913_wi_lly
wily106428813_wi__ly
windily1437943_windily
windle104617953_windle
windy126118103_wind_y
wirily123310783_wirily
wisely122711713_wisely

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271227.07618941.1
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.52823736.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.