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

417 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
thoria9301289(None) 
thorias102312051thorias
thoric114314041thoric
aporia8315862aporia
chorea115216092chorea
chorial124214142chorial
choric133515902choric
coria75828322_coria
gloria71910552gloria
hora76136562_hor_a
noria55722182_noria
phobia13278602phobia
scoria8513502scoria
sharia93116732sharia
shortia1048192shortia
theriac1239142theriac
therian10311292therian
thorax1638252thorax
thorite10313442thorite
thorium12208412thorium
thorn85318702thor_n
thorns95314102thorns
thorny12509842thorny
thoro86217872thor_o
thoron94713902thoron
thorp104414262thor_p
thorpe113610092thorpe
thorps113610892thorps
thrip103012182th_rip
thulia936112thulia
tora47545992t_or_a
tori47542152t_ori_
toric76529312t_oric
torii55521592t_orii
torta55925352t_orta
tsoris63411192tsoris
acholia1239973acholia
agora6914333agor_a
agria65517143_agria
ahorse9311513ahorse
alodia71112453alodia
anopia83412393anopia
anoxia133510023anoxia
anthodia1247803anthodia
anuria6313123anuria
aorta55922573_aorta
aphonia122711883aphonia
aporias9315153aporias
aria46245423__aria
atonia63816513atonia
atria56022343_atria
authorial1247083authorial
bora66141633_bor_a
boric98024223_boric
bothria1246443both_ria
ceria75125353_ceria
charka154011703charka
chia96026623ch__ia
chloric143410613chloric
chlorid133211843chlorid
chlorin123113003chlorin
choana1138443choana
choir105313603cho_ir
choirs114911883choirs
chola104718033cho_la
cholla113911023cholla
chopin132712193chopin
choral115118493choral
chord115917263chor_d
chordal13449883chordal
chords125214633chords
chore105126763chor_e
choreal124412223choreal
choreas124414203choreas
chored125321883chored
choreic1438703choreic
chores114828023chores
choriamb1744163choriamb
chorine123218363chorine
choring133617663choring
chorion12311773chorion
chorizo2136323chorizo
choroid13311803choroid
chorus115014773chorus
chroma132912473chroma
ciboria1147043ciboria
cobia94117513_cobia
curia74523773_curia
dharma1276103dharma
dharna1055263dharna
dhobi1136973dhobi_
dhobis1236113dhobis
dhoora1035653dhoora
dhoti9310123dhoti_
dhotis1038973dhotis
dhourra1152023dhourra
dhurna1043563dhurna
dorsa64617283_dorsa
emporia1148753emporia
ephori1139603ephori_
etheric12311783etheric
euphoria13116863euphoria
exordia1544983exordia
feria85922713_feria
flora85317103flor_a
florid10311453florid
florin9312653florin
folia83618933_folia
fora75937393_for_a
gharial1137343gharial
glorias81610323glorias
gonia64117533_gonia
herma105318883_herma
hernia9312293_hernia
holla84918493_holla
homie104622533_homie
honda9414983_honda
hooka125513903_hooka
horah117922053_horah
horal86328683_horal
horas86333103_horas
horde94623053_horde
horn76735613_hor_n
horns86125333_horns
horny115619623_horny
horrid10311563_horrid
horse86132653_horse
horst85833513_horst
horsy116318393_horsy
hosta85917833_hosta
houri85915253_houri_
houris94514583_houris
hoya107418373_ho_ya
hydria13227903hydria
ixora1236913ixor_a
kerria10339913kerria
kora86431553_kor_a
korai97018523_korai
korma115913073_korma
latria62313603latria
logia68116603_logia
lorica8310443_lorica
loris55329153_loris
mahonia1238443mahonia
maria75032883_maria
moira71012023_moira
mora66641273_mor_a
myopia13318443myopia
nori47133143_nori_
norias65518203_norias
noris54928273_noris
nutria639913nutria
obia67923113__obia
ohia75719363__ohia
oorie53026363_oorie
ora37250833__or_a
orca65522773__orca
orra46120723__orra
peloria9310953peloria
phobias14228183phobias
phobic153010073phobic
phonic133315213phonic
photic133316443photic
podia8415283_podia
poori74816233poori_
pooris83916843pooris
propria1149933propria
pyuria1136953pyuria
rhodic12227233rhodic
rhotic112711233rhotic
ria36745503___ria
scholia1237833scholia
scoriae9310903scoriae
scotia8310803scotia
shariah132210533shariah
sharias102516003sharias
sharif122917123sharif
sherif122915243sherif
sherpa1138093sherpa
shogi95014013shogi_
shogis103810943shogis
shoji15419963shoji_
shojis16348493shojis
shoran94016043shoran
shore85432653shor_e
shored105723653shored
shores94830413shores
shoring112820073shoring
shorl84720253shor_l
shorls94516203shorls
shorn85722183shor_n
short85040533shor_t
shortias1148093shortias
shortie10411343shortie
shorts95321743shorts
shorty124313203shorty
shri76021703sh_ri_
shris84221453sh_ris
sora45746913_sor_a
sori46039843_sori_
sorta57125413_sorta
sthenia1058503sthenia
stria55723213_stria
taborin92210453taborin
taenia6313193taenia
taffia12286903taffia
tafia84215493t_afia
talaria7412523talaria
tarsia65514273tarsia
telia55821143t_elia
tenia55324483t_enia
tentoria8119263tentoria
terai53525483t_erai
terbia8311153terbia
terga63315643t_erga
terra54419663t_erra
territ63421373territ
tetra53417953tetr_a
tetri52716453tetri_
tetris62816293tetris
thairm1156963thairm
tharm105916643thar_m
tharms115712243tharms
theca103311453th_eca
thein85919023th_ein
their85512153th_eir
theirs94610353theirs
theorbo1243743theorbo
theorem1236273theorem
theories11311593theories
theorise1137873theorise
theorist1149553theorist
theorize2047073theorize
theory121098363theor_y
there87527393ther_e
thereat104315243thereat
therein102310353therein
theres96525473theres
theriaca1344153theriaca
theriacs1336543theriacs
therians1138313therians
therm106018023ther_m
thermae125310503thermae
thermal125010973thermal
therme115814993therme
thermic1439333thermic
thermit12312013thermit
therms115914873therms
theroid11313403theroid
thesis94913733thesis
theta83414573th_eta
thetic11412893thetic
thin76732393th__in
thio77225413th__io
thiolic1247323thiolic
thionic1238893thionic
thionin1048673thionin
thiourea1193073thiourea
thir76420543th__ir
thiram1139963thiram
third95912493thir_d
thirds10438603thirds
thirl85416823thir_l
thirls95012063thirls
thirst9312253thirst
thirty12378403thirty
this76027383th__is
tho67433963tho___
thole85620843tho_le
tholed105113873tholed
tholes94919783tholes
tholing112812333tholing
tholoi9339233tholoi
tholos94213003tholos
thong95014183tho_ng
thongs104611193thongs
thoracal1344913thoracal
thoracic1546393thoracic
thorites11312393thorites
thoriums13166403thoriums
thorned11479403thorned
thornier1135323thornier
thornily1444163thornily
thorning1237513thorning
thorons104511913thorons
thorpes125010353thorpes
those85218143tho_se
thou76722213tho__u
thoued10429003thoued
though139410783though
thouing11258603thouing
thous86017263tho_us
thraw1110515923th_raw
thread105011093th_read
threap11569663th_reap
threat95020463th_reat
three87526913th_ree
threw1117315713th_rew
thrice114311573th_rice
thrift12412043th_rift
thrill94910593th_rill
thrips11299013th_rips
thrive125313223th_rive
thro77726423th_r_o
throat94819753throat
throb109816853th_rob
throbs118311373throbs
throe89321423th_roe
throes97518673throes
throne98517603throne
throng10539973throng
throve128012393throve
throw118719733th_row
thrown1214911443thrown
throws129715233throws
thru76818943th_r_u
thrum104713633th_rum
thuja1535213th_uja
thulias1035743thulias
thurl84912683thur_l
thurls9418713thurls
thuya1135583th_uya
thymi13418633thymi_
thymic16307423thymic
thyroid1438253thyroid
thyrse1235133thyrse
thyrsi1234453thyrsi
tiara5315913tiar_a
tibia7312403t_ibia
tithonia1195613tithonia
toea46732333t_o_ea
toga57027413t_o_ga
toil46536283t_o_il
toit46353063t_o_it
tola45236333t_o_la
tonga65619703t_onga
tonic74727653t_onic
toonie63617993toonie
topi67830393t_opi_
topic95721503t_opic
topis76025833t_opis
tor39261683t_or__
torah87125273t_orah
toras55540373t_oras
torc66333353t_or_c
torch107420933t_orch
torcs75123763t_orcs
tore47359323t_or_e
tores55352673t_ores
torics85118353t_orics
tories65435883t_ories
torn46044253t_or_n
toro48045683t_or_o
toroid7416013t_oroid
toros54336193t_oros
torot56139943t_orot
torpid9310913t_orpid
torr45630903t_or_r
torrid7311853torrid
torrs53923563t_orrs
tors46157383t_or_s
torse55833333t_orse
torsi57423363t_orsi
torsk94915773t_orsk
torso56922143t_orso
tort46967463t_or_t
tortas64918253t_ortas
torte55431703t_orte
torts56138123t_orts
torula6610393t_orula
torus54329763t_orus
tory75840543t_or_y
towie85821873t_owie
toxic145315623t_oxic
toxin124716713t_oxin
triac74116373t__riac
triad65217723t__riad
trial54926353t__rial
triforia1145643triforia
trig55528163t__rig
trim65329523t__rim
trio45233343t__rio
trip66830393t__rip
trivia938503trivia
troika1035493troika
trois57226093tro_is
trona54118953tro_na
tropic103014193tropic
tropin83316753tropin
tsarina736653tsarina
tsooris734693tsooris
tsores65113663tsores
tsouris735153tsouris
tsuris62710203tsuris
tugrik1134283tugrik
tutorial847833tutorial
tzarina1635053tzarina
tzuris15286913tzuris
utopia8107883utopia
uxorial1446323uxorial
varia85824203_varia
whoa106615203who__a
whore116018043whor_e
whored135512123whored
whores125617103whores
whoring142910293whoring
whorish1636603whorish
whorl114612453whor_l
whorls124410163whorls
whort114623693whor_t
whorts125111433whorts
whosis1237173whosis
yttria954803yttria
zoaria1548383zoaria
zori137722923_zori_
zoril143916693_zoril
zoris145320013_zoris

Search took 7 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.406440125.6
2DLD Change Limit1127164175.50020493.8
3Display Results4174170.1263309.5
 (SQL Overall)1786914176.03229623.8
 
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.