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

181 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
hormone1241050(None) 
hormones13311161hormones
fordone1149382fordone
forgone1139342forgone
harmine122816192harmine
harmony1538172harmony
hogmane1336342hogmane
hormonal1346632hormonal
hormonic1568152hormonic
orgone71110912_orgone
anemone9119453anemone
borane84620213bor_ane
borne77926793bor__ne
boron76727143bor_on_
borons85520543bor_ons
bromine112915243bromine
carmine112918483carmine
chorine123218363chor_ine
chorion12311773chorion_
chorions13310663chorions
colone85425003co_lone
commode1438123commode
common12310803common_
commoner142710633commoner
commons13311043commons
commove1635963commove
commune13329363commune
comose105016843co_mose
compone136517193compone
condone102616293condone
cordon95017293cordon_
cordoned12229613cordoned
cordons104415763cordons
cormoid12310403cormoid
cormous11312353cormous
cornpone1246933cornpone
corona83817403cor_ona
coronae94214893cor_onae
coronel94515223cor_onel
coroner94218203cor_oner
coronet94227173cor_onet
corrode101310573corrode
corvine122113643corvine
crone75231333_cr_one
doggone1035683doggone
domine92918253do_mine
dormant102814373dormant
dormice1237133dormice
dormie9312623dorm_ie
dormin9312313dormin_
dormins10311273dormins
dormouse1144243dormouse
dromon939363dromon_
dromond1135473dromond
dromons1038193dromons
drone65324983_dr_one
ermine8416923_ermine
forbode13257963forbode
forbore12249673forbore
forborne13195003forborne
foredone1249733foredone
foregone1238583foregone
formant123416003formant
formate123115093formate
forme105225993form__e
formee113919943form_ee
forming133615733forming
formol112910333formo_l
formols12299413formols
fortune1068303fortune
germane1049663germane
gorgon8310243gorgon_
gorgons938853gorgons
gormand1157453gormand
gorming112810833gorming
hambone1439313hambone
harmin113117393harmin_
harmines132715143harmines
harming133717933harming
harmins123716723harmins
harmonic1589433harmonic
harmonies141311043harmonies
harmonise14148763harmonise
harmonize23137713harmonize
hereon93914363hereon_
hermae115314473herm_ae
heroine103517483heroine
heron85025503her_on_
herons94820543her_ons
hexone16289233h_exone
hipbone1445923hipbone
hircine1239143hircine
histone10312843histone
hogmanes1446783hogmanes
hognose11117243hognose
homage121210603ho_mage
hombre13309303ho_mbre
home98042443ho_m__e
homie104622533ho_m_ie
homines123518643ho_mines
homing123718383ho_ming
hominy144511483ho_miny
hommock2043993hommock
hommos13128503hommo_s
hommoses1538153hommoses
homo96126473ho_mo__
homonym1745253ho_monym
homos105921783ho_mo_s
homosex1936123ho_mosex
hone77549323h___one
hoopoe11911233hoopo_e
horde94623053hor__de
hording123517053hording
horizon1955763horizon_
horizons2045463horizons
horn76735613hor__n_
horned105718703hor__ned
hornet94926433hor__net
horning113015003horning
horns86125333hor__ns
hornstone1266073hornstone
horny115619623hor__ny
horologe1248363horologe
horrent10313553horrent
horror988723horro_r
horrors1078693horrors
horse86132653hor__se
horsing113215583horsing
horste94817413hor_ste
hotline10712353hotline
hourlong1242733hourlong
humane112812173h_umane
ionone6313443io_none
irone55126363_ir_one
jomon14610083jo_mon_
krone94018733_kr_one
moraine9314573moraine
morion86217733morion_
morions94014643morions
moron76925423mor_on_
morons84919543mor_ons
morose85116243mor_ose
nonmoney1346273nonmoney
normande1145933normande
ochone11311293_ochone
orgones81010793_orgones
oriole6814293_oriole
orlon5415003_orlon_
orlons6411013_orlons
ormolu845833_ormolu
orpine83914483_orpine
osmole8128513_osmole
osmose8108003_osmose
ozone14310613_o_zone
pheromone1645413pheromone
porcine11312843porcine
porose84818743por_ose
promine112819443promine
promote11313143promote
prone75332623_pr_one
propone112716303propone
pyrone112714473pyr_one
sermon8413553sermon_
sermons9311783sermons
someone938813someone
somoni8310743so_moni
sorbose938983sorbose
sordine82515233sordine
spumone1154383spumone
thoron94713903thor_on_
thorons104511913thor_ons
throne98517603thr_one
torment9316173torment
torose64317693tor_ose
tortoni738033tortoni
towmond1394203towmond
towmont1277633towmont
trombone1245363trombone
trone55131863_tr_one
wormhole1644663wormhole
worming132811243worming

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.1561145455.1
2DLD Change Limit1340271816.87319500.5
3Display Results1811810.0632873.0
 (SQL Overall)1786911817.09225196.1
 
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.