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

188 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
neon4702642(None) 
aeon45634611aeon
eon36052081_eon
jeon116821441jeon
neons55818681neons
noon47134621noon
peon65635241peon
aeons57624652aeons
agon56531882agon
ancon75718232ancon
anion55028812anion
anon46134852anon
anyon85615222anyon
axon115524302axon
azon135725052azon
bean66443862bean
been65335782been
belon73924112belon
ben56554922be_n
beton76022062beton
boon67142172boon
chon96627792chon
cion613330912cion
clon66232482clon
con510268022_con
coon67248942coon
dean56039482dean
demon86520312demon
den47554342de_n
devon95113682devon
don46757652_don
ebon66821102ebon
en28052392_e_n
enol45823822enol
enow77819872enow
eons46638712_eons
ern35738362_ern
exon117116802exon
felon84619292felon
fen66851352fe_n
feod815523002feod
fern76129322fern
fon66352272_fon
gen45950512ge_n
goon57236172goon
hen67555272he_n
hern76134892hern
heron85025502heron
hewn106719852hewn
hon67759382_hon
icon66922042icon
ikon85814952ikon
inion54620182inion
ion36051022_ion
iron46728462iron
jean116629282jean
jeton124815402jeton
kaon87521022kaon
keen84830412keen
ken76343982ke_n
keno87926432keno
kern85326212kern
lean46345242lean
lemon75618182lemon
leno47331392leno
leone55018822leone
lion46334442lion
loon47344792loon
mean65538092mean
melon73922082melon
men59252852me_n
meno66031362meno
meou65325862meou
meow95117882meow
meson74118312meson
mon57561582_mon
moon67140812moon
muon65722732muon
naan47621932naan
nan37854882n_an
naoi46024632naoi
naos47429732naos
ne27045102ne__
neap66927012neap
near45236502near
neat46356782neat
neb57238622ne_b
nebs66124982nebs
neck105423662neck
nee36657782ne_e
need54934152need
neem67328082neem
neep65728312neep
neg47237342ne_g
negs55727362negs
neif75429492neif
nekton1036582nekton
nelson638422nelson
nema65522522nema
nene45932062nene
neocon836712neocon
neoned7311482neoned
nerd56624942nerd
nerol51017812nerol
ness45526562ness
nest45548732nest
net36670292ne_t
netop7312342netop
nets45941532nets
nett46643232nett
neuk87416602neuk
neum66723082neum
neuron6310372neuron
neve76224832neve
nevi75116422nevi
new66237092ne_w
news76127372news
newt76933742newt
newton936982newton
next116631082next
ninon55517382ninon
niton55418282niton
no29353242n_o_
nob58954422n_ob
nod47549562n_od
noel45226552noel
noes45845392noes
nog46847312n_og
noh66640642n_oh
nom510450642n_om
nona46929062n_ona
none45743172n_one
noo37154042n_oo
nook85728492nook
noons54125282noons
nor38048822n_or
nos38859322n_os
not39474662n_ot
noun45724182noun
now65950192n_ow
nun35537742n_un
nylon82910512nylon
odeon6411482odeon
on28057182__on
onion54320972onion
paeon74819492paeon
pean66147172pean
peen65938082peen
pein65834942pein
pelon74423212pelon
pen56558842pe_n
peons75327182peons
peony105717562peony
phon95925382phon
pion67235292pion
pleon74216382pleon
poon67341262poon
recon75624242recon
redon65424882redon
rein46040892rein
rewon86920582rewon
seen46943122seen
sen36058522se_n
seton55223542seton
sewn76124332sewn
son37761952_son
soon46240502soon
teen45938202teen
ten35856112te_n
tenon53320512tenon
tern46134802tern
ton310265102_ton
toon47740632toon
udon56017742udon
union54519792union
unwon84512342unwon
upon65817582upon
vein75625752vein
wean75734352wean
ween75835462ween
wen66249602we_n
won66252062_won
xenon122612452xenon
yean75834582yean
yen66847382ye_n
yon67348952_yon
zein135620602zein
zoon137326982zoon

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.283631417.0
2DLD Change Limit298721880.75039829.3
3Display Results1881880.0464087.0
 (SQL Overall)1786911881.079165608.0
 
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.