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

430 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
hadron10291375(None) 
hadrons113314301hadrons
ladron73413321ladron
adorn64917092_adorn
apron7318832_apron
baron78131242ba_ron
caldron1038152caldron
cardon94120852cardon
chaldron1445772chaldron
dacron94310692dacron
gadroon938172gadroon
garron73113492garron
hadronic1447952hadronic
hagdon1188282hagdon
halon86124862ha_lon
harden105718532harden
harrow122610772harrow
heron85025502h_eron
hydro12259422hydro_
hydros13279362hydros
ladrone83611872ladrone
ladrons83813192ladrons
lardon74415062lardon
macron103615672macron
madrona10288702madrona
madrone102812662madrone
madrono10288742madrono
marron83717542marron
matron83918312matron
natron64116022natron
padrone102512072padrone
padroni10278612padroni
pardon94618732pardon
patron84018042patron
radon64620502rad_on
sadiron836042sadiron
aboon74918703_aboon
acorn75616623_acorn
adios65822863_adios
adjoin14107293_adjoin
adman84517903_adman
admen84516183_admen
adnoun757033_adnoun
ado49146873_ad_o_
adore65723673_adore
adorns74212613_adorns
ados57633513_ad_os
adown95611663_adown
adroit7518793_adroit
aeon45634613_a_eon
aero45435343_aero_
agon56531883_a_gon
airn46433833_air_n
aldrin7311243aldrin
ancon75718233_ancon
andiron848283andiron
andro6314163andro_
andros7313303andros
anion55028813_anion
anon46134853_a_non
anyon85615223_anyon
aprons8316993_aprons
ardor64617863_ardor
argon65520593_argon
arrow83414883_arrow
arson55118833_arson
avion84218343_avion
axion1211316913_axion
axon115524303_a_xon
azlon144312873_azlon
azon135725053_a_zon
baboon103613913baboon
bacon95620593ba_con
badman113813843badman
badmen114613833badmen
bairn77515533bair_n
ballon84117493ballon
barn66444643ba_r_n
barong96015823ba_rong
barons85025383ba_rons
barony115915303ba_rony
barren85317613barren
barrow114512763barrow
baryon111211613baryon
basion84315853basion
baton75822423ba_ton
baudrons1135763baudrons
bicron103710773bicron
boron76727143_boron
bradoon1037353bradoon
cadre85419023cadr_e
cadres94017933cadres
cairn75717513cair_n
cajon144513903ca_jon
caldrons1138063caldrons
camion103917193camion
cannon84514443cannon
canon74725303ca_non
canton85722993canton
canyon114512033canyon
capon95221873ca_pon
carbon104919043carbon
cardons104519943cardons
cardoon104813813cardoon
carn66245433ca_r_n
carob95325223ca_rob
carol75128613ca_rol
carom95025563ca_rom
carrion9312673carrion
carrom10513403carrom
carrot8423123carrot
carryon1237033carryon
carton84522663carton
cation83925503cation
cauldron1143243cauldron
chador1238673chad_or
chadors1338753chadors
chadri1238143chadr_i
chagrin1337893chagrin
chaldrons1545493chaldrons
chamfron1844493chamfron
chanfron1644803chanfron
chanson1238043chanson
chaperon1547353chaperon
charro114212953charro_
charros124312143charros
chevron1575783chevron
citron83112983citron
codon86522853cod_on
cordon95017293cordon
dacrons103211033dacrons
dado67126333dad_o_
dados75522433dad_os
daemon9279593daemon
dahoon1039053dahoon
daikon11217243daikon
daimon9259713daimon
dalton7311273dalton
damson938063damson
darn56434623da_r_n
dendron947653dendron
diatron839283diatron
dihedron13104113dihedron
diuron738573diuron
don46757653__d_on
drone65324983__drone
drop75324403__drop
drown95515823__drown
eardrop1065223eardrop
earn46737553ea_r_n
endrin7312403endrin
fadein1068843fadein
fado87226463fad_o_
fados95620733fad_os
falcon11310293falcon
fanion94514323fanion
fanon84619013fa_non
faro76136923fa_ro_
faros85532023fa_ros
farrow12309973farrow
gabion93211033gabion
gaboon93211773gaboon
gadjo1436913gadjo_
gadroons1037013gadroons
gallon73715813gallon
gammon1138903gammon
garcon92912483garcon
garden84215083garden
garrons82713463garrons
gascon9339723gascon
giron66118993_giron
godroon946043godroon
godson857383godson
gyron95314623_gyron
haar77323493haar__
haars85620473haar_s
haboob1377883haboob
had77658763had___
hadal95518123had_al
hadarim13117453hadarim
haddock1885583haddock
hade85440193had__e
haded105227623had_ed
hades96035113had_es
hading113922943hading
hadith13312063hadith
hadj155818673had__j
hadjee174111823hadjee
hadjes175210403hadjes
hadji16839893had_ji
hadjis17439653hadjis
hadst93220223had_st
haemin113412663haemin
haen76229453ha__en
haeres94017033haeres
hagborn1344953hagborn
hagdons1258523hagdons
hagrode1236443hagrode
hair76330143hair__
hairdo1036433hairdo
hairdos1136823hairdos
haired105117173haired
hairpin1245413hairpin
hairs86225173hair_s
hairy115316833hair_y
halcyon1543923halcyon
hallo85127553hallo_
halloa94918123halloa
halloo95118973halloo
hallos95425103hallos
hallot95426783hallot
hallow124818323hallow
halo76437323ha_lo_
halons95720713ha_lons
halos85230253ha_los
hambone1439313hambone
handgun1244623handgun
hansom11219153hansom
hao67251123ha__o_
haplont12412563haplont
happen134812193happen
hapten115312983hapten
harbor11410723harbor
hard85443503ha_r_d
hardens113815023hardens
harder105022403harder
hardly135112833hardly
hardpan1336443hardpan
hards96435653ha_rds
hardtop1345053hardtop
hardy125622063ha_rdy
hare76255733ha_r_e
hared95742183ha_red
harem104924453ha_rem
hares86255543ha_res
haring104233003ha_ring
hark115237393ha_r_k
harken135116343harken
harks126333433ha_rks
harl75740003ha_r_l
harlot94422803harlot
harls85634503ha_rls
harm95637793ha_r_m
harmin113117393harmin
harmony1538173harmony
harms106829013ha_rms
harp96134293ha_r_p
harpin113614383harpin
harpoon1238313harpoon
harps105926873ha_rps
harpy136418213ha_rpy
harrows132611033harrows
harry115322953ha_rry
harsh116418053ha_rsh
hart76865773ha_r_t
harts88441593ha_rts
hasten95718563hasten
hatbox1835133hatbox
hatpin112610613hatpin
hatred104814333hatred
hausen9610383hausen
haven114718533ha_ven
havior1248203havior
havoc1337183ha_voc
haymow1773683haymow
hazan173813613ha_zan
hazzan17236803hazzan
headlong1334123headlong
headman13229633headman
headmen13259513headmen
headpin1336003headpin
headroom1446303headroom
hereon93914363hereon
hern76134893h_er_n
hero74635783h_ero_
heroin94420593h_eroin
herons94820543h_erons
heros84930863h_eros
hidden11429743hidden
hodden113811453hodden
hoddin11369943hoddin
hon67759383h___on
horn76735613h_or_n
horror988723horror
hotrod1048803hotrod
hydra12249223hydr_a
hydrae13258573hydrae
hydrant1489053hydrant
hydras13239313hydras
hydria13227903hydria
hydric15227953hydric
hydrid14248973hydrid
hydrogen1646283hydrogen
hydroid1539713hydroid
hydronic1748093hydronic
hydrops16197413hydrops
hydrous14197883hydrous
hydroxy2454263hydroxy
hyperon1548183hyperon
hyson1138693h_yson
intron64215023intron
iron46728463__iron
jargon1448823jargon
kaon87521023ka__on
karn86129413ka_r_n
karoo92519583ka_roo
karroo10410013karroo
kation104315683kation
laden65022193lad_en
ladino73615123ladino
ladrones92710973ladrones
lagoon7410483lagoon
lardons83914493lardons
lardoon83410373lardoon
macon94519953ma_con
macro94718173macro_
macrons113514893macrons
macros104017013macros
madden103912523madden
madman113712383madman
madmen113511743madmen
madras94316433madras
madre85720173madr_e
madres93718183madres
madronas11288493madronas
madrones112912283madrones
madronos11337543madronos
madtom1138023madtom
maduro936983maduro_
maduros1036303maduros
madzoon1996063madzoon
mammon939643mammon
maroon83118203maroon
marrons93216973marrons
marrow112812603marrow
mascon103612743mascon
mason74820183ma_son
matrons93517633matrons
micron103714283micron
midiron1046003midiron
mikron12318503mikron
moron76925423_moron
narrow9269143narrow
nasion63914083nasion
nation64322803nation
natrons73215663natrons
neuron6310373neuron
odeon6411483_odeon
operon8811773operon
padre86018163padr_e
padres95016983padres
padri85815173padr_i
padrones112711043padrones
paeon74819493pa_eon
pardons103817623pardons
parol74826273pa_rol
parrot8320663parrot
parson83817903parson
parton84720993parton
patrol83213023patrol
patrons93818103patrons
patroon92811973patroon
pauldron1142473pauldron
pedro8313153pedro_
pedros9312183pedros
perron83216623perron
phaeton1235973phaeton
pharos11312063pha_ros
quadroon1844473quadroon
racon75422143ra_con
racoon83814473racoon
radian74117273radian
radio64922493radio_
radios74018673radios
radons74118533rad_ons
ramrod936833ramrod
ramson8310463ramson
ration64226013ration
ratoon64417373ratoon
ratton64116123ratton
rayon83815703ra_yon
readorn8310483readorn
redon65424883red_on
sadden83212403sadden
sadirons936023sadirons
saffron1344173saffron
safrol937283safrol
salmon84614183salmon
salon55228553sa_lon
saloon64418023saloon
saran53730303sa_ran
sarin55239253sa_rin
sarod65325873sa_rod
sarong73914873sa_rong
saros55238063sa_ros
shadoof1446133shadoof
shadow1337253shad_ow
shairn9269063shair_n
sharn84823703sha_r_n
squadron1843503squadron
talion6317713talion
talon55824113ta_lon
tampon102911233tampon
tardo65321103tardo_
tardyon1134673tardyon
tarn46842723ta_r_n
taro46846913ta_ro_
taroc75721643ta_roc
tarok97921073ta_rok
taros55640823ta_ros
tarot55943933ta_rot
tarpon82812803tarpon
tauon54816583ta_uon
taxon124414663ta_xon
thoron94713903thoron
udon56017743_ud_on
vagrom1235943vagrom
wadmol1234053wadmol
waggon1136393waggon
wagon94312953wa_gon
waitron1036333waitron
wanion93213063wanion
wanton94413813wanton
warden104515513warden
warn75239323wa_r_n
warren95012853warren
yapon104613583ya_pon
yarn75230043ya_r_n
yarrow12287933yarrow
yaupon11345493yaupon

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 Filter1786911127160.766233278.1
2DLD Change Limit1127164306.23318083.7
3Display Results4304300.1403071.4
 (SQL Overall)1786914307.13925030.3
 
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.