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

139 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
druggies1112622(None) 
druggie10134081druggie_
druggier11134831druggier
druggiest12134971druggiest
buggies114613812_buggies
doggies103613022d_oggies
draggier11135772draggier
draggiest12126412draggiest
draggles1145962draggles
dreggier1193552dreggier
dreggiest12124542dreggiest
drudges10308872drudg_es
drugged11367182drugg_ed
drugget10337612drugg_et
druggets11313912druggets
drugging12326442drugging
druggist11163662druggist
druggists12112132druggists
luggies93011212_luggies
raggies93214732_raggies
rugbies10339352_rugbies
snuggies10246362snuggies
aggies83515513__aggies
argufies1243743argufies
baggies113814853_baggies
biggies113813523_biggies
bougies103715183bou_gies
braggier12136453braggier
braggiest13116783braggiest
brulyies1343423brulyies
brulzies1933983brulzies
brumbies1436533brumbies
budgies115312513_budgies
buggier113611343_buggier
buggiest123410363_buggiest
craggier12116063craggier
craggiest13116523craggiest
crummies1437643crummies
daggles103611913d_aggles
daubries1136743daubries
dauties83315763dau_ties
dhurries1255583dhurries
dinghies1347363dinghies
dingies93618243d_ingies
doggie93910893d_oggie_
doggier103810943d_oggier
doggiest113410523d_oggiest
dogies85022253d__ogies
doughier1335483doughier
doughiest1435783doughiest
dragees9359483dr_agees
dragged11379563dragg_ed
dragger10309173dragg_er
draggers11357393draggers
dragging12308103dragging
draggle1056103draggle_
draggled1254673draggled
draglines1145993draglines
drearies92313413drearies
dredges10379353dredg_es
dreggish1453133dreggish
dries64733673dr___ies
drogues9398393dr_ogues
dropsies1138703dropsies
droskies13186343droskies
drudge9317903drudg_e_
drudged11277613drudg_ed
drudger10328323drudg_er
drudgeries1343273drudgeries
drudgers11326853drudgers
drudging12256233drudging
druggy12344743drugg__y
drugs75214653dru_g__s
druids8368093dru__ids
drumbles13277723drumbles
drumfires1542553drumfires
drumlier1134523drumlier
drumliest1235433drumliest
drumlins1144993drumlins
drupes94912653dru__pes
druses75517253dru__ses
duchies133312313d_uchies
duckies143613813d_uckies
dummies123012133d_ummies
dungier9368583d_ungier
dungiest102810743d_ungiest
durries83817353d_urries
duties74921903d_u_ties
froggier1354643froggier
froggiest1434913froggiest
frugged13387293frugg_ed
frugging14317053frugging
fuggier12348963_fuggier
fuggiest13228813_fuggiest
groggier1134343groggier
groggiest1235093groggiest
grudges10349423grudg_es
grunges93310403grung_es
grungier1034983grungier
grungiest1135803grungiest
guggles103410543_guggles
jaggies163311083_jaggies
juggles164510843_juggles
luggie8318903_luggie_
moggies113111723_moggies
muggees11338883_muggees
muggier11288943_muggier
muggiest12228533_muggiest
muggins11248073_muggins
orgies72316093or__gies
piggies113813483_piggies
puggier11309383_puggier
puggiest12219223_puggiest
puggries12166383_puggries
raggees93710913_raggees
raggles93813283_raggles
reggaes948883_reggaes
roughies1298323roughies
rubbies114114113_rubbies
rubies84420343_ru_bies
rugged94215383_rugg_ed
rugger84414513_rugg_er
ruggers94612313_ruggers
rugging102512763_rugging
rummies113212793_rummies
smuggles12225443smuggles
snuggles10306143snuggles
staggies101210323staggies
struggles11255283struggles
swaggies13136693swaggies
thuggees1343123thuggees
toughies1278243toughies
trudges9339993trudg_es
trusties82712853trusties
uglies7412323__uglies
veggies1237553_veggies
vuggier12296813_vuggier
vuggiest13216923_vuggiest
wriggles13286263wriggles

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621396.98320931.1
3Display Results1391390.0632206.3
 (SQL Overall)1786911397.48223882.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.