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

171 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
neons5581868(None) 
aeons57624651aeons
eons46638711_eons
neon47026421neon_
noons54125281noons
peons75327181peons
aeon45634612aeon_
agons66423782agons
anions64123032anions
anyons94513502anyons
axons125517932axons
azons146518252azons
beans75734692beans
belons84119412belons
bens65945702be_ns
betons84919552betons
boons75031912boons
cions75222852cions
clons75228132clons
cons66057692_cons
coons76737282coons
deans66131392deans
demons94917722demons
dens55945072de_ns
devons104512252devons
dons56048702_dons
ebons74316092ebons
enols54718402enols
enows85115492enows
ens37245922_e_ns
eon36052082_eon_
erns45428232_erns
exons125813342exons
felons93615762felons
fens76139762fe_ns
feods99516852feods
ferns85220082ferns
fons76943892_fons
frons86124042frons
gens55740072ge_ns
goons65326772goons
hens75642572he_ns
herns84825582herns
herons94820542herons
hons77350782_hons
icons76516492icons
ikons96311012ikons
inions64417002inions
ions46737852_ions
irons55324132irons
jeans126022112jeans
jeon116821442jeon_
jetons134512612jetons
kaons95014852kaons
keens95721182keens
kenos95220622kenos
kens85435232ke_ns
kerns94719562kerns
leans55536252leans
lemons84415052lemons
lenos56024862lenos
lens46146492le_ns
leone55018822leone
leones64417722leones
lions55923212lions
loons55731722loons
means75831232means
melons84117712melons
meous76120062meous
meows104612682meows
mesons83215842mesons
mons68152262_mons
moons75331002moons
muons75816172muons
naans55815252naans
nans46139402n_ans
naos47429732nao_s
neaps75618322neaps
nears55529422nears
neats55931902neats
nebs66124982ne_bs
necks115119332necks
needs65719632needs
neems77316292neems
neeps75617882neeps
negs55727362ne_gs
negus64513562negus
neifs85613042neifs
nektons1136392nektons
nelsons738002nelsons
nemas75321572nemas
nene45932062ne_ne
nenes55329672nenes
neocons936912neocons
neoned7311482neoned
nerds65719252nerds
nerols6914882nerols
nerts55924982nerts
ness45526562ne_ss
nests55728002nests
netops839212netops
nets45941532ne_ts
netts55320722netts
neuks96510862neuks
neums75414252neums
neurons7410442neurons
neves87021872neves
nevus84611392nevus
news76127372ne_ws
newtons1036812newtons
newts86015282newts
nexus124710662nexus
ninons64913772ninons
nitons64614902nitons
nobs66436902n_obs
nods55838222n_ods
noels56418702noels
noes45845392n_oes
nogs56534612n_ogs
noms65636402n_oms
nona46929062n_ona
nonas55126652n_onas
none45743172n_one
nones55639132n_ones
nooks95420392nooks
noon47134622noon_
nos38859322n_o_s
nouns56717312nouns
nous46136982n_ous
nows75738232n_ows
nuns45228232n_uns
nylons9267972nylons
odeons739022odeons
onions64016432onions
ons36148512__ons
paeons83915522paeons
peans75437642peans
peens76428192peens
peins76128062peins
pens65649642pe_ns
peon65635242peon_
peones83821042peones
peony105717562peony
phons105221142phons
pions75826392pions
pleons84213342pleons
pons65850602_pons
poons75430972poons
recons84922992recons
redons75222182redons
reins56234562reins
setons64620172setons
sons46049552_sons
teens56227482teens
tenons62916602tenons
tens45647412te_ns
terns55226872terns
tons46553052_tons
toons55027532toons
udons65411462udons
unions64216752unions
veins84620492veins
weans85326742weans
weens85224052weens
wens76337932we_ns
wons74942042_wons
xenons132710482xenons
yeans86624882yeans
yens75832262ye_ns
zeins144715392zeins
zoons144919692zoons

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 Filter178691538000.313570897.8
2DLD Change Limit538001711.62633087.3
3Display Results1711710.0463717.4
 (SQL Overall)1786911711.98590020.7
 
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.