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

378 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
nugget831172(None) 
nuggets936381nuggets
nuggety1234311nuggety
budget104618112budget
bugged114318402bugged
bugger104418722bugger
drugget10337612drugget
fugged124615382fugged
guglet84018222guglet
hogget114715762hogget
hugged124113642hugged
hugger114713122hugger
jugged163813932jugged
lugged94417062lugged
lugger83916552lugger
mugged114113832mugged
muggee103612832muggee
mugger103914702mugger
nagged93916052nagged
nagger84016122nagger
nidget83715632nidget
nigger89713572nigger
nogged95716332nogged
nudge74616422nudge_
nudged95511832nudged
nudger85111632nudger
nudges84114732nudges
nutlet64220562nutlet
pugged114314532pugged
rugged94215382rugged
rugger84414512rugger
snugged10408032snugged
snugger9318312snugger
snuggest1045242snuggest
suggest9310862suggest
tugged93813522tugged
tugger84013102tugger
agger76420893_agger
aglet65534143_aglet
aiglet74224193aiglet
aigret73720023aigret
auger64922473au_ger
aught95120703au_ght
augite7312613augite
augment10910203augment
august739203august
auklet104216833auklet
bagged114519903bagged
bagger104619203bagger
baguet9316103baguet
beget85632553_beget
begged115013803begged
bigger104315063bigger
biggest1138143biggest
biggety1434433biggety
bogged116019283bogged
bucket144620733bucket
budge94619873budge_
budged114517233budged
budger104617703budger
budges104820123budges
budgets11489863budgets
buffet143113783buffet
buggers114315663buggers
buggery14367933buggery
buggier113611343buggier
buggies114613813buggies
buggiest123410363buggiest
buggy124613483bugg_y
bugle84721943bugle_
bugled104918133bugled
bugler94717723bugler
bugles94822443bugles
bugout9311863bugout
bulge86419873bulge_
bulged105117123bulged
bulger94917353bulger
bulges95919323bulges
bullet84528613bullet
bunged105218793bunged
bungee96319773bungee
buret77444013bu_ret
burgee97120593burgee
burger94020793burger
burnet84326173burnet
chugged1584823chugged
chugger1445373chugger
cogged116416613cogged
cudgel1036693cudgel
culet76040343cu_let
cullet84727313cullet
curet75447643cu_ret
curvet114720243curvet
cutlet84924363cutlet
cygnet1237893cygnet
dagger95017303dagger
digged104314653digged
digger94616083digger
dogged106017703dogged
dogger95216783dogger
drugged11367183drugged
druggets11313913druggets
duet56446263du__et
dugout8310363dugout
dulcet9314493dulcet
dunged95414693dunged
duvet9321873du_vet
eaglet73722583eaglet
egged85114383_egged
egger74414403_egger
egret63327313_egret
fagged124717703fagged
faggot1139053faggot
fidget114216473fidget
figged124013893figged
fogged125518373fogged
fogger114414783fogger
forget106326393forget
frugged13387293frugged
fudge105315523fudge_
fudged125212813fudged
fudges114314493fudges
fuggier12348963fuggier
fuggiest13228813fuggiest
fuggy135411673fugg_y
fugle94915543fugle_
fugled114813693fugled
fugles104715783fugles
fugue94313373fugue_
fugued11478713fugued
fugues104511683fugues
fulgent1138903fulgent
fumet105630223fu_met
gadget93616173gadget
gagged104817153gagged
gagger95016513gagger
garget84327273garget
get47467463___get
gigged104112293gigged
giglet83920273giglet
glugged11396623glugged
goglet84618583goglet
gorget87123863gorget
guggle94110433guggle
guggled11338563guggled
guggles103410543guggles
guglets9369693guglets
gullet74924833gullet
gurge75419783gurge_
gurged95513363gurged
gurges84716863gurges
gurglet94412033gurglet
gurnet74920873gurnet
gusset7316433gusset
hagged124317703hagged
hogged125817773hogged
hogger114615083hogger
hoggets12498323hoggets
huge86321653hu_ge_
huger94914873hu_ger
hugest10311763hugest
huggers124211593huggers
hunger104015203hunger
igged86012763_igged
jagged164115353jagged
jagger154016003jagger
jigged164412773jigged
jigger155313053jigger
jogged166015923jogged
jogger154713163jogger
judge144714153judge_
judged165911253judged
judger154411443judger
judges153713453judges
jugate14379463jugate
juggle154310283juggle
juggled17348653juggled
juggler16418873juggler
juggles164510843juggles
junket173815023junket
kegged13469243kegged
kegger12388063kegger
kugel1068563ku_gel
lagged95520133lagged
lagger85919833lagger
legged95713083legged
logged96622943logged
logger86420003logger
loggets9378913loggets
luge55531643lu_ge_
luged74019093lu_ged
luger65322083lu_ger
luges65928753lu_ges
luggers93713483luggers
luggie8318903luggie
luggies93011213luggies
lunet56835423lu_net
lunge65323803lunge_
lunged85418273lunged
lungee75119813lungee
lunger75720423lunger
lunges76123423lunges
maggot10311713maggot
magnet9320663magnet
midget103718443midget
mogged115215393mogged
mugg86316013mugg__
muggar10316443muggar
muggees11338883muggees
muggers113611933muggers
muggier11288943muggier
muggiest12228533muggiest
muggs94912323mugg_s
muggur10325593muggur
muggy125612373mugg_y
mullet84126823mullet
musket122818203musket
naggers93812653naggers
naggier9309153naggier
naggiest102610013naggiest
naggy106612823nagg_y
naught104312493naught
negate72915573negate
neglect1047363neglect
net36670293n___et
ngwee9311073n_gwee
nidgets9358143nidgets
niggers93111323niggers
niggle83612823niggle
niggled10319203niggled
niggler93610293niggler
niggles93512203niggles
niggly11418913niggly
nighed113811293nighed
nigher103612753nigher
nighest11310693nighest
night94327853n_ight
nogg65115943nogg__
noggin8288883noggin
noggs75811183nogg_s
nonet54540843n_onet
nougat74712653nougat
nought104713963nought
nuclei857723nuclei
nude56626273nu_de_
nuder66416833nu_der
nudes64723293nu_des
nudest74113833nudest
nudgers9479373nudgers
nudie65118673nudie_
nudies75217093nudies
nudist73813323nudist
nuke85920753nu_ke_
nuked104014183nu_ked
nukes95418123nu_kes
nulled74318273nulled
numbat10312083numbat
numbed114111443numbed
number103913223number
numbest1138793numbest
numen74216793nu_men
nurled74016233nurled
nurse54420123nurse_
nursed74514663nursed
nurser64314503nurser
nurses63919353nurses
nut36651963nu___t
nutant6316383nutant
nutate63017373nutate
nutlets74111253nutlets
nutmeat947953nutmeat
nutmeg9124613nutmeg
nutted74316973nutted
nutter63918053nutter
ought95221533ou_ght
outlet63728683outlet
outset64027453outset
parget94529393parget
pegged114811903pegged
pigged114214153pigged
piglet93420923piglet
plugged12408043plugged
plugger11378433plugger
puggier11309383puggier
puggiest12219223puggiest
puggree11176113puggree
puggry13374823puggry
puggy124612323pugg_y
pugree92112473pugree
pullet84026333pullet
pungent10311233pungent
punnet83518843punnet
puppet93514593puppet
purge85324603purge_
purged104918263purged
purger94717233purger
purges94421763purges
quiet144530733qu_iet
ragged94620263ragged
raggee84217603raggee
reglet73724233reglet
regret73723533regret
rigged94517403rigged
rigger85616713rigger
rugae65114763rugae_
rugate75813813rugate
ruggers94612313ruggers
runlet63821413runlet
russet6319433russet
sagged94120013sagged
sagger84321073sagger
signet73621153signet
slugged104410383slugged
slugger93610683slugger
smugger11327053smugger
smuggest1244373smuggest
snagged104010673snagged
snigger9328373snigger
sniglet83612413sniglet
snogged10417973snogged
snuggery13253973snuggery
snuggies10246363snuggies
snuggle9275713snuggle
snuggled11234953snuggled
snuggles10306143snuggles
sogged95518523sogged
sublet82827243sublet
subnet82520933subnet
subset83122583subset
suet46754823su__et
suggests1044713suggests
sughed113610203sughed
sunket103721363sunket
sunset63723633sunset
surge65027693surge_
surged84118883surged
surger74320093surger
surges73924593surges
tagged93418123tagged
tagger84017703tagger
target75028903target
thuggee1245263thuggee
togged95117513togged
tucket124219483tucket
tuffet122612083tuffet
tuggers93711443tuggers
turgent8712393turgent
turret63121853turret
unaged83916423unaged
ungirt71112713ungirt
ungot61718063_ungot
unguent839123unguent
ungues7412123ungues
unlet54133333_unlet
unmeet83815743unmeet
unmet74426393_unmet
unset54532433_unset
unurged939143unurged
unwet84423173_unwet
upset73222593_upset
urge54722413_urge_
urged75316033_urged
urgent73816043_urgent
urger64116473_urger
urges64619913_urges
vegged124910013vegged
vugg95612713vugg__
vuggier12296813vuggier
vuggiest13216923vuggiest
vuggs10579133vugg_s
vuggy13589483vugg_y
wagged124616123wagged
wagger113616013wagger
widget113815253widget
wigged124413583wigged
wiglet105519153wiglet
zagged183612513zagged
zigged184110193zigged

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163785.12621989.1
3Display Results3783780.1063566.0
 (SQL Overall)1786913785.37233263.4
 
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.