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 “nuts” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

343 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
nuts4503267(None) 
buts67247691buts
cuts65841151cuts
guts56637251guts
huts76737441huts
juts115930161juts
muts64839981muts
nets45941531nets
nits45741641nits
nubs65927141nubs
nuns45228231nuns
nus37939391nu_s
nut36651961nut_
nutsy85711501nutsy
outs45746961outs
puts65641751puts
ruts44541491ruts
tuts45838451tuts
uts35534371_uts
abuts75417072abuts
acts66929862acts
aits46355532aits
alts46639902alts
ants47243472ants
anus47131112anu_s
arts49650262arts
auks85525262auks
aunts55227632aunts
auto47432082auto
autos56523322autos
bats66962332bats
bets67051442bets
bhuts105812952bhuts
bits66148152bits
bots66453952bots
bouts75131312bouts
bruts75922952bruts
bubs86235492bubs
buds75235172buds
bugs76035912bugs
bums85934592bums
buns66243722buns
bunts75729802bunts
burs65847422burs
bus56950972bu_s
buss65134912buss
bust65947782bust
busts75227692busts
but55963022but_
bute66739672bute
butes714535872butes
butt65143742butt
butts75824252butts
buys95726792buys
cats66356342cats
cots68054842cots
cubs85832382cubs
cuds76730472cuds
cues65438982cues
cults75022552cults
cunts76125122cunts
cups85430822cups
curs65645542curs
cuss65430612cuss
cut57957662cut_
cute66440452cute
cutes79438312cutes
cutis77723752cutis
dauts67822242dauts
dits56450522dits
donuts7410582donuts
dots55647662dots
dubs78432192dubs
ducts85319892ducts
duds65530142duds
dues56045502dues
duets65323882duets
dugs614832282dugs
duits65021882duits
duns55140432duns
dunts65828412dunts
duos56728132duos
dups75929512dups
dust57142532dust
dusts65923562dusts
duty85321452duty
eats47054872eats
efts76519482efts
fats76252502fats
fets75345942fets
fits76043462fits
fubs96328792fubs
fuds86528562fuds
fugs85730692fugs
funs75235732funs
furs76735042furs
fuss76027932fuss
futz167823802futz
gats56753442gats
gets55442482gets
gits55744592gits
gluts66120132gluts
gnats65217712gnats
gnus56518002gnu_s
gouts64826172gouts
guls55930852guls
gums75030942gums
guns55533482guns
gust55240702gust
gusts65722792gusts
gut46753852gut_
gutsy96412842gutsy
guvs85816812guvs
guys85019642guys
hats76858252hats
hets75547202hets
hits75545132hits
hots78349322hots
hubs96027142hubs
hues75235232hues
hugs86129752hugs
hums96831422hums
huns76136932huns
hunts86826172hunts
hurts86922822hurts
hut66457292hut_
inputs837702inputs
its35538832_its
jets115834102jets
jots116336142jots
jugs125525602jugs
jus106930222ju_s
just115433342just
justs124918262justs
jut105944012jut_
jute115327892jute
jutes125125132jutes
kats85944332kats
kits86441762kits
knits93914742knits
knots95614722knots
knouts10438312knouts
knurs94511152knurs
kues86426772kues
lats45962702lats
lets47147942lets
lits46252492lits
lots47652092lots
louts56330272louts
lues45943552lues
lugs55233522lugs
lums65734242lums
lunts55826902lunts
lust47442602lust
lusts55022802lusts
lute46341012lute
lutes55836662lutes
lutz136826322lutz
luvs75818502luvs
mats65460282mats
mauts75927192mauts
mots66853162mots
muds75530652muds
mugs76232042mugs
mums85732772mums
muns65535912muns
mus55946752mu_s
muss64933762muss
must65145442must
musts75527442musts
mut58357182mut_
mute65136872mute
mutes75033782mutes
mutt65739402mutt
mutts75120252mutts
nabs66236192nabs
nags55436022nags
nans46139392nans
naos47429732naos
naps66238582naps
nates55238332nates
nays75931592nays
neats55931902neats
nebs66124982nebs
negs55727362negs
nerts55924982nerts
ness45526562ness
nest45548732nest
nests55728002nests
net36670292net_
nett46643232nett
netts55320722netts
neuks96510862neuks
neums75414252neums
news76127372news
newts86015282newts
nibs65028302nibs
nils46132452nils
nims66226882nims
nips65830922nips
nit37065942nit_
nite45943582nite
nites55736342nites
nobs66436902nobs
nods55838222nods
noes45845392noes
nogs56534612nogs
noms65636402noms
nos38859322n_os
not39474662not_
nota46830772nota
note46239962note
notes55034582notes
nouns56717312nouns
nous46136982nous
nows75738232nows
nowts86915852nowts
nth66320592n_th
nu26331952nu__
nub56439142nu_b
nude56626272nude
nudes64723292nudes
nuke85920752nuke
nukes95418122nukes
null45125312null
nulls55019982nulls
numb85520612numb
numbs94913092numbs
nun35537742nu_n
nurd56224342nurd
nurds65518522nurds
nurl45327242nurl
nurls55519682nurls
nurse54420122nurse
nutty84816872nutty
oats46554212oats
onus45826812onu_s
oots46446442oots
opts68124742opts
orts46538332orts
ouds56430102ouds
ours47237562ours
oust46747442oust
ousts55225702ousts
out38072152out_
pats66460852pats
pets66248332pets
phuts104613502phuts
pits66348742pits
pots66452362pots
pouts75530322pouts
pubs85029212pubs
puds75630512puds
pugs76332772pugs
puls65437562puls
puns66641482puns
punts75828002punts
pups86032232pups
purs65641042purs
pus55547842pu_s
puss64830132puss
put55759072put_
putt66937842putt
putts75719272putts
putz158326322putz
qats135331342qats
quits144122352quits
rats46260372rats
rets45352562rets
rots46454092rots
routs57133412routs
rubs66133492rubs
rues46044482rues
rugs56033682rugs
rums64833472rums
runs46438072runs
runts55927632runts
rust45544912rust
rusts55026992rusts
rut35560522rut_
ruth76825992ruth
ruths85714642ruths
scuts74522522scuts
sets45549502sets
shuts85622472shuts
sits45050202sits
sluts54523982sluts
smuts75415712smuts
snits54124832snits
snots55225102snots
snouts64915862snouts
snubs75412552snubs
snugs64913022snugs
sots45552442sots
subs66037122subs
suds56135292suds
sues46247652sues
suets55126102suets
suits55028052suits
suks85927122suks
sums65837582sums
suns45841902suns
sups64834432sups
suqs134319652suqs
suss45229302suss
tats46858132tats
tauts56125512tauts
tets45847452tets
tits46145032tits
tots46654122tots
touts54830392touts
tubs65430062tubs
tufts85713272tufts
tugs56231672tugs
tuis44829642tuis
tuns45138662tuns
tups65628762tups
tut36758092tut_
tutu48423172tutu
tutus55214812tutus
units54923432units
uns35936752_uns
unto45824282unto
ups55629052_ups
us26937432_u_s
ut28647032_ut_
uta37425582_uta
utas45924952_utas
ute35335882_ute
utes45930882_utes
vats76841742vats
vets76835092vets
vugs87022872vugs
wats77555882wats
wets75940292wets
wits76044872wits
wots76342892wots
wuss75219332wuss
yuks116418022yuks
yups96121602yups
yurts87216532yurts
yutz167519882yutz
zits136030292zits

Search took 2 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 Filter178691298720.0802233637.5
2DLD Change Limit298723430.87334217.6
3Display Results3433430.0804287.5
 (SQL Overall)1786913431.033172982.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.