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

353 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
thorons10451191(None) 
thorns95314091thor_ns
thoron94713901thoron_
borons85520542_borons
chorions13310652chorions
herons94820542_herons
horns86125332_hor_ns
morons84919542_morons
phonons123310252phonons
photons123814412photons
shorans102812402shorans
tholos94213002tholo_s
thorias102312042thorias
thorn85318702thor_n_
thorny12509842thor_ny
thoro86217872thoro__
thorpes125010352thorpes
thorps113610892thor_ps
throbs118311372th_robs
throes97518672th_roes
throne98517602th_rone
thrones105715842th_rones
throng10539972th_rong
throngs11508162th_rongs
throws129715232th_rows
toons55027532t_o_ons
toros54336192t_oro_s
torous64319022t_orous
toyons95512132t_oyons
trogons83410712trogons
acorns85013013acor_ns
adorns74212613ador_ns
althorns1146723althor_ns
amorous9311133amorous
aprons8316993_aprons
attorns738433attor_ns
barons85025383_barons
bethorns1337323bethor_ns
bhoots11459903bho_ots
bicrons113410473bicrons
biotrons1037233biotrons
boons75031913_bo_ons
boron76727143_boron_
bosons85016653_bosons
chevrons1665463chevrons
chiros114617773chiro_s
chitons122611913chitons
chlorins132612883chlorins
chlorous1339213chlorous
cholos114716853cholo_s
chooks155312793cho_oks
chopins142312243chopins
chorals124614103chorals
chords125214633chor_ds
choreas124414203choreas
chores114828023chor_es
chorine123218363chorine
chorines132917253chorines
choring133617663choring
chorion12311763chorion_
choroid13311793choroid
choroids1438683choroids
chortens13308793chortens
chorus115014763chor_us
chronons1347353chronons
churns114910233chur_ns
citrons92913223citrons
codons96119463_codons
cogons96818113_cogons
colons86028683_colons
coons76737283_co_ons
cordons104415763_cordons
corns76034763_cor_ns
corona83817403_corona
coronas93916903_coronas
croons85418423cro_ons
crotons93714373crotons
dacrons103211033dacrons
dahoons1137753daho_ons
dehorns11428363dehor_ns
dhooras1135943dhooras
diurons838823diurons
dromons1038193dromons
ethions1038483eth_ions
florins10311643florins
frons86124043__frons
garrons82713463garrons
girons75014373_girons
gnomons1035753gnomons
goons65326773_go_ons
gorgons938853_gorgons
gyrons105511223_gyrons
hadrons113314303hadrons
halons95720713_halons
herns84825583_her_ns
heroes94923823_heroes
heroins103518013_heroins
heron85025503_heron_
heros84930863_hero_s
hoboes114717443_hoboes
hobos106321353_hobo_s
hogans105914313_hogans
homos105921783_homo_s
honans94814503_honans
honors94816793_honors
hons77350783_h__ons
hoods95124083_ho_ods
hoofs115721043_ho_ofs
hooks125027123_ho_oks
hoops105621073_ho_ops
hoots84830243_ho_ots
horahs126313873_horahs
horas86333093_hor_as
hordes104921633_hordes
horizons2045463_horizons
hormone12410503_hormone
hormones13311163_hormones
horn76735613_hor_n_
horny115619623_hor_ny
horrors1078693_horrors
horses94729343_horses
horsts95817513_horsts
hotrods1148283_hotrods
hysons1237633_hysons
ichorous1346973ichorous
introns73515023introns
irons55324133__irons
isogons8217613isogons
kroons103711243kro_ons
ladrons83813193ladrons
logons79818173_logons
loons55731723_lo_ons
lorans65117603_lorans
macrons113514893macrons
maroons92615553maroons
marrons93216973marrons
matrons93517633matrons
microns113814783microns
mikrons13428413mikrons
moons75331003_mo_ons
morions94014633_morions
morns75527443_mor_ns
moron76925423_moron_
natrons73215663natrons
neocons936913neocons
neurons7410443neurons
noons54125283_no_ons
odorous837663odorous
operons91411743operons
orlons6411013__orlons
patrons93818103patrons
perrons93115483perrons
pharos11312063pharo_s
phonon114012033phonon_
phonos114114793phono_s
phons105221143ph__ons
phoronid1449073phoronid
phoronids1545663phoronids
photogs13358203photogs
photon1111514823photon_
photos113316633photo_s
phytons15319063phytons
poons75430973_po_ons
pornos85015253_pornos
porns75527343_por_ns
porous84419483_porous
protons93118003protons
rhytons13295883rhytons
scorns85713013scor_ns
sharns95516983shar_ns
shoguns1134413shoguns
sholoms1278013sholoms
shooks134515623sho_oks
shools94919003sho_ols
shoon84022003sho_on_
shoos84226353sho_o_s
shoots94619343sho_ots
shoran94016033shoran_
shores94830403shor_es
shoring112820063shoring
shorings12269483shorings
shorls94516193shor_ls
shorn85722173shor_n_
shortens11288983shortens
shorts95321733shor_ts
solons65120013_solons
sorns55028413_sor_ns
spoons84116013spo_ons
stolons73410233stolons
swoons94511143swo_ons
taborins103310213taborins
talions7314093talions
talons64019423t_alons
tampons112711553tampons
tarns56433953t_ar_ns
tarocs84615663t_arocs
taroks106115283t_aroks
taros55640823t_aro_s
tarots66422993t_arots
tarpons92612203tarpons
tauons63412673t_auons
taxons134211503t_axons
teflons1036533teflons
telsons739203telsons
tendons8311473tendons
tenons62916603t_enons
teopans939203teopans
terns55226873t_er_ns
terrors73112203terrors
testons7313553testons
tharms115712243thar_ms
thegns10547433th_egns
theins95015423th_eins
thens85921833th__ens
theogony1543463theogony
theologs1246153theologs
theorbos1343643theorbos
theorems1344693theorems
theories11311593theories
thereon10199263thereon_
theres96525473ther_es
therians1138313therians
thermes126214613thermes
thermions1445333thermions
thermos124610753thermos
therms115914873ther_ms
theroid11313393theroid
thins85826323th__ins
thiols95112763th_iols
thionins1177923thionins
thirams1236803thirams
thirds10438603thir_ds
thirls95012063thir_ls
thirsts1036243thirsts
tholes94919783tho_les
tholing112812333tholing
tholoi9339223tholo_i
thong95014173th__ong
thongs104611183tho_ngs
thoraces13118933thoraces
thorax1638253thor_ax
thoraxes1896353thoraxes
thoria93012883thor_ia
thoric114314033thor_ic
thorite10313443thorite
thorites11312393thorites
thorium12208403thorium
thoriums13166393thoriums
thorned11479403thorned
thorning1237513thorning
thorough15684123thorough
thorp104414263thor__p
thorpe113610093thor_pe
thouing11258603thouing
thous86017253th__ous
thraws129211103th_raws
threes97117323th_rees
thrips11299013th_rips
thro77726423th_ro__
throat94819753th_roat
throats104612173throats
throb109816853th_ro_b
throe89321423th_ro_e
throned115412173th_roned
throve128012393th_rove
throw118719733th_ro_w
thrown1214911443th_rown
thrums11429123th_rums
thurls9418713thur_ls
thymols1533843thymols
thyroid1438243thyroid
thyroids1546003thyroids
thyroxins2243643thyroxins
thyrses1335013thyrses
thyrsus1342683thyrsus
tiglons837333tiglons
tigons74112253t_igons
timorous1047433timorous
tinhorns1145003tinhor_ns
tiros54524893t_iro_s
tokens104711563t_okens
tolans64319273t_olans
tomans85419133t_omans
tons46553053t___ons
tools55325243t_o_ols
toon47740633t_o_on_
toots55331873t_o_ots
topos75726393t_opo_s
torahs95115643t_orahs
toras55540373t_or_as
torchons1337503t_orchons
torcs75123763t_or_cs
tores55352673t_or_es
torics85118353t_orics
tories65435883t_ories
torn46044253t_or_n_
toro48045683t_oro__
toroid7416013t_oroid
toroids8310643t_oroids
torose64317693t_orose
torot56139943t_oro_t
toroth95512963t_oroth
torpors939373t_orpors
torrs53923563t_or_rs
tors46157383t_or__s
torses64727953t_orses
torsions839183t_orsions
torsks10549123t_orsks
torsos64815733t_orsos
tortas64918253t_ortas
tortes64826053t_ortes
tortoni738033t_ortoni
tortonis848733t_ortonis
torts56138123t_or_ts
torus54329763t_or_us
towns86018883t_o_wns
toxins133314283t_oxins
toyon86715673t_oyon_
toyos87519143t_oyo_s
trans54933043t__rans
trigons84312093trigons
tritons73814883tritons
trogon73611753trogon_
trogs67022603t__rogs
trois57226093t__rois
trona54118953t__rona
tronas63816893t__ronas
trone55131863t__rone
trones65629283t__rones
troops85712773tro_ops
tropins93116303tropins
trots56629943t__rots
trows88826183t__rows
troys86418613t__roys
tsooris734693tsooris
tsores65113663tsor_es
tsoris63411193tsor_is
tumorous1046593tumorous
turions7311573turions
turnons737863turnons
turns55623233t_ur_ns
tycoons1235173tycoons
typhons1537083typhons
typhoons1644563typho_ons
tyros85118593t_yro_s
whoofs15457243who_ofs
whoops14487863who_ops
whores125617103whor_es
whoresons1543863whoresons
whoring142910293whoring
whorls124410163whor_ls
whorts125111433whor_ts
zoons144919693_zo_ons

Search took 10 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.1401276364.3
2DLD Change Limit1340273539.19014584.0
3Display Results3533530.1232869.9
 (SQL Overall)1786913539.45318903.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.