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

246 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
thermos12461075(None) 
thermes126214611thermes
therms115914871therm_s
chemos13311722che_mos
herms105626432_herm_s
heros84930862_her_os
termor84412512t_ermor
termors94712772t_ermors
terms75523472t_erm_s
tharms115712242tharm_s
themes115319252the_mes
theorbos1343642theorbos
thereof13168062thereof
thereon10199262thereon
theres96525472ther_es
therm106018022therm__
thermae125310502thermae
thermal125010972thermal
thermals13518532thermals
therme115814992therm_e
thermel12569892thermel
thermels13607762thermels
thermic1439332thermic
thermion1345932thermion
thermions1445332thermions
thermit12312012thermit
thermits1338512thermits
thermoses1447982thermoses
thermoset1449102thermoset
atheroma1354873atheroma
atheromas1444983atheromas
bermes106023003_bermes
berms95323663_berm_s
ceros74726073_cer_os
charms135218843charm_s
charros124312153charros
cheapos14418513cheapos
cheerios13317593cheerios
cheeros123711643cheeros
chemo12313633che_mo_
cheroot12413693cheroot
cheroots1348193cheroots
cherts115617233cher_ts
cherubs1434553cherubs
chirms135113983chirm_s
chiros114617773chir_os
chromos142610273chromos
churros12427583churros
demos86022993_de_mos
dermas94116823_dermas
dermis94717163_dermis
derms85022893_derm_s
dharmas1356523dharmas
eros45238453__er_os
ethers94518413ether__s
fermis114313503_fermis
germs85118873_germ_s
gherao1036753gherao_
gheraoes1244823gheraoes
ghettos1134473ghettos
harms106829023_harm_s
helios94816633_helios
hellos95321683_hellos
helms105619463_helm_s
helos84928063_he_los
hemes105031083_he_mes
hemps126917333_he_mps
hems95534943_he_m_s
herbs105520503_her_bs
herds96424683_her_ds
hereof123212373_hereof
hereon93914363_hereon
heres86245903_her_es
heriot9422343_heriot
heriots10312063_heriots
herls85226433_her_ls
herm95636153_herm__
herma105318893_herm_a
hermae115314483_hermae
hermai118912873_hermai
hermit11519443_hermit
hermits12312143_hermits
herns84825583_her_ns
hero74635783_her_o_
heroes94923833_heroes
heron85025503_her_on
herons94820543_herons
herpes115517323_herpes
hers75844873_her__s
hithermost1853593hithermost
hommos13128503_hommos
homos105921793_h_omos
kermes124616143_kermes
kermis124012403_kermis
memos95719113_me_mos
nethermost1553273nethermost
others93918003other__s
perms95524513_perm_s
pharos11312063phar_os
phenoms1437813phenoms
rhemes115913183rhe_mes
rheums1135463rheum_s
scherzos2243703scherzos
sermon8413553_sermon
sermons9311783_sermons
servos93812723_servos
shammos14307203shammos
shamos114216983sh_amos
sherds105614723sher_ds
sherifs13299683sherifs
sheroot10414373sheroot
sheroots1137863sheroots
sherpas1238093sherpas
sherris10168803sherris
spermous1247933spermous
sperms102512603sperm_s
stereos74314973stereos
taros55640823t_ar_os
teams75726513t_eam_s
teems76019783t_eem_s
telcos8710683t_elcos
telos55424523t_e_los
tempos103812293t_empos
temps95417133t_e_mps
terais64023513t_erais
terces83921413t_erces
teredos839183t_eredos
term66233153t_erm__
termed94816703t_ermed
termer85717253t_ermer
termers95414503t_ermers
termly1138433t_ermly
ternes65422903t_ernes
terns55226873t_er_ns
terras63516973t_erras
terror63811733t_error
terrors73112213t_errors
thairms1244453thairm_s
tharm105916643tharm__
thebes115914493the_bes
theelol1044283theelol
theelols1144423theelols
thefts12387923the_fts
thegns10547433the_gns
theines104013233theines
theins95015423the_ins
theirs94610353the_irs
theisms1237763theisms
theists1039153theists
them97427043the_m__
theme105921733the_m_e
themed125912583the_med
thenars10248523thenars
thens85921833the__ns
theolog1146153theolog
theologs1246153theologs
theorbo1243743theorbo_
theorems1344693theorems
theories11311593theories
therapy1536613therapy
there87527393ther__e
thereat104315243thereat
thereby1534633thereby
therefor1494453therefor
therein102310353therein
theremin13107283theremin
theremins14106053theremins
thereto1038993thereto
theriac1239143theriac
theriacs1336543theriacs
therian10311293therian
therians1138313therians
thermidor1542693thermidor
thermidors1652473thermidors
thermite1339033thermite
thermites1438043thermites
thermosets1564963thermosets
thermostat1554973thermostat
theroid11313403theroid
theropod1445433theropod
theropods1544963theropods
theses96517973the_ses
thesis94913733the_sis
thesps11448263the_sps
thetas93011573the_tas
thews117416193the__ws
thirams1236823thirams
thirds10438603thir_ds
thirls95012063thir_ls
thirsts1036243thirsts
tholos94213003th_olos
thorias102312053thorias
thorns95314103thor_ns
thoro86217873thor_o_
thoron94713903thor_on
thorons104511913thorons
thorpes125010353thorpes
thorps113610893thor_ps
thraws129211103th_raws
threads11419953threads
threaps12488643threaps
threats104311683threats
threeps12687043threeps
threes97117323th_rees
thrips11299013th_rips
thro77726423th_r_o_
throb109816853th_r_ob
throbs118311373th_robs
throe89321423th_r_oe
throes97518673th_roes
throw118719733th_r_ow
throws129715233th_rows
thrums11429123th_rums
thumbs13377443th_umbs
thumps13449353th_umps
thurls9418713thur_ls
thymes144810743th_ymes
thymol1434463th_ymol
thymols1533843th_ymols
thymus14324743th_ymus
thyrses1335023thyrses
thyrsus1342693thyrsus
tierces93710453tierces
tiers55526523tier__s
tiros54524893t_ir_os
toreros7311343toreros
toros54336193t_or_os
torsos64815733t_orsos
tremor84210403tre_mor
tremors93711233tre_mors
trios55528093t__rios
turbos8910783t_urbos
twerps11345153twer_ps
tyers86220053tyer__s
tyros85118593t_yr_os
uttermost1144323uttermost
vermes115019143_vermes
vermis114214963_vermis
versos93812803_versos
whelms14377573whelm_s
whereas13448903whereas
whereof16185473whereof
whereon13196513whereon
wheres125917443wher_es
wherves16548063wherves
zeros144918113_zer_os

Search took 8 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.406440125.6
2DLD Change Limit1340272466.89019452.4
3Display Results2462460.0803075.0
 (SQL Overall)1786912467.37624226.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.