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

144 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
wriggly1532489(None) 
wiggly14559681w_iggly
wriggle12316211wriggle
giggly12518702_giggly
jiggly18378712_jiggly
niggly11418912_niggly
trigly103810942tri_gly
waggly14347292w_aggly
wiggle113713012w_iggle
wiggy134510732w_igg_y
wriggled14284662wriggled
wriggler13295262wriggler
wriggles13286262wriggles
wrinkly17295752wrinkly
wrongly1434552wrongly
aridly105513703ari_dly
biggy124413133_bigg_y
bigly114814753_bi_gly
boringly1438403boringly
braggy13337173bragg_y
briefly1534573briefly
brightly1764553brightly
briskly16165403briskly
bristly12178063bristly
brittly12165973brittly
craggily1543703craggily
craggy13396603cragg_y
cringle103010353cringle
crinkly16387523crinkly
crisply14426523crisply
cryingly1735743cryingly
daringly1348573daringly
draggle1056103draggle
draggy12346823dragg_y
dreggy12364633dregg_y
dribbly15274953dribbly
drily95816523dri__ly
drizzly19364553drizzly
druggy12344743drugg_y
erringly1237773erringly
friarly13316213friarly
frigged13439053frigged
frigidly1643123frigidly
frilly124111443fri_lly
fringy13309263fring_y
frizzly21455793frizzly
froggy1434493frogg_y
giggle94313513_giggle
goggly12337053_goggly
grimily1336523grimily
grimly12459933gri_mly
grisly104310583gri_sly
gristly11187333gristly
grizzly19354473grizzly
groggily1443283groggily
groggy1234803grogg_y
higgle113811743_higgle
highly1636823_highly
jiggle153811993_jiggle
jiggy17549143_jigg_y
jingly174111933_jingly
kingly143511303_kingly
luringly1237323luringly
lyingly14115263lyingly
miggle104012113_miggle
niggle83612823_niggle
piggy124011433_pigg_y
pricily142710283pricily
prickly18367893prickly
prigged12398933prigged
priggery1543993priggery
primely1457723primely
primly13439623pri_mly
priorly12335763priorly
privily15207623privily
pryingly1735543pryingly
raggle83712883_raggle
raggy106116573_ragg_y
richly1438013_richly
ridgy104110643_ridg_y
rifely123710033_rifely
rigged94517403_rigged
rigger85616713_rigger
rightly14389043_rightly
righty135011833_righty
rigidly1235533_rigidly
ripely112511153_ripely
ripply13348003_ripply
scraggly15294143scraggly
shingly143210813shingly
singly104015853_singly
sniggle9316833sniggle
spriggy14374213sprigg_y
squiggly2242503squiggly
straggly13355563straggly
tingly103815983_tingly
trickly16369893trickly
trigged10359853trigged
trigger9329163trigger
trimly114410893tri_mly
triply114211023tri_ply
tritely1039003tritely
tryingly1535883tryingly
twiggy1432933twigg_y
urgingly1336733urgingly
vyingly1794153vyingly
waggle113612303w_aggle
warily122915093wari__ly
warningly1635513warningly
wearingly1636413wearingly
weigela1143073weigela
weighty17376233weighty
weirdly14274493weirdly
whirly15448863whi_rly
whitely16346473whitely
widely133311033w_idely
wifely15429423w_ifely
wigged124413583w_igged
wiggery15295873w_iggery
wiggled13299603w_iggled
wiggler123110763w_iggler
wiggles123312463w_iggles
wildly13328123w_ildly
wilily123310763w_ilily
willy115321913w_i_lly
wily106428813w_i__ly
wingy126521033w_ing_y
wirily123310783w_irily
wisely122711713w_isely
wooingly1534903wooingly
wrangle1137383wrangle
wrigglers14273713wrigglers
wrigglier1462413wrigglier
wriggling1533813wriggling
wright133713513wri_ght
wrights14318993wrights
wring95920713wring__
wringed123710193wringed
wringer113612453wringer
wrings104012973wring_s
wrinkle14296923wrinkle
wristy12509703wri_sty
writerly1444153writerly
wryly14356703wr__yly

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271446.26621389.6
3Display Results1441440.0463130.4
 (SQL Overall)1786911446.71826598.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.