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

150 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
thermae12531050(None) 
hermae115314471_hermae
thermal125010971thermal
therme115814991therm_e
herma105318882_herma_
hermai118912862_hermai
terrae62915212t_errae
thecae11299652the_cae
theme105921732the_m_e
there87527392ther__e
thereat104315242thereat
theriac1239142theriac
therian10311292therian
therm106018022therm__
thermals13518532thermals
thermel12569892thermel
thermes126214612thermes
thermic1439332thermic
thermit12312012thermit
thermite1339032thermite
thermos124610752thermos
therms115914872therm_s
atheroma1354873atheroma_
atheromas1444983atheromas
berme96022943_berm_e
chelae113614603che_lae
derma84918513_derma_
dermal93614343_dermal
dermas94116813_dermas
dharma1276103dharma_
dharmas1356513dharmas
ethereal1146783ethereal
etherize2049463etherize
feriae95618603_feriae
fermate122813003_fermate
gemmae11507793_gemmae
german9611983_german
germane1049663_germane
gherao1036753gher_ao
hemal104419803_he_mal
heme95034413_he_m_e
herbage1337003_herbage
herbal112513493_herbal
herdman13238423_herdman
here76447103_her__e
hereat93527413_hereat
herm95636153_herm__
hermaean1343603_hermaean
hermit11519443_hermit
herms105626433_herm_s
herniae1039043_herniae
hetman112510603_hetman
merman10513863_merman
overman12311463overman
rheme106214053rhe_m_e
sherpa1138093sherpa_
sherpas1238093sherpas
taeniae739083taeniae
tarmac10310333t_armac
telae54323293t_e_lae
teniae64517353t_eniae
terai53525483t_er_ai
terce75721843t_er_ce
terete6319333t_erete
terga63315643t_erga_
tergal72912833t_ergal
term66233153t_erm__
termed94816703t_ermed
termer85717253t_ermer
termite9313893t_ermite
termly1138433t_ermly
termor84412513t_ermor
terms75523473t_erm_s
ternate7415483t_ernate
terne56426153t_er_ne
terra54419663t_erra_
terrace93311843t_errace
terrane72814233t_errane
terras63516973t_erras
terse55026823t_er_se
testae64216253t_estae
thae76825563th___ae
tharm105916643tharm__
tharms115712243tharm_s
theatre10358493theatre
thebe107515433the__be
theca103311453the_ca_
thecal113310303the_cal
thecate123210023thecate
thee78039063the___e
theine94814923the_ine
them97427043the_m__
themed125912583the_med
themes115319253the_mes
thenage11107843thenage
thenal92712423the_nal
thenar92610003the_nar
thence112010843the_nce
theorise1137873theorise
theorize2047073theorize
therapy1536613therapy
thereby1534633thereby
therein102310353therein
theremin13107283theremin
thereof13168063thereof
thereon10199263thereon
theres96525473ther_es
thereto1038993thereto
theriaca1344153theriaca
theriacs1336543theriacs
therians1138313therians
thermalize2445773thermalize
thermally1744833thermally
thermels13607763thermels
thermion1345933thermion
thermites1438043thermites
thermits1338513thermits
thermoses1447973thermoses
thermoset1449093thermoset
theroid11313403theroid
these86519013the__se
theta83414573the_ta_
thetas93011573the_tas
thiram1139963thir_am
thirams1236823thirams
thirlage1243823thirlage
thorax1638253thor_ax
thoria93012893thoria_
thorias102312053thorias
thorite10313443thorite
thorpe113610093thor_pe
thrave126010273th_rave
thraw1110515923th_r_aw
thread105011093th_read
threap11569663th_reap
threat95020463th_reat
three87526913th_r_ee
thrice114311573th_rice
thrive125313223th_rive
throat94819753th_roat
throe89321423th_r_oe
throne98517603th_rone
throve128012393th_rove
thyme134612473th_ym_e
thyrse1235133thyr_se
tierce8339843tier_ce
where117019423wher__e
whereas13448903whereas
whereat134311923whereat
wherve15568113wher_ve

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271506.25021444.3
3Display Results1501500.0463260.9
 (SQL Overall)1786911506.70226662.3
 
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.