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 “muon” 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
muon6572273(None) 
mon57561571m_on
moon67140811moon
mun56143851mu_n
muons75816171muons
muton73817001muton
aeon45634612aeon
agon56531882agon
anon46134852anon
axon115524302axon
azon135725052azon
boon67142172boon
bun56348142bu_n
bunn65023652bunn
buoy95921782buoy
burn65636422burn
chon96627792chon
cion613330912cion
clon66232482clon
con510268022_con
coon67248942coon
curn66731882curn
don46757652_don
dun46545582du_n
duo48536142duo_
duos56728132duos
durn56127622durn
ebon66821102ebon
eon36052082_eon
exon117116802exon
fon66352272_fon
fun66841142fu_n
futon83113772futon
gluon6311222gluon
goon57236172goon
guan55325582guan
gun47240802gu_n
hon67759382_hon
hun65844712hu_n
icon66922042icon
ikon85814952ikon
ion36051022_ion
iron46728462iron
jeon116821442jeon
jun105932062ju_n
jupon14479192jupon
kaon87521022kaon
lion46334442lion
loon47344792loon
macon94519952macon
main65345512main
man57465852m_an
mano66536792mano
mason74820182mason
maun65727202maun
mawn94424132mawn
mean65538082mean
melon73922082melon
men59252842m_en
meno66031352meno
meou65325862meou
meow95117882meow
meson74118312meson
mho86624622mho_
mhos95517772mhos
mien65028362mien
mo49158482m_o_
moa57249182m_oa
moan65832012moan
mob78651922m_ob
moc77845082m_oc
mod69054402m_od
mog66949672m_og
mol56654592m_ol
mom78853162m_om
monk105928512m_onk
mono66036712m_ono
mons68152252m_ons
mony96830002m_ony
moo58460512m_oo
mood76332062mood
mool67533862mool
moons75331002moons
moony104818272moony
moor66628552moor
moos66051302moos
moot67653622moot
mop76950822m_op
mor56855002m_or
morn66237562morn
moron76925422moron
mos57067122m_os
mot57279422m_ot
moue65835572moue
mound83918312mound
mount74128062mount
mourn77215012mourn
mouton8410852mouton
mow86650352m_ow
mown95424442mown
mu46737482mu__
much115224032much
mucin93116822mucin
muck125727852muck
mucor94011942mucor
mud67336862mu_d
muds75530652muds
muff124723862muff
mug65837692mu_g
mugg86316012mugg
mugs76232042mugs
mule65236972mule
mull65128802mull
mum76643612mu_m
mumm75718862mumm
mump105425722mump
mums85732772mums
mumu86022062mumu
muni65824402muni
muns65535912muns
muonic10410182muonic
mura65633292mura
mure65941332mure
murk105527252murk
murr65225132murr
mus55946752mu_s
muse67136032muse
mush94929122mush
musk104526192musk
muss64933762muss
must65145442must
mut58357182mu_t
mute65136872mute
mutons84314362mutons
muts64839982muts
mutt65739402mutt
mutton8510452mutton
neon47026422neon
noon47134622noon
noun45724182noun
nun35537742nu_n
on28057182__on
peon65635242peon
phon95925382phon
pion67235292pion
poon67341262poon
pun58846512pu_n
puton73617912puton
quin135823922quin
quod145413622quod
quoin144012322quoin
ruin47430512ruin
run36244982ru_n
son37761952_son
soon46240502soon
sun37149032su_n
sunn45423592sunn
tauon54816582tauon
ton310265102_ton
toon47740632toon
tun35845192tu_n
turn46330382turn
udon56017742udon
un28341132_u_n
upon65817582upon
urn35731462_urn
won66252062_won
yon67348952_yon
yuan76120012yuan
yupon10469482yupon
zoon137326982zoon

Search took 1 second 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.0762351197.4
2DLD Change Limit298721710.86034734.9
3Display Results1711710.0305700.0
 (SQL Overall)1786911710.966184980.3
 
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.