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

443 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
therme11581499(None) 
theme105921731the_me
there87527391ther_e
therm106018021therm_
thermae125310491thermae
thermel12569891thermel
thermes126214611thermes
therms115914871therms
berme96022942_berme
heme95034412_he_me
here76447102_her_e
herm95636152_herm_
herma105318882_herma
hermae115314472_hermae
herms105626432_herms
rheme106214052rhe_me
terce75721842t_erce
term66233152t_erm_
termed94816702t_ermed
termer85717252t_ermer
terms75523472t_erms
terne56426152t_erne
terse55026822t_erse
tharm105916642tharm_
tharms115712242tharms
thebe107515432the_be
thecae11299652thecae
thee78039062the__e
theine94814922theine
them97427042the_m_
themed125912582the_med
themes115319252the_mes
thence112010842thence
theorem1236262theorem
theres96525472theres
thermal125010962thermal
thermels13607762thermels
thermic1439322thermic
thermit12312002thermit
thermite1339032thermite
thermos124610752thermos
these86519012the_se
thorpe113610092thorpe
three87526912th_ree
throe89321422th_roe
thyme134612472th_yme
thyrse1235132thyrse
tierce8339842tierce
where117019422wher_e
wherve15568112wherve
adhere10310333adher_e
aerie54634603_aerie
ahem97225363ahe_m_
ahorse9311513ahorse
amerce10310513amerce
atheroma1354873atheroma
averse95811183averse
berime105317333_berime
berm86732753_berm_
bermed115217723_bermed
bermes106023003_bermes
berms95323663_berms
bireme10310143bireme
cere66741473_cer_e
cermet10321153_cermet
chare105231983char_e
charge125114213charge
charm126124663charm_
charmed154714243charmed
charmer144913663charmer
charms135218833charms
cheese113812763cheese
chegoe1237273chegoe
chelae113614603chelae
chemo12313633che_mo
cheque2036663cheque
cherry144810763cherry
chert105232103cher_t
cherts115617233cherts
cherty144612473cherty
cherub1337263cherub
chevre14318313chevre
chime125322593ch_ime
chirm125317063chirm_
chirmed15379733chirmed
chirms135113983chirms
chirre114111853chirre
chore105126763chor_e
chrome133214813chrome
chyme156512503ch_yme
cleome1039083cleome
coerce10310403coerce
cohere112716993coher_e
creme94319323cre_me
deme76536283_de_me
dere56845903_der_e
derm76031893_derm_
derma84918513_derma
derms85022893_derms
dharma1276103dharma
eerie55228533_eerie
eme55837183__e_me
emerge91510463emerge
ere36352773__er_e
erne46727423__erne
eterne6311723eterne
ethene93312923ethe_ne
ether84518773ether__
etheric12311783etheric
etherize2049463etherize
ethers94518413ether_s
faerie93514683faerie
feme96130543_fe_me
femme125011433_femme
fere76342233_fer_e
fermi103914163_fermi
fierce11348913fierce
forme105225993_forme
frere85617723frer_e
germ75428963_germ_
germen9612313_germen
germs85118873_germs
germy115113663_germy
ghee85726113ghe__e
gherao1036753gherao
hame97043133_h_ame
hare76255733_har_e
harem104924453_harem
harm95637793_harm_
harmed125218833_harmed
harmer114719553_harmer
harms106829013_harms
hearse94114273_hearse
heaume1137543_heaume
heave114521813_heave
hebe96424703_he_be
hedge105317333_hedge
heeze175313483_heeze
helm95530023_helm_
helmed124513693_helmed
helmet113718933_helmet
helms105619463_helms
helve115018093_helve
hem86148733_he_m_
hemes105031083_he_mes
hemmed144211463_hemmed
hemmer134112643_hemmer
hemp115725623_he_mp
hems95534943_he_ms
hence104920043_hence
henge94819823_henge
her66547813_her__
herb94730963_her_b
herbed123513453_herbed
herbs105520503_herbs
herby134715313_herby
herd84933063_her_d
herded114215643_herded
herder104516463_herder
herdmen13238453_herdmen
herds96424683_herds
heres86245903_heres
herl75834553_her_l
herls85226433_herls
hermai118912843_hermai
hermit11519443_hermit
hern76134893_her_n
herns84825583_herns
hero74635783_her_o
heroes94923823_heroes
heron85025503_heron
heros84930863_heros
herpes115517323_herpes
herry114922473_herry
hers75844873_her_s
hertz174919033_hertz
hire75538963_hir_e
hiree85427803_hiree
home98042443_h_ome
horde94623053_horde
horse86132653_horse
inhere9313713inher_e
ither84617603ither__
kermes124616123_kermes
kerne94718213_kerne
lierne638023lierne
meme85330553_me_me
merde84320123_merde
mere67244443_mer_e
merge84523683_merge
merle75824373_merle
mermen10813813_mermen
nerve86617373_nerve
neume74414403_neume
other84219103other__
others93918003other_s
overmen12311803overmen
peerie83617893peerie
pere66450263_per_e
perm85834633_perm_
permed115217343_permed
perms95524513_perms
perse75429523_perse
pierce104010393pierce
rhemes115913183rhe_mes
rheum1038843rheum_
rheums1135463rheums
rheumy1433353rheumy
rhyme13479553rh_yme
scheme1379633sche_me
seme65836653_se_me
sere46153473_ser_e
serge64727463_serge
serve85425963_serve
shame105726703sh_ame
share86437083shar_e
sheave124514003sheave
sheeve123412843sheeve
shelve124012763shelve
sherbet12311383sherbet
sherd96321153sher_d
sherds105614723sherds
shereef1337743shereef
sherif122915233sherif
sherpa1138093sherpa
sherry124510413sherry
shire84727133shir_e
shore85432643shor_e
sperm93216013sperm_
sperms102512603sperms
sphere113313653spher_e
stere55328543ster_e
swerve1256293swerve
tame66343663t__ame
tare45957623t_ar_e
targe65227093t_arge
tarre55825633t_arre
taxeme1536253taxeme
team66238653t_eam_
teamed95418593t_eamed
teams75726513t_eams
tease55428713t_ease
tee38366873t_e__e
teem66132603t_eem_
teemed95114873t_eemed
teemer85515743t_eemer
teems76019783t_eems
teepee8314363teepee
teethe94511313teethe
tegmen988403t_egmen
telae54323293t_elae
tele45040873t_e_le
telome8311923telome
temp85323333t_e_mp
tenge65720433t_enge
tense55225843t_ense
tepee74724213t_epee
terai53525483t_erai
tercel83612993t_ercel
terces83921413t_erces
tercet83624913t_ercet
terete6319333t_erete
terga63315643t_erga
termers95414503t_ermers
termite9313893t_ermite
termly1138433t_ermly
termor84412513t_ermor
tern46134803t_er_n
ternes65422903t_ernes
terns55226873t_erns
terra54419653t_erra
terrae62915203terrae
terret63425623t_erret
terry84721873t_erry
terser67317823t_erser
thae76825563th__ae
thairm1156963thairm_
thairms1244453thairms
thane86122533th_ane
the67436053th___e
theater104014253theater
theatre10358493theatre
thebes115914493thebes
theca103311453the_ca
thecal113310303thecal
thecate123210023thecate
theft114118133the_ft
thefts12387923thefts
thegn95810903the_gn
thegns10547433thegns
thein85919023the_in
theines104013233theines
theins95015423theins
their85512153the_ir
theirs94610353theirs
theism1139483theism
theisms1237763theisms
theist9314763theist
then78429693the__n
thenage11107833thenage
thenal92712413thenal
thenar9269993thenar
thens85921833the_ns
theorbo1243743theorbo
theorems1344693theorems
theories11311593theories
theorise1137873theorise
theorize2047063theorize
theory121098353theory
therapy1536613therapy
thereat104315243thereat
thereby1534633thereby
therein102310353therein
theremin13107273theremin
thereof13168063thereof
thereon10199263thereon
thereto1038993thereto
theriac1239143theriac
therian10311293therian
thermals13518513thermals
thermion1345933thermion
thermites1438043thermites
thermits1338493thermits
thermoses1447973thermoses
thermoset1449093thermoset
theroid11313393theroid
theses96517973theses
thesis94913733thesis
thesp105410313the_sp
thesps11448263thesps
theta83414573the_ta
thetas93011573thetas
thetic11412883thetic
theurgy1442733theurgy
thew108226233the__w
thewier1336063thewier
thews117416193the_ws
thewy146311853the_wy
they107223753the__y
thieve1235963thieve
thine85026853th_ine
thir76420543thir__
thiram1139943thiram
thirams1236803thirams
third95912493thir_d
thirds10438603thirds
thirl85416823thir_l
thirled11328093thirled
thirls95012063thirls
thirst9312253thirst
thirty12378403thirty
thole85620843th_ole
thorax1638253thorax
thoria93012883thoria
thoric114314033thoric
thorite10313443thorite
thorn85318703thor_n
thorned11479403thorned
thorns95314093thorns
thorny12509843thorny
thoro86217873thor_o
thoron94713903thoron
thorp104414263thor_p
thorpes125010353thorpes
thorps113610893thorps
those85218143th_ose
thrave126010273thrave
thraw1110515923th_raw
thread105011093thread
threap11569663threap
threat95020463threat
threep115910113threep
threes97117323threes
thresh12276863thresh
threw1117315713th_rew
thrice114311573thrice
thrip103012183th_rip
thrive125313223thrive
thro77726423th_r_o
throb109816853th_rob
throes97518673th_roes
throne98517603throne
throve128012393throve
throw118719733th_row
thru76818943th_r_u
thrum104713633th_rum
thrums11429123thrums
thumb124511283th_umb
thump126211573th_ump
thurl84912683thur_l
thurls9418713thurls
thymes144810743th_ymes
thymey17426313th_ymey
thymi13418623th_ymi
thymy16437923th_ymy
thyrses1335013thyrses
thyrsi1234453thyrsi
tier44936143tier__
tierced10347053tierced
tiercel9316203tiercel
tierces93710453tierces
tiered73613973tiered
tiers55526523tier_s
time66235013t__ime
tire46143353t_ir_e
titre54619393titr_e
tome67543193t__ome
toneme8312103toneme
tore47359323t_or_e
torse55833333t_orse
torte55431703t_orte
treble8311663treble
tree47745813t__ree
trireme935263trireme
true46725853t__rue
tsetse664693tsetse
tuyere9408613tuyer_e
twee76827083twe__e
tweeze18265473tweeze
twelve1234163twelve
twerp10398413twer_p
twerps11345153twerps
tyee75131423tye__e
tyer75323393tyer__
tyers86220053tyer_s
tyre75428253t_yr_e
tzetze1432733tzetze
verge93419833_verge
vermes115019143_vermes
verse84723583_verse
verve115417723_verve
were76238333_wer_e
wharve15456203wharve
whee105429593whe__e
wheeze21276813wheeze
whelm134611983whelm_
whelmed16375153whelmed
whelms14377573whelms
whence14187923whence
wheres125917433wheres
wherry15477333wherry
wherves16548053wherves
whore116018043whor_e

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.1401276364.3
2DLD Change Limit1127164436.33017806.6
3Display Results4434430.1403164.3
 (SQL Overall)1786914436.61027033.4
 
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.