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

163 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
thermal12501097(None) 
thermae125310501thermae
thermals13518531thermals
thermel12569891thermel
dermal93614342_dermal
ethereal1146782ethereal
hemal104419802_he_mal
herbal112513492_herbal
herma105318882_herma_
hermae115314472_hermae
hermai118912862_hermai
tergal72912832t_ergal
thecal113310302the_cal
thenal92712422the_nal
thereat104315242thereat
theriac1239142theriac
therian10311292therian
therm106018022therm__
thermally1744832thermally
therme115814992therm_e
thermels13607762thermels
thermes126214612thermes
thermic1439332thermic
thermit12312012thermit
thermos124610752thermos
therms115914872therm_s
aerial64625713_aerial
aethereal1244593aethereal
antheral1149393anther_al
atheroma1354873atheroma_
atheromas1444983atheromas
bharal1138893bhar_al
ceramal1138843_ceramal
cercal10314123_cercal
cereal8315833_cereal
chasmal14158213chasmal
chervil1534953chervil
chiral114614413chir_al
choral115118493chor_al
chordal13449883chordal
choreal124412223choreal
chorial124214143chorial
derma84918513_derma_
dermas94116813_dermas
dharma1276103dharma_
dharmas1356513dharmas
eternal72910893eternal
exothermal2273343exothermal
feral85424653_fer_al
ferial94621253_ferial
formal113215203_formal
geothermal1653013geothermal
german9611983_german
gharial1137343gharial
gherao1036753gher_ao
haemal113811643_haemal
hamal104623113_h_amal
hammal134512063_hammal
hartal9415473_hartal
heal75645693_he__al
herald10311343_her_ald
herbals122710613_herbals
herdman13238423_herdman
hereat93527413_hereat
herl75834553_her__l
herm95636153_herm__
hermit11519443_hermit
herms105626433_herm_s
hernial10310433_hernial
hetman112510603_hetman
hiemal11339503_hiemal
horal86328683_hor_al
isothermal1552763isothermal
merman10513863_merman
nonthermal1554343nonthermal
normal83213533_normal
overman12311463overman
seral56336383_ser_al
serial64625863_serial
serumal938783_serumal
serval93913413_serval
sheal84927703she__al
sherpa1138093sherpa_
sherpas1238093sherpas
spheral1238423spher_al
sternal73411913sternal
tamal73522623t__amal
tarmac10310333t_armac
tarnal63716503t_arnal
tarsal63315273t_arsal
teal45546503t_e__al
tectal83713253t_ectal
telial65815363t_elial
tepal76319583t_e_pal
terai53525483t_er_ai
tercel83612993t_ercel
terga63315643t_erga_
term66233153t_erm__
termed94816703t_ermed
termer85717253t_ermer
terminal1039733t_erminal
termly1138433t_ermly
termor84412513t_ermor
terms75523473t_erm_s
terra54419663t_erra_
terrae62915213t_errae
terras63516973t_erras
tertial7313863t_ertial
tharm105916643tharm__
tharms115712243tharm_s
theca103311453the_ca_
thecae11299653the_cae
theelol1044273theelol
them97427043the_m__
theme105921733the_m_e
themed125912583the_med
themes115319253the_mes
thenar92610003the_nar
therapy1536613therapy
there87527393ther__e
thereby1534633thereby
therein102310353therein
theremin13107283theremin
thereof13168063thereof
thereon10199263thereon
theres96525473ther_es
thereto1038993thereto
theriaca1344153theriaca
theriacal1443553theriacal
theriacs1336543theriacs
therians1138313therians
thermalize2445773thermalize
thermion1345933thermion
thermite1339033thermite
thermits1338513thermits
theroid11313403theroid
theta83414573the_ta_
thetas93011573the_tas
thetical1349123thetical
thiram1139963thir_am
thirams1236823thirams
thirl85416823thir__l
thoracal1344913thoracal
thorax1638253thor_ax
thoria93012893thoria_
thorias102312053thorias
thrall93810293th_rall
thraw1110515923th_r_aw
thread105011093th_read
threap11569663th_reap
threat95020463th_reat
thrill94910593th_rill
throat94819753th_roat
thurl84912683thur__l
thymol1434463th_ymol
tiercel9316203tiercel
trial54926353t__rial
verbal112513663_verbal
vernal93514213_vernal
versal93013753_versal
wheal115716183whe__al
whereas13448903whereas
whereat134311923whereat

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.436409841.7
2DLD Change Limit1340271637.18618651.1
3Display Results1631630.0632587.3
 (SQL Overall)1786911637.68523251.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.