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

331 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
nuns4522823(None) 
buns66243721buns
duns55140431duns
funs75235731funs
guns55533481guns
huns76136931huns
muns65535921muns
nans46139401nans
nouns56717311nouns
nubs65927141nubs
nun35537741nun_
nus37939391nu_s
nuts45032671nuts
puns66641481puns
runs46438081runs
suns45841901suns
tuns45138661tuns
uns35936761_uns
ains46158882ains
anus47131112anu_s
auks85525262auks
aunt46553652aunt
aunts55227632aunts
awns75324432awns
bans66555142bans
bens65945702bens
bins66548252bins
bubs86235502bubs
buds75235172buds
bugs76035912bugs
bums85934592bums
bun56348142bun_
buna64730722buna
bunas75126572bunas
bund75530662bund
bunds85523542bunds
bung75730632bung
bungs85323862bungs
bunk105731352bunk
bunks115125082bunks
bunn65023652bunn
bunns74718292bunns
bunt65850852bunt
bunts75729802bunts
burns74926782burns
burs65847422burs
bus56950972bu_s
buss65134912buss
buts67247692buts
buys95726792buys
cans65050852cans
cons66057692cons
cubs85832382cubs
cuds76730472cuds
cues65438982cues
cunt66243672cunt
cunts76125122cunts
cups85430822cups
curns74924282curns
curs65645542curs
cuss65430612cuss
cuts65841152cuts
dans56748152dans
dens55945072dens
dins56652042dins
dons56048702dons
dubs78432192dubs
duds65530142duds
dues56045502dues
dugs614832282dugs
dun46545582dun_
dune56137582dune
dunes65332172dunes
dung66328432dung
dungs75821972dungs
dunk96228572dunk
dunks105621192dunks
dunt55746872dunt
dunts65828412dunts
duos56728132duos
dups75929512dups
durns64819872durns
ens37245922_ens
eons46638712eons
erns45428232erns
fans76247372fans
fauns84516752fauns
fens76139762fens
fins75849092fins
fons76943892fons
fubs96328792fubs
fuds86528562fuds
fugs85730692fugs
fun66841142fun_
fund85624982fund
funds94119252funds
funk115825622funk
funks125318912funks
furs76735042furs
fuss76027932fuss
gens55740072gens
gins55543952gins
gnus56518002gnu_s
guans64419442guans
guls55930852guls
gums75030942gums
gun47240802gun_
gunk95423572gunk
gunks104517722gunks
guts56637252guts
guvs85816812guvs
guys85019642guys
hens75642572hens
hins76447992hins
hons77350782hons
hubs96027142hubs
hues75235232hues
hugs86129752hugs
hums96831422hums
hun65844712hun_
hung86126352hung
hunh106323732hunh
hunk116029542hunk
hunks125321452hunks
hunt76445492hunt
hunts86826172hunts
huts76737442huts
inns46920932inns
inruns6359512inruns
ins35945602_ins
inurns63310982inurns
ions46737852ions
jins115635012jins
jugs125525602jugs
jun105932062jun_
junk155121032junk
junks164815972junks
jus106930222ju_s
juts115930162juts
kens85435232kens
kins85747912kins
knurs94511152knurs
kues86426772kues
kuna85120702kuna
kune85424572kune
lens46146492lens
lins47059052lins
lues45943552lues
lugs55233522lugs
lums65734242lums
luna46229852luna
lunas55025012lunas
lune47140492lune
lunes55337772lunes
lung55732492lung
lungs65223882lungs
lunk86030722lunk
lunks94822452lunks
lunt46148842lunt
lunts55826902lunts
luny77324132luny
luvs75818502luvs
mans66354552mans
mons68152262mons
muds75530652muds
mugs76232042mugs
mums85732772mums
mun56143862mun_
muni65824412muni
munis75022002munis
muons75816172muons
mus55946752mu_s
muss64933762muss
muts64839982muts
naans55815252naans
nabs66236192nabs
nags55436022nags
nan37854882nan_
nana46632902nana
nanas55928632nanas
naos47429732naos
naps66238582naps
nays75931592nays
nebs66124982nebs
negs55727362negs
nene45932062nene
nenes55329672nenes
neons55818682neons
ness45526562ness
nets45941532nets
neuks96510862neuks
neums75414252neums
news76127372news
nibs65028312nibs
nils46132452nils
nims66226882nims
nine45842172nine
nines55937342nines
nips65830922nips
nits45741642nits
nobs66436902nobs
nods55838222nods
noes45845392noes
nogs56534612nogs
noms65636402noms
nona46929062nona
nonas55126652nonas
none45743172none
nones55639132nones
noons54125282noons
nos38859322n_os
noun45724182noun_
nous46136982nous
nows75738232nows
nu26331952nu__
nub56439142nu_b
nude56626272nude
nudes64723292nudes
nuke85920752nuke
nukes95418122nukes
null45125312null
nulls55019982nulls
numb85520612numb
numbs94913092numbs
nurd56224342nurd
nurds65518522nurds
nurl45327242nurl
nurls55519682nurls
nurse54420122nurse
nut36651962nu_t
nutsy85711502nutsy
ons36148512_ons
onus45826812onu_s
ouds56430102ouds
ours47237562ours
outs45746962outs
owns76819582owns
pans65855732pans
pens65649642pens
pins65558452pins
pons65850602pons
pubs85029212pubs
puds75630512puds
pugs76332772pugs
puls65437562puls
pun58846512pun_
puna65331652puna
punas74826752punas
pung75429632pung
pungs85422222pungs
punk105729972punk
punks114822682punks
punt65747202punt
punts75828002punts
puny95526992puny
pups86032232pups
purs65641042purs
pus55547842pu_s
puss64830132puss
puts65641752puts
quins144819852quins
rins46153192rins
rubs66133492rubs
rues46044482rues
rugs56033682rugs
ruins55822032ruins
rums64833472rums
run36244992run_
rune45236302rune
runes55530222runes
rung56429982rung
rungs611819402rungs
runt46647992runt
runts55927632runts
ruts44541492ruts
sans45153362sans
shuns85018142shuns
sins46755272sins
snubs75412552snubs
snugs64913022snugs
sons46049552sons
stuns54719492stuns
subs66037122subs
suds56135292suds
sues46247652sues
suks85927122suks
sums65837582sums
sun37149032sun_
sung55832172sung
sunk85031812sunk
sunn45423592sunn
sunns55017352sunns
sups64834432sups
suqs134319652suqs
suss45229302suss
tans46154832tans
tens45647412tens
tins45251302tins
tons46553052tons
tubs65430062tubs
tugs56231672tugs
tuis44829642tuis
tun35845192tun_
tuna45127842tuna
tunas54224122tunas
tune45635862tune
tunes55332192tunes
tung55328172tung
tungs65520632tungs
tups65628762tups
turns55623242turns
tuts45838452tuts
un28341142_un_
ups55629052_ups
urns46323902urns
us26937432_u_s
uts35534372_uts
vans76236732vans
vugs87022872vugs
wans76452272wans
wens76337932wens
wins75949172wins
wons74942042wons
wuss75219332wuss
wyns105717032wyns
yens75832262yens
yins75335122yins
yuans84613322yuans
yuks116418022yuks
yups96121602yups
zins135735002zins

Search took 3 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.626285448.9
2DLD Change Limit298723311.75017069.7
3Display Results3313310.2031630.5
 (SQL Overall)1786913312.57969286.9
 
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.