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

217 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
anon4613485(None) 
aeon45634611aeon
agon56531881agon
ancon75718231ancon
anion55028811anion
anoa45634471anoa
anyon85615221anyon
axon115524301axon
azon135725051azon
canon74725301canon
fanon84619011fanon
abo59045962abo_
aboon74918702aboon
abos67734412abos
acorn75616622acorn
adnoun757032adnoun
ado49146872ado_
adorn64917092adorn
ados57633512ados
adown95611662adown
aeons57624652aeons
agin56132712agin
ago48845522ago_
agog68019002agog
agone65924552agone
agons66423782agons
agony96415652agony
ahoy101919182ahoy
ain37579092a_in
airn46433832airn
akin86328032akin
alan46844082alan
aloe45540192aloe
aloin55227422aloin
alone55732962alone
along65419492along
alow75328592alow
amen66733152amen
amin66042252amin
amnion84812052amnion
amok10217402amok
among85813302among
an211879082a__n
ana39559832an_a
anal48037522anal
anas46649862anas
ancone83916952ancone
and47244172an_d
ands57833612ands
ane37866952an_e
anent54931842anent
anes45255932anes
anew76623132anew
anga56831352anga
ani37751182an_i
anil46437432anil
anions64123032anions
anis45746462anis
ankh111114412ankh
anna45529012anna
annona648872annona
annoy869712annoy
anoas57226492anoas
anode65021042anode
anoint6423632anoint
anole55330382anole
anomy105113392anomy
anonym1136382anonym
ansa45927772ansa
ant37270792an_t
anta46839582anta
ante46538902ante
anti45536362anti
ants47243472ants
anus47131112anus
any68440492an_y
anyone94612732anyone
anyons94513502anyons
apo511142122apo_
apod78123182apod
apos65433822apos
apron7318832apron
argon65520592argon
arson55118832arson
atom67824522atom
atone56527982atone
atony87218852atony
atop66124752atop
avion84218342avion
avo68936232avo_
avos77227012avos
avow107816462avow
awn68035912a_wn
awol75620672awol
axion1211316912axion
axone125918472axone
axons125517932axons
ayin76331742ayin
azan136521782azan
azlon144312872azlon
azo128233392azo_
azons146518252azons
bacon95620592bacon
baron78131242baron
baton75822422baton
boon67142172boon
cajon144513902cajon
cannon84514442cannon
canoe75627252canoe
canons85522062canons
canton85722992canton
canyon114512032canyon
capon95221872capon
chon96627792chon
cion613330912cion
clon66232482clon
con510268022_con
conn66229132conn
coon67248942coon
don46757652_don
ebon66821102ebon
enol45823822enol
enow77819872enow
eon36052082_eon
exon117116802exon
fanion94514322fanion
fano75831692fano_
fanons96115212fanons
fanos85926502fanos
fon66352272_fon
ganof95420362ganof
goon57236172goon
halon86124862halon
hon67759382_hon
icon66922042icon
ikon85814952ikon
inion54620182inion
inn36727432in_n
ion36051022_ion
iron46728462iron
jeon116821442jeon
kaon87521022kaon
knob107417012knob
knop107116592knop
knot85630502knot
know116115842know
known12568342known
lion46334442lion
loon47344792loon
macon94519952macon
mano66536812mano_
manor78023932manor
manos74933622manos
mason74820182mason
mon57561582_mon
moon67140812moon
muon65722732muon
naan47621932naan
nan37854882_nan
naoi46024632naoi
naos47429732naos
neon47026422neon
ninon55517382ninon
no29353242_no_
nob58954422_nob
nod47549562_nod
nog46847312_nog
noh66640642_noh
nom510450642_nom
nona46929062_nona
none45743172_none
noo37154042_noo
noon47134622noon
nor38048822_nor
nos38859322_nos
not39474662_not
noun45724182_noun
now65950192_now
nun35537742_nun
on28057182__on
onion54320972onion
ono36838032ono_
onos46229002onos
paeon74819492paeon
peon65635242peon
phon95925382phon
pinon76024532pinon
pion67235292pion
poon67341262poon
racon75422142racon
radon64620502radon
rayon83815702rayon
salon55228552salon
snob65825592snob
snog55623632snog
snot44745452snot
snow76324792snow
son37761952_son
soon46240502soon
talon55824112talon
tauon54816582tauon
taxon124414662taxon
tenon53320512tenon
ton310265102_ton
toon47740632toon
udon56017742udon
union54519792union
unwon84512342unwon
upon65817582upon
wagon94312952wagon
wanion93213062wanion
wanton94413812wanton
won66252062_won
xenon122612452xenon
yapon104613582yapon
yon67348952_yon
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.266671770.7
2DLD Change Limit298722170.79637527.6
3Display Results2172170.0633444.4
 (SQL Overall)1786912171.125158836.4
 
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.