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

444 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
macrons11351489(None) 
dacrons103211031dacrons
macons104017241mac_ons
macron103615671macron_
macros104017011macro_s
marrons93216971marrons
matrons93517631matrons
microns113814781microns
acorns85013012_acorns
across8312642_across
aprons8316992_aprons
bacons104917582bac_ons
barons85025382ba_rons
bicrons113410472bicrons
dacron94310692dacron_
garcons102411642garcons
garrons82713462garrons
hadrons113314302hadrons
ladrons83813192ladrons
macaroni1246522macaroni
macaronis1346562macaronis
macaroons1345562macaroons
machos135217492macho_s
macon94519952mac_on_
macro94718172macro__
madrona10288702madrona
madronas11288492madronas
madrone102812662madrone
madrones112912282madrones
madrono10288742madrono
madronos11337542madronos
mammons1048512mammons
maroons92615552maroons
marron83717542marron_
marrows122911822marrows
mascons113411582mascons
masons83916512ma_sons
matron83918312matron_
micron103714282micron_
micros104115362micro_s
mikrons13428412mikrons
morons84919542m_orons
mucrones1237602mucrones
natrons73215662natrons
omicrons1275192omicrons
patrons93818102patrons
racons84319342rac_ons
racoons93912432racoons
acerous9513333_acerous
acorn75616623_acorn_
acres76327763_acr_es
acrogens1147243_acrogens
acronic112814693_acronic
acronym1445673_acronym
acronyms1544993_acronyms
actins86321103_actins
actions94218513_actions
actors81016763_actors
adorns74212613_adorns
aeons57624653_a_eons
agons66423783_a_gons
airns55521033_air_ns
amarone9311203amarone
amarones10311353amarones
amazons1836653amazons
amnions93710913amnions
amorous9311133amorous
anions64123033_anions
anyons94513503_anyons
apron7318833_apron_
archons12311583archons
argons75018203_argons
arrows92813483_arrows
arsons63917213_arsons
aurous64119263_aurous
avions94114393_avions
axions134713483_axions
axons125517933_a_xons
azlons154110423_azlons
azons146518253_a_zons
baboons113211083baboons
bacon95620593bac_on_
bairns86710873bair_ns
ballons93916963ballons
barns76335143ba_r_ns
baron78131243ba_ron_
barong96015823ba_rong
barongs105310833ba_rongs
barony115915303ba_rony
barrens94414323barrens
barrows123411683barrows
baryons121010473baryons
basions94213953basions
batons85519423ba_tons
baudrons1135763baudrons
beacons11410733beac_ons
beckons15279143beckons
bicorns11338763bicorns
bicron103710773bicron_
borons85520543_borons
cacaos104616183cacao_s
cachous14312583cachous
cairns85313303cair_ns
caldrons1138063caldrons
camions113916133camions
cannons94412883cannons
canons85522063ca_nons
cantons95221203cantons
canyons124511593canyons
capons104119503ca_pons
carbons115418943carbons
cardons104519933cardons
carns75937563ca_r_ns
carobs104818103ca_robs
carols85124983ca_rols
caroms105619573ca_roms
carrions10312453carrions
carroms11512403carroms
carrots9714623carrots
carryons1337103carryons
cartons94122473cartons
cations94524143cations
cions75222853__cions
citrons92913223citrons
clons75228133__clons
cocoons11310563cocoons
cons66057693__c_ons
coons76737283__coons
corns76034763__corns
crocs95722433__crocs
crone75231333__crone
crones84729243__crones
crony105918673__crony
croons85418423__croons
crops96125233__crops
cross75124503__cross
crowns115615113__crowns
crows105727313__crows
daemons10269233daemons
dahoons1137753dahoons
daikons12186693daikons
daimons10249323daimons
daltons8310403daltons
damsons1038013damsons
darns66927893da_r_ns
deacons10310393deac_ons
decrowns14265063decrowns
diatrons939613diatrons
diurons838823diurons
earns55927563ea_r_ns
escrows1235803escrows
factions133013063factions
factors12912123factors
falcons1239123falcons
fanions103713073fanions
fanons96115213fa_nons
faros85532023fa_ro_s
farrows13259783farrows
flacons1238053flac_ons
frons86124043__frons
gabions102410053gabions
gaboons10289903gaboons
gadroons1037013gadroons
gallons83015953gallons
gammons1237973gammons
garcon92912483garcon_
garron73113493garron_
gascons10289103gascons
girons75014373_girons
gyrons105511223_gyrons
hadron102913753hadron_
hagdons1258523hagdons
halcyons1644023halcyons
halons95720713ha_lons
harrows132611033harrows
herons94820543_herons
icons76516493_ic_ons
incross937663incross
introns73515023introns
irons55324133__irons
jargons1558203jargons
kaons95014853ka__ons
karns96624143ka_r_ns
karoos102415803ka_roos
kaross101910013ka_ross
karroos1139313karroos
kations114013663kations
lacrosse1044113lacrosse
lactone9311393lactone
lactones10311223lactones
ladron73413323ladron_
ladrone83611873ladrone
ladrones92710973ladrones
lagoons839253lagoons
lardons83914493lardons
limacons1243953limac_ons
maars74621633maar__s
macacos1338083macacos
macaronic1545243macaronic
macaronics1643683macaronics
macaronies1446173macaronies
macaroon1246343macaroon
macaws1337023mac_aws
macers105321273mac_ers
maces97139963mac__es
maches134827233mac_hes
machine14313493machine
machines15312893machines
macho126120153macho__
machoism1746393machoism
machrees1545503machrees
machs125722563mac__hs
machzors2444113machzors
macing114221553mac_ing
mackles154415753mackles
macks135127603mac__ks
macles107023223mac_les
macrame1338713macrame
macrames1438953macrames
macrocosm1743783macrocosm
macrocyst1844043macrocyst
macrodont1446003macrodont
macrurans1343533macrurans
macrurous1343883macrurous
macs86742513mac___s
maculas113114023maculas
macules114015133macules
maddens11359753maddens
madras94316433madr_as
madres93718183madr_es
madtoms1236923madtoms
maduros1036303maduro_s
madzoons20124773madzoons
maggots1136563maggots
magians10310753magians
magots9312363ma_gots
mahjong2042273mahjong
mahjongs2141813mahjongs
mahoes11313103ma_hoes
mahzors2135123mahzors
maidens10349663maidens
mains75635113ma__ins
mairs76228303mair__s
majors154511093ma_jors
makos116518363ma_ko_s
maligns1038133maligns
malisons1048783malisons
malkins133311803malkins
mallows123714323mallows
maltols939403maltols
mamboes135011823mamboes
mambos125414493mambo_s
mammon939643mammon_
mangoes104316133mangoes
mangos94319333mango_s
maniocs113611443maniocs
mannans93611523mannans
manors84420883ma_nors
manos74933623ma_no_s
manrope1138033manrope
manropes1237913manropes
mans66354553ma___ns
mansions1069793mansions
maras75443293ma_r_as
marcels113212373marcels
marches143921173marches
marcs95726623ma_r_cs
mares76457633ma_r_es
marges94525713ma_rges
margins103815193margins
marina84623413ma_rina
marinas93519383ma_rinas
marine84230403ma_rine
marines93928013ma_rines
markas124717003ma_rkas
marks115933483ma_r_ks
marlins93420473marlins
marls75535163ma_r_ls
marmots11311513marmots
maroon83118203ma_roon
marrams11310123marrams
marrano939423marrano
marranos1038423marranos
marrers93414313marrers
marries93825283marries
marring103319553marring
marrow112812603marro_w
marrowy15236083marrowy
mars66261873ma_r__s
marses84827113ma_rses
martens93714953martens
martins93322063martins
marts77442233ma_r_ts
mascon103612743mascon_
mascots113910343mascots
mason74820183ma_son_
matins84527783ma_tins
matrass939403matrass
matres84522233matr_es
matronal1048113matronal
matronly1344783matronly
mattins93316143mattins
matzohs2134373matzohs
matzoons19105083matzoons
matzos1749263matzo_s
mavens114312973ma_vens
mavins115119183ma_vins
mayors115714193ma_yors
mayos105521933ma_yo_s
maypops16104453maypops
mayvins1535323mayvins
melons84117713m_elons
meltons9410923meltons
merlons93311273merlons
mesons83215843m_esons
metros84217803metro_s
micro94715993micro__
microbe1338663microbe
microbes1439403microbes
microbus1456033microbus
microhm1646123microhm
microhms1765613microhms
midirons1145883midirons
mignons1037863mignons
mikron12318503mikron_
minions93314623minions
mirins83918903m_irins
mirrors938623mirrors
mons68152263m___ons
monurons1037093monurons
moons75331003m__oons
morions94014643morions
morns75527443m_or_ns
moron76925423m_oron_
morrions1077673morrions
morros83714673morro_s
morrows12318723morrows
motions94215003motions
mourns84111013mour_ns
moutons9410313moutons
mucins102712513muc_ins
mucors104410853muc_ors
mucous104411653muc_ous
mucro94513723mucro__
muons75816173m__uons
mutons84314363m_utons
muttons949283muttons
nachos115014183nacho_s
nacreous1045763nacreous
nacres85614453nacr_es
narcos86714203narco_s
narrows10258843narrows
nasions73112383nasions
nations74720563nations
natron64116023natron_
neurons7410443neurons
omicron1165063omicron_
omikrons1462963omikrons
operons91411743operons
pactions122613503pactions
padrone102512073padrone
padrones112711043padrones
padroni10278613padroni
paeons83915523pa_eons
pardons103817623pardons
parols84722613pa_rols
parous84024163pa_rous
parrots9312743parrots
parsons93516873parsons
partons94620513partons
patrols93513513patrols
patron84018043patron_
patroons102710603patroons
perrons93115483perrons
raccoons1265453raccoons
racon75422143rac_on_
racoon83814473racoon_
radons74118533ra_dons
ramrods1036583ramrods
ramsons939563ramsons
rations74123433rations
ratoons73815473ratoons
rattons73815323rattons
rayons94113343ra_yons
reckons13269653reckons
recons84922993rec_ons
recross989833recross
recrowns13246143recrowns
sacatons1038973sacatons
sacrals93311793sacrals
sacring103115983sacring
sacrings11278923sacrings
sacrums11388043sacrums
sadirons936023sadirons
saffrons1444303saffrons
safrols1036863safrols
salmons93713263salmons
salons63823693sa_lons
saloons74415323saloons
sarans64224433sa_rans
sarcous9312933sarcous
sarins63932623sa_rins
sarods74918573sa_rods
sarong73914873sa_rong
sarongs84511803sa_rongs
saros55238063sa_ro_s
scions82612243_scions
scorns85713023_scorns
scrods94111613_scrods
tachyons1644623tachyons
tacos77023553tac_o_s
tacrine9311293tacrine
tacrines10310563tacrines
tactions102912423tactions
talions7314113talions
talons64019443ta_lons
tampons112711563tampons
tarns56433953ta_r_ns
tarocs84615663ta_rocs
taroks106115283ta_roks
taros55640823ta_ro_s
tarots66422993ta_rots
tarpons92612213tarpons
tauons63412673ta_uons
taxons134211503ta_xons
thorons104511913thorons
tycoons1235173tycoons
uncross938193uncross
uncrowns1344363uncrowns
vacuous1237023vacuous
wackos155210993wacko_s
waggons1235503waggons
wagons103911213wa_gons
waitrons1136633waitrons
wanions104011373wanions
wantons103713013wantons
warns87231003wa_r_ns
warrens103810893warrens
yapons114411773ya_pons
yarns85621793ya_r_ns
yarrows13277853yarrows
yaupons12345683yaupons
zacatons1945703zacatons
zircons1854963zircons

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340274446.97019229.1
3Display Results4444440.1532902.0
 (SQL Overall)1786914447.52923733.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.