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

366 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
theory12109836(None) 
cheery144913152cheery
cherry144810762cherry
henry114014472_henry
herry114922472_herry
sherry124510412sherry
teary85124052t_eary
terry84721872t_erry
their85512152their_
theirs94610352theirs
theorbo1243742theorbo
theorem1236272theorem
there87527392the_re
therm106018022the_rm
theurgy1442732theurgy
thewy146311852the_wy
they107223752the__y
thorn85318702th_orn
thorny12509842th_orny
thoro86217872th_oro
thorp104414262th_orp
tory75840542t__ory
wherry15477332wherry
abhenry1543333abhenry
aery77231683_ae_ry
ahoy101919183ah_o_y
apery106517903ape_ry
armory114211473armory
aweary1237303aweary
beery105220123_beery
berry104521773_berry
bleary115112553bleary
calory11312843calory
ceorl7410913_ceorl
charry145012113charry
chary135023133ch_ary
cheeky18448613cheeky
cheer105420383cheer_
cheerly15417603cheerly
cheero114712933cheero
cheers114518913cheers
cheesy14419193cheesy
chert105232103che_rt
cherty144612473cherty
chesty144610503chesty
chevre14318313chevre
chevy16479993che_vy
chewy165011903che_wy
chicory1735993chicory
choky175711223ch_oky
choosy14459103choosy
chord115917263ch_ord
chore105126763ch_ore
chromy16309903chromy
cory96941513__cory
deary95826843_deary
decry115514353_decry
dehorn10439653dehorn
dehort104618103dehort
deoxy1648883_deoxy
derry94721373_derry
dhooly13457143dhooly
dhoora1035653dhoora
dithery14318943dithe_ry
dory85836233__dory
dreary104611673dreary
eery76129623__eery
emery104814333eme_ry
ether84518773ethe_r_
ethers94518413ethe_rs
ethoxy1933923eth_oxy
every115215453eve_ry
eyry106315883__eyry
faery116015483fae_ry
ferry116020803_ferry
fiery114714793fie_ry
fleury12417353fleury
gharry13546273gharry
glory96413293_glory
gory86129663__gory
hairy115316833_hairy
harry115322953_harry
heady125117263_heady
heapy135914983_heapy
hear76143883_hear_
heard95222753_heard
hears86737373_hears
heart85440743_heart
hearty126313633_hearty
heavy144814183_heavy
hedgy134510743_hedgy
hefty146112133_hefty
heir77523803_heir_
heirs85618563_heirs
helotry1345653_helotry
hempy154912763_hempy
henrys12366103_henrys
her66547813_he_r_
herb94730963_he_rb
herby134715313_herby
herd84933063_he_rd
here76447103_he_re
herl75834553_he_rl
herm95636153_he_rm
hern76134893_he_rn
hero74635783_he_ro
heron85025503_heron
heronry1346043_heronry
heros84930863_heros
hers75844873_he_rs
hey96741063_he__y
hoary114516763_hoary
hoer76533983_hoer_
hoers85724923_hoers
holy106333433_h_oly
homy126623223_h_omy
hoody124919723_hoody
hooey114926603_hooey
hooky155220263_hooky
hooly115022223_hooly
hooray123011373_hooray
hooty115022443_hooty
hora76136563_h_ora
horn76735613_h_orn
horny115619623_h_orny
horsy116318393_h_orsy
hoy97447913_h_o_y
hurry114917183_hurry
ither84617603ithe_r_
ivory1137373_ivory
jerry155016183_jerry
kerry124916093_kerry
lathery133911123lathe_ry
leary85927383_leary
leery85919133_leery
lory75931713__lory
memory1338803memory
merry104721483_merry
moory105115793_moory
mothery153710513mothe_ry
ochery14319443oche_ry
onery8414123one_ry
other84219103othe_r_
others93918003othe_rs
peery105719443_peery
peony105717563_peony
perry105222713_perry
phenoxy2243483phenoxy
phony136715443ph_ony
phooey14379233phooey
poetry1139383poetry
predry1237863predry
priory114110263priory
query174212083que_ry
redry94314363_redry
refry114412463_refry
retry84718083_retry
rhetor938063rhetor_
rhetors1038513rhetors
rheumy1433353rheumy
savory124310563savory
serry84824123_serry
shear85424833shear_
shears93820903shears
sheeny124912193sheeny
sheer84726893sheer_
sheerly13337703sheerly
sheers94322403sheers
shelly124414473shelly
shelty124011553shelty
shelvy15377863shelvy
sheol84318373sheo_l
sheols94614163sheols
sherd96321153she_rd
shoer84722163shoer_
shoers94518333shoers
shore85432653sh_ore
shorl84720253sh_orl
shorn85722183sh_orn
short85040533sh_ort
shorty124313203sh_orty
showy145714013sh_owy
skerry13356103skerry
smeary114110803smeary
sneery93610413sneery
sphery14318883sphe_ry
story86723033_story
tabor75518393tabor_
tabors84517113tabors
tarry85422513t_arry
tawdry13395253tawdry
tear45242883t_ear_
tears55436463t_ears
techy135612013t_echy
teddy10489493t_eddy
teensy9478273teensy
teeny85417883t_eeny
telly84920823t_elly
tenor53620253tenor_
tenors63217753tenors
tenty86121603t_enty
tepoy10312163t_epoy
term66233153t_e_rm
tern46134803t_e_rn
terra54419663t_erra
testy85419063t_esty
tetra53417953t_etra
tetri52716453t_etri
tetryl935693t_etryl
thairm1156963thairm
tharm105916643th_arm
the67436053the___
thearchy1943443thearchy
theatre10358493theatre
thebe107515433the_be
thebes115914493thebes
theca103311453the_ca
thecae11299653thecae
thecal113310303thecal
thee78039063the__e
theft114118133the_ft
thefts12387923thefts
thegn95810903the_gn
thegnly1442613thegnly
thegns10547433thegns
thein85919023the_in
theine94814923theine
theins95015423theins
theism1139483theism
theist9314763theist
them97427043the__m
theme105921733the_me
themed125912583themed
themes115319253themes
then78429693the__n
thenal92712423thenal
thenar92610003thenar
thenars10248523thenars
thence112010843thence
thens85921833the_ns
theocracy1952893theocracy
theocrat1346353theocrat
theodicy1742773theodicy
theogony1543463theogony
theolog1146153theolog
theology1536893theology
theonomy1644543theonomy
theorbos1343643theorbos
theorems1344693theorems
theories11311593theories
theorise1137873theorise
theorist1149553theorist
theorize2047073theorize
therapy1536613therapy
thereby1534633thereby
theres96525473theres
therme115814993therme
therms115914873therms
theroid11313403theroid
these86519013the_se
theses96517973theses
thesis94913733thesis
thesp105410313the_sp
thesps11448263thesps
theta83414573the_ta
thetas93011573thetas
thetic11412893thetic
thew108226233the__w
thews117416193the_ws
thievery1742563thievery
thinly1238673thinly
thio77225413thio__
thiol87616043thio_l
thiols95112763thiols
thionyl1343713thionyl
thir76420543th_ir_
third95912493th_ird
thirl85416823th_irl
thirty12378403thirty
tho67433963th_o__
thole85620843th_ole
thong95014183th_ong
thorax1638253th_orax
thoria93012893th_oria
thoric114314043th_oric
thorns95314103th_orns
thoron94713903th_oron
thorpe113610093th_orpe
thorps113610893th_orps
those85218143th_ose
thou76722213th_o_u
thous86017263th_ous
thready14435903thready
threnody1543323threnody
thro77726423th__ro
throat94819753throat
throaty13428483throaty
throb109816853thro_b
throbs118311373throbs
throe89321423thro_e
throes97518673throes
throne98517603throne
throng10539973throng
throve128012393throve
throw118719733thro_w
thrown1214911443thrown
throws129715233throws
thru76818943th__ru
thurl84912683th_url
thusly1235133thusly
thwart12311683thwart
thy97022913th___y
thymey17426313thymey
thymy16437923th_ymy
tier44936143tie_r_
tiers55526523tie_rs
toby96322293t__oby
tody86327213t__ody
tony75635153t__ony
tor39261683t__or_
tora47545993t__ora
torc66333353t__orc
tore47359323t__ore
tori47542153t__ori
torn46044253t__orn
toro48045683t__oro
torr45630903t__orr
tors46157383t__ors
tort46967463t__ort
towery124012093towery
towy105325473t__owy
toy69655193t__o_y
treaty94414353treaty
trebly1138973trebly
tremor84210393tremor_
tremors93711223tremors
trendy10469603trendy
tressy9448553tressy
trey77228793tre__y
troy77429683t_ro_y
try66529673t___ry
tumor71110693tumor_
tumors8810613tumors
tushery1335633tushe_ry
tutor5712493tutor_
tutors6912333tutors
tweaky1634023tweaky
tweedy13455933tweedy
tweeny12477003tweeny
twenty1236223twenty
twerp10398413twe_rp
tyer75323393tye_r_
tyers86220053tye_rs
vapory14398763vapory
veery115816253_veery
very108025643_ve_ry
weary115620613_weary
wheezy24244523wheezy
whelky19314973whelky
where117019423whe_re
whey135018713whe__y
wheyey1834323wheyey
whirry15477063whirry
whore116018043wh_ore
whorl114612453wh_orl
whort114623693wh_ort

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.1231452772.4
2DLD Change Limit1127163665.18621734.7
3Display Results3663660.1103327.3
 (SQL Overall)1786913665.41932974.9
 
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.