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

133 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
thermits133851(None) 
hermits12312141_hermits
thermit12312011thermit_
thermite1339031thermite
thermites1438041thermites
hermit11519442_hermit_
permits11314002_permits
termite9313892t_ermite
termites10313692t_ermites
territs72714502t_errits
theremins14106052theremins
thermals13518532thermals
thermels13607762thermels
thermes126214612therm_es
thermic1439332thermi_c
thermion1345932thermion
thermions1445332thermions
thermos124610752therm_os
therms115914872therm__s
cermets1139713_cermets
chemics16349583che_mics
chemist143615003che_mist
chemists152710323che_mists
cheroots1348193cheroots
cherries131812983cherries
cherts115617233cher__ts
chervils1644553chervils
demits94918073_de_mits
dermis94717163_dermi_s
emits75421473__e_mits
fermis114313503_fermi_s
gherkins1643993gherkins
harmins123716723_harmins
helmets12309073_helmets
hemins113417573_he_mins
henbits12177003_henbits
herdics13249523_herdics
heriots10312063_heriots
hermitic1539653_hermitic
hermitism1646143_hermitism
hermitry1644453_hermitry
herms105626433_herm__s
hernias10310773_hernias
heroics122912003_heroics
heroins103518013_heroins
herries104025073_herries
inherits11310103inher_its
intermits111212203intermits
kermis124012393_kermi_s
merits8320873_mer_its
permit10321683_permit_
reemits9611303_reemits
remits85622943_re_mits
sherbets1335213sherbets
sherifs13299683sher_ifs
sheroots1137863sheroots
sherries111812893sherries
sherris10168803sherri_s
tempts10439453t_e_mpts
terais64023513t_erai_s
terbias9310743t_erbias
tercets93512443t_ercets
tergite8311003t_ergite
tergites9310543t_ergites
termers95414503t_ermers
terming104016003t_erming
termini93410813t_ermini
terminus1037393t_erminus
termitic1249283t_ermitic
termors94712773t_ermors
terms75523473t_erm__s
terrets72913583t_errets
terries73425633t_erries
territ63421373t_errit_
tharms115712243tharm__s
theelins1137643theelins
thefts12387923the__fts
theins95015423the__ins
theirs94610353the__irs
theist9314763the__ist
theists1039153the_ists
thelitis1147513the_litis
themes115319253the_m_es
theming133610473the_ming
theories11311593theories
theorist1149553theorist
theorists1246603theorists
therapies1447723therapies
therapist1447083therapist
therapists1544403therapists
thereat104315243thereat_
therein102310353therei_n
thereinto1243923thereinto
theremin13107283theremi_n
theres96525473ther__es
thereto1038993ther_eto
therewith1843543therewith
theriac1239143ther_iac
theriacs1336543theriacs
therian10311293ther_ian
therians1138313therians
therm106018023therm___
thermae125310503therm_ae
thermal125010973therm_al
therme115814993therm__e
thermel12569893therm_el
thermidor1542693thermidor
thermidors1652473thermidors
thermistor1553183thermistor
thermistors1653093thermistors
thermoses1447973thermoses
thermosets1564963thermosets
theroid11313403theroi_d
thesis94913733the_si_s
theurgies1343353theurgies
theurgist1343163theurgist
theurgists1442253theurgists
thiamins1346633thiamins
thirsts1036243thir_sts
thirties1139723thirties
thorias102312053thor_ias
thorite10313443thor_ite
thorites11312393thor_ites
threats104311673th_reats
thrifts1335523th_rifts
thrips11299013th_r_ips
throats104612193th_roats
thrusts10226523th_rusts
thyroids1546003thyroids
traits65121983t__raits
turbits969233t_urbits
vermis114214963_vermi_s
wherries14179023wherries

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621336.46622604.7
3Display Results1331330.0632111.1
 (SQL Overall)1786911336.95225703.5
 
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.