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

413 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
thoron9471390(None) 
thorn85318701thor_n
thoro86217871thoro_
thorons104511911thorons
boron76727142_boron
chorion12311772chorion
heron85025502_heron
horn76735612_hor_n
moron76925422_moron
phonon114012032phonon
photon1111514832photon
shoon84022012sho_on
shoran94016042shoran
shorn85722182shor_n
thereon10199262thereon
tholoi9339232tholoi
tholos94213002tholos
thorax1638252thorax
thoria93012892thoria
thoric114314042thoric
thorns95314102thorns
thorny12509842thorny
thorp104414262thor_p
thorpe113610092thorpe
thorps113610892thorps
thro77726422th_ro_
throb109816852th_rob
throe89321422th_roe
throne98517602th_rone
throng10539972th_rong
throw118719732th_row
thrown1214911442thrown
toon47740632t_o_on
torn46044252t_or_n
toro48045682t_oro_
toros54336192t_oros
torot56139942t_orot
toyon86715672t_oyon
trogon73611752trogon
aboon74918703abo_on
acorn75616623acor_n
adorn64917093ador_n
agorot7415003agorot
ahorse9311513ahorse
althorn1047763althor_n
apron7318833_apron
attorn6310793attor_n
baron78131243_baron
bethorn1238643bethor_n
bhoot104322103bho_ot
bicron103710773bicron
biotron937293biotron
boon67142173_bo_on
born67338413_bor_n
borons85520543_borons
boson76019733_boson
chevron1575783chevron
chiro105320343chiro_
chiros114617773chiros
chiton112612393chiton
chlorin123113003chlorin
cholo105217973cholo_
cholos114716853cholos
chon96627793ch__on
chook146015043cho_ok
chopin132712193chopin
choral115118493choral
chord115917263chor_d
chords125214633chords
chore105126763chor_e
chorea115216093chorea
chored125321883chored
chores114828023chores
choric133515903choric
chorine123218363chorine
choring133617663choring
chorions13310663chorions
choroid13311803choroid
chorten122811303chorten
chorus115014773chorus
chosen116014133chosen
chronon1237353chronon
churn105113103chur_n
citron83112983citron
codon86522853_codon
cogon89120903_cogon
colon78630193_colon
coon67248943_co_on
cordon95017293_cordon
corn69945813_cor_n
corona83817403_corona
croon75522783cro_on
croton84415453croton
dacron94310693dacron
dahoon1039053daho_on
dehorn10439653dehor_n
dhoora1035653dhoora
diuron738573diuron
dromon939363dromon
ethion938813eth_ion
florin9312653florin
garron73113493garron
giron66118993_giron
gnomon936183gnomon
goon57236173_go_on
gorgon8310243_gorgon
gyron95314623_gyron
hadron102913753hadron
halon86124863_halon
hereon93914363_hereon
hern76134893_her_n
hero74635783_hero_
heroin94420593_heroin
herons94820543_herons
heros84930863_heros
hobo97026083_hobo_
hobos106321353_hobos
hogan97817703_hogan
homo96126473_homo_
homos105921783_homos
hon67759383_h__on
honan85319773_honan
honor85718623_honor
hood85132333_ho_od
hoof106036583_ho_of
hook116133283_ho_ok
hoop96129983_ho_op
hoot75752103_ho_ot
hora76136563_hor_a
horah117922053_horah
horal86328683_horal
horas86333103_horas
horde94623053_horde
horizon1955763_horizon
hormone12410503_hormone
horns86125333_horns
horny115619623_horny
horror988723_horror
horse86132653_horse
horst85833513_horst
horsy116318393_horsy
hosen85623883_hosen
hotrod1048803_hotrod
hyson1138693_hyson
intron64215023intron
iron46728463__iron
isogon7227543isogon
jomon14610083_jomon
korun9411923_korun
kroon94514483kro_on
ladron73413323ladron
logon615922313_logon
loon47344793_lo_on
loran55925093_loran
lorn46435253_lor_n
macron103615673macron
maroon83118203maroon
marron83717543marron
matron83918313matron
micron103714283micron
mikron12318503mikron
moon67140813_mo_on
morion86217733_morion
morn66237563_mor_n
morons84919543_morons
natron64116023natron
neocon836713neocon
neuron6310373neuron
noon47134623_no_on
operon8811773operon
orlon5415003__orlon
patron84018043patron
perron83216623perron
pharos11312063pharos
phon95925383ph__on
phono104917023phono_
phonons123310253phonons
phonos114114793phonos
phoronid1449073phoronid
photo104417233photo_
photog12379813photog
photons123814433photons
photos113316643photos
phylon14318033phylon
phyton143610253phyton
poon67341263_po_on
porn65636023_por_n
porno75120653_porno
proton84318893proton
rhyton12356113rhyton
scorn75817453scor_n
sharn84823703shar_n
shogun1045713shogun
sholom11910113sholom
shoo75929893sho_o_
shook124920163sho_ok
shool84523153sho_ol
shoos84226363sho_os
shoot84235913sho_ot
shorans102812413shorans
shore85432653shor_e
shored105723653shored
shores94830413shores
shoring112820073shoring
shorl84720253shor_l
shorls94516203shorls
short85040533shor_t
shorten103511413shorten
shorts95321743shorts
shorty124313203shorty
shown115216483sho_wn
solon55026133_solon
soon46240503_so_on
sorn46641063_sor_n
spoon74719443spo_on
stolon64112073stolon
swoon85014783swo_on
sworn86115313swor_n
taborin92210453taborin
talion6317713talion
talon55824113t_alon
tampon102911233tampon
tarn46842723t_ar_n
taro46846913t_aro_
taroc75721643t_aroc
tarok97921073t_arok
taros55640823t_aros
tarot55943933t_arot
tarpon82812803tarpon
tauon54816583t_auon
taxon124414663t_axon
teflon937453teflon
telson6310293telson
tendon7312033tendon
tenon53320513t_enon
teopan839353teopan
tern46134803t_er_n
terror63811733terror
teston6313303teston
than76128773th__an
tharm105916643thar_m
tharms115712243tharms
thegn95810903th_egn
thein85919023th_ein
then78429693th__en
theogony1543463theogony
theolog1146153theolog
theorbo1243743theorbo
theorbos1343643theorbos
theorem1236273theorem
theory121098363theor_y
there87527393ther_e
therein102310353therein
thereof13168063thereof
theres96525473theres
therian10311293therian
therm106018023ther_m
therme115814993therme
thermion1345933thermion
thermos124610753thermos
therms115914873therms
theroid11313403theroid
thin76732393th__in
thio77225413th_io_
thiol87616043th_iol
thionin1048673thionin
thir76420543thir__
thiram1139963thiram
third95912493thir_d
thirds10438603thirds
thirl85416823thir_l
thirls95012063thirls
thirst9312253thirst
thirty12378403thirty
tho67433963th__o_
thole85620843tho_le
tholed105113873tholed
tholes94919783tholes
tholing112812333tholing
thong95014183tho_ng
thongs104611193thongs
thorias102312053thorias
thorite10313443thorite
thorium12208413thorium
thorned11479403thorned
thorning1237513thorning
thorough15684133thorough
thorpes125010353thorpes
those85218143tho_se
thou76722213th__ou
thoued10429003thoued
though139410783though
thouing11258603thouing
thous86017263tho_us
thraw1110515923th_raw
thrawn12769423thrawn
three87526913th_ree
threw1117315713th_rew
thrip103012183th_rip
throat94819753throat
throbs118311373throbs
throes97518673throes
throned115412173th_roned
thrones105715843th_rones
throngs11508163th_rongs
throve128012393throve
throws129715233throws
thru76818943th_r_u
thrum104713633th_rum
thurl84912683thur_l
thurls9418713thurls
thymol1434463thymol
thyroid1438253thyroid
thyroxin2144183thyroxin
thyrse1235133thyrse
thyrsi1234453thyrsi
tiglon737923tiglon
tigon63914443t_igon
tinhorn1046033tinhor_n
tiro46832363t_iro_
tiros54524893t_iros
token95419313t_oken
tolan55124013t_olan
toman75724053t_oman
ton310265103t___on
too38965423t_o_o_
took86531073t_o_ok
tool46735683t_o_ol
toom66532933t_o_om
toons55027533t_o_ons
toot45958883t_o_ot
topo66932403t_opo_
topoi76018353t_opoi
topos75726393t_opos
tor39261683t_or__
tora47545993t_or_a
torah87125273t_orah
toras55540373t_oras
torc66333353t_or_c
torch107420933t_orch
torchon1237363t_orchon
torcs75123763t_orcs
tore47359323t_or_e
tores55352673t_ores
tori47542153t_or_i
toric76529313t_oric
torii55521593t_orii
toroid7416013t_oroid
torose64317693t_orose
toroth95512963t_oroth
torous64319033t_orous
torpor839193t_orpor
torr45630903t_or_r
torrs53923563t_orrs
tors46157383t_or_s
torse55833333t_orse
torsi57423363t_orsi
torsion7310803t_orsion
torsk94915773t_orsk
torso56922143t_orso
torsos64815733t_orsos
tort46967463t_or_t
torta55925353t_orta
torte55431703t_orte
torten65314353t_orten
tortoni738033t_ortoni
torts56138123t_orts
torus54329763t_orus
tory75840543t_or_y
town76928703t_o_wn
toxin124716713t_oxin
toyo76925453t_oyo_
toyons95512133t_oyons
toyos87519143t_oyos
trigon74513103trigon
triton63914893triton
trod57627953t__rod
trog57628213t__rog
trogons83410723trogons
trona54118953t__rona
trone55131863t__rone
troop76417533tro_op
trooz145016153tro_oz
trop66833303t__rop
tropin83316753tropin
trot46351313t__rot
trow78031423t__row
troy77429683t__roy
tsores65113663tsores
tsoris63411193tsoris
turion6313163turion
turn46330393t_ur_n
turnon638193turnon
tycoon1136023tycoon
typhon1436673typhon
typhoon1544653typho_on
tyro76622363t_yro_
tyros85118593t_yros
whereon13196503whereon
whoof144612693who_of
whoop134211443who_op
whore116018043whor_e
whored135512123whored
whores125617103whores
whoreson1444013whoreson
whoring142910293whoring
whorl114612453whor_l
whorls124410163whorls
whort114623693whor_t
whorts125111433whorts
whoso11509223whoso_
worn75631753_wor_n
zoon137326983_zo_on

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.373479064.3
2DLD Change Limit1127164135.36021029.1
3Display Results4134130.1233357.7
 (SQL Overall)1786914135.85630514.2
 
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.