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 “macron” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

472 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
macron10361567(None) 
dacron94310691dacron
macon94519951mac_on
macro94718171macro_
macrons113514891macrons
macros104017011macros
marron83717541marron
matron83918311matron
micron103714281micron
acorn75616622_acorn
apron7318832_apron
bacon95620592bac_on
baron78131242ba_ron
bicron103710772bicron
dacrons103211032dacrons
garcon92912482garcon
garron73113492garron
hadron102913752hadron
ladron73413322ladron
macaroni1246522macaroni
macaroon1246342macaroon
macho126120152macho_
machos135217492machos
macons104017242mac_ons
madrona10288702madrona
madrone102812662madrone
madrono10288742madrono
mammon939642mammon
maroon83118202maroon
marrons93216972marrons
marrow112812602marrow
mascon103612742mascon
mason74820182ma_son
matrons93517632matrons
micro94715992micro_
microns113814782microns
micros104115362micros
mikron12318502mikron
moron76925422m_oron
mucro94513722mucro_
natron64116022natron
omicron1165062omicron
patron84018042patron
racon75422142rac_on
racoon83814472racoon
aboon74918703_aboon
achoo10315083_achoo
acorns85013013_acorns
acre67330773_acr_e
acred87126353_acred
acres76327763_acres
acrid86920103_acrid
acrogen1038203_acrogen
acronic112814693_acronic
acronym1445673_acronym
across8312643_across
actin74922553_actin
action84719683_action
actor71116073_actor
adorn64917093_adorn
aeon45634613_a_eon
aero45435343_aero_
agon56531883_a_gon
airn46433833_air_n
amarone9311203amarone
amazon1736833amazon
amnion84812053amnion
ancon75718233_ancon
anion55028813_anion
anon46134853_a_non
anyon85615223_anyon
aprons8316993_aprons
archon11311753archon
arco68331543_arco_
argon65520593_argon
arrow83414883_arrow
arson55118833_arson
avion84218343_avion
axion1211316913_axion
axon115524303_a_xon
azlon144312873_azlon
azon135725053_a_zon
baboon103613913baboon
bacons104917583bac_ons
bairn77515533bair_n
ballon84117493ballon
barn66444643ba_r_n
barong96015823ba_rong
barons85025383ba_rons
barony115915303ba_rony
barren85317613barren
barrow114512763barrow
baryon111211613baryon
basion84315853basion
baton75822423ba_ton
beacon10511373beac_on
beckon14309383beckon
bicorn103610103bicorn
bicrons113410473bicrons
boron76727143_boron
cacao95420003cacao_
cacaos104616183cacaos
cachou13310623cachou
cairn75717513cair_n
cajon144513903ca_jon
caldron1038153caldron
camion103917193camion
cannon84514443cannon
canon74725303ca_non
canton85722993canton
canyon114512033canyon
capon95221873ca_pon
carbon104919043carbon
cardon94120853cardon
carn66245433ca_r_n
carob95325223ca_rob
carol75128613ca_rol
carom95025563ca_rom
carrion9312673carrion
carrom10513403carrom
carrot8423123carrot
carryon1237033carryon
carton84522663carton
cation83925503cation
chon96627793__chon
cion613330913__cion
citron83112983citron
clon66232483__clon
cocoon10312263cocoon
con510268023__c_on
coon67248943__coon
corn69945813__corn
croc85723733__croc
crone75231333__crone
crony105918673__crony
croon75522783__croon
crop87628633__crop
crow96428133__crow
crown105620083__crown
daemon9279593daemon
dahoon1039053dahoon
daikon11217243daikon
daimon9259713daimon
dalton7311273dalton
damson938063damson
darn56434623da_r_n
deacon9510423deac_on
decrown13206053decrown
diatron839283diatron
diuron738573diuron
earn46737553ea_r_n
escrow1135913escrow
faction122613333faction
factor11911453factor
falcon11310293falcon
fanion94514323fanion
fanon84619013fa_non
faro76136923fa_ro_
faros85532023fa_ros
farrow12309973farrow
flacon1138633flac_on
gabion93211033gabion
gaboon93211773gaboon
gadroon938173gadroon
gallon73715813gallon
gammon1138903gammon
garcons102411643garcons
garrons82713463garrons
gascon9339723gascon
giron66118993_giron
gyron95314623_gyron
hadrons113314303hadrons
hagdon1188283hagdon
halcyon1543923halcyon
halon86124863ha_lon
harrow122610773harrow
heron85025503_heron
icon66922043_ic_on
intron64215023intron
iron46728463__iron
jargon1448823jargon
kaon87521023ka__on
karn86129413ka_r_n
karoo92519583ka_roo
karroo10410013karroo
kation104315683kation
lactone9311393lactone
ladrone83611873ladrone
ladrons83813193ladrons
lagoon7410483lagoon
lardon74415063lardon
limacon1144143limac_on
maar66025063maar__
maars74621633maar_s
mac78053933mac___
macaco1247853macaco
macacos1338083macacos
macaronic1545243macaronic
macaronis1346563macaronis
macaroons1345563macaroons
macaw12311763mac_aw
macaws1337023macaws
mace87345793mac__e
maced108528693mac_ed
macer912126943mac_er
macers105321273macers
maces97139963mac_es
mach116134483mac__h
mache125925303mac_he
maches134827233maches
machine14313493machine
machree1438513machree
machs125722563mac_hs
machzor2344263machzor
macing114221553macing
mack125733653mac__k
mackle143716433mackle
macks135127603mac_ks
macle96127003mac_le
macled116718113macled
macles107023223macles
macrame1338713macrame
macrodont1446003macrodont
macruran1244013macruran
macs86742513mac__s
macula103013673macula
macule104115273macule
madden103912523madden
madman113712383madman
madmen113511743madmen
madras94316433madras
madre85720173madr_e
madres93718183madres
madronas11288493madronas
madrones112912283madrones
madronos11337543madronos
madtom1138023madtom
maduro936983maduro_
maduros1036303maduros
madzoon1996063madzoon
maggot10311713maggot
magian9312833magian
magot8326393ma_got
mahjong2042273mahjong
mahoe10315573ma_hoe
mahzor2035113mahzor
maiden93512283maiden
main65345523ma__in
mair66133783mair__
mairs76228303mair_s
major145212923ma_jor
majors154511093majors
mako105622363ma_ko_
makos116518363ma_kos
malign939853malign
malison939693malison
malkin122913153malkin
mallow114014743mallow
maltol8310843maltol
mambo115215743mambo_
mambos125414493mambos
mammons1048513mammons
man57465873ma___n
mango85724323mango_
mangos94319333mangos
manioc103914823manioc
mannan85413623mannan
mano66536813ma_no_
manor78023933ma_nor
manors84420883manors
manos74933623ma_nos
manrope1138033manrope
mansion9611543mansion
mar57965953ma_r__
mara67444573ma_r_a
maras75443293ma_ras
marc87034633ma_r_c
marcel103714853marcel
march125622893ma_rch
marchen143312073marchen
marcs95726623ma_rcs
mare64759333ma_r_e
mares76457633ma_res
marge85328333ma_rge
margin94016843margin
maria75032883ma_ria
marina84623413ma_rina
marine84230403ma_rine
mark105138063ma_r_k
marka114620793ma_rka
marks115933483ma_rks
marl66341623ma_r_l
marlin84220903marlin
marls75535163ma_rls
marly106925613ma_rly
marmot10318743marmot
maroons92615553maroons
marram10313883marram
marrano939423marrano
marred95421043marred
marrer83716673marrer
marring103319553marring
marrows122911823marrows
marrowy15236083marrowy
marry104821693ma_rry
mars66261873ma_r_s
marse76231153ma_rse
marsh105320853ma_rsh
mart66865983ma_r_t
marten84518263marten
martin84122523martin
marts77442233ma_rts
marvy135014033ma_rvy
mascons113411583mascons
mascot104016073mascot
masons83916513ma_sons
matin75132853ma_tin
matres84522233matres
matrix1539843matrix
matronal1048113matronal
matronly1344783matronly
mattin84416633mattin
matzo16312893matzo_
matzoh2035483matzoh
matzoon1896473matzoon
matzos1749263matzos
matzot17710983matzot
maun65727213ma__un
maven104816893ma_ven
mavin105722953ma_vin
mawn94424143ma__wn
mayan105616903ma_yan
mayo96524303ma_yo_
mayor106616623ma_yor
mayors115714193mayors
mayos105521933ma_yos
maypop1565143maypop
mayvin1436523mayvin
megaron10248303megaron
melon73922083m_elon
melton8311553melton
merlon83012353merlon
meson74118313m_eson
metro74718803metro_
metros84217803metros
micra96214973micr_a
microbe1338663microbe
microhm1646123microhm
midiron1046003midiron
mignon937953mignon
mikrons13428413mikrons
minion83416243minion
mirin75023153m_irin
mirror848003mirror
mon57561583m___on
monuron937463monuron
moon67140813m__oon
morion86217733morion
morn66237563m_or_n
morons84919543m_orons
morrion959003morrion
morro73216953morro_
morros83714673morros
morrow113510093morrow
motion85217553motion
mourn77215013mour_n
mouton8410853mouton
mucho125013443mucho_
mucin93116823muc_in
mucor94011943muc_or
mucors104410853mucors
mucrones1237603mucrones
muon65722733m__uon
muton73817003m_uton
mutton8510453mutton
nacho105414383nacho_
nachos115014183nachos
nacre75715363nacr_e
nacred95212493nacred
nacres85614453nacres
narco76718243narco_
narcos86714203narcos
narrow9269143narrow
nasion63914083nasion
nation64322803nation
natrons73215663natrons
neuron6310373neuron
omicrons1275193omicrons
omikron1353173omikron
operon8811773operon
paction112713963paction
padrone102512073padrone
padroni10278613padroni
paeon74819493pa_eon
pardon94618733pardon
parol74826273pa_rol
parrot8320663parrot
parson83817903parson
parton84720993parton
patrol83213023patrol
patrons93818103patrons
patroon92811973patroon
perron83216623perron
raccoon1176163raccoon
racons84319343rac_ons
racoons93912433racoons
radon64620503ra_don
ramrod936833ramrod
ramson8310463ramson
ration64226013ration
ratoon64417373ratoon
ratton64116123ratton
rayon83815703ra_yon
reckon123010543reckon
recon75624243rec_on
recrown12257573recrown
sacaton938993sacaton
sacra74516993sacr_a
sacral83414413sacral
sacred94917103sacred
sacring103115983sacring
sacrum103910143sacrum
sadiron836043sadiron
saffron1344173saffron
safrol937283safrol
salmon84614183salmon
salon55228553sa_lon
saloon64418023saloon
saran53730303sa_ran
sarin55239253sa_rin
sarod65325873sa_rod
sarong73914873sa_rong
saros55238063sa_ros
scion72214993_scion
scorn75817453_scorn
scrod85115073_scrod
tachyon1544623tachyon
taco67031353tac_o_
tacos77023553tac_os
tacrine9311293tacrine
taction93213023taction
talion6317713talion
talon55824113ta_lon
tampon102911233tampon
tarn46842723ta_r_n
taro46846913ta_ro_
taroc75721643ta_roc
tarok97921073ta_rok
taros55640823ta_ros
tarot55943933ta_rot
tarpon82812803tarpon
tauon54816583ta_uon
taxon124414663ta_xon
thoron94713903thoron
tycoon1136023tycoon
uncrown1236323uncrown
vagrom1235943vagrom
wacko145514383wacko_
wackos155210993wackos
waggon1136393waggon
wagon94312953wa_gon
waitron1036333waitron
wanion93213063wanion
wanton94413813wanton
warn75239323wa_r_n
warren95012853warren
yapon104613583ya_pon
yarn75230043ya_r_n
yarrow12287933yarrow
yaupon11345493yaupon
zacaton1845633zacaton
zircon1754953zircon

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127164725.19021717.9
3Display Results4724720.1533085.0
 (SQL Overall)1786914725.73331168.8
 
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.