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 “esthesis” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

79 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
esthesis114846(None) 
estheses1137781estheses
esthesia1147501esthesia
esthesias1246731esthesias
aesthesia1245942aesthesia
aesthesias1345692aesthesias
anthesis11312502anthesis
esthesises1344812esthesises
esthetes1147742esthetes
esthetic13119772esthetic
esthetics14106962esthetics
thesis94913732__thesis
aesthetes1246233aesthetes
aesthetic1497843aesthetic
aesthetics1595813aesthetics
anesthesia1354433anesthesia
anesthesias1454033anesthesias
antheses11311473antheses
aphesis12610513_aphesis
ascesis938373as_cesis
askesis1136123as_kesis
asthenia1167723asthenia
asthenias1277463asthenias
asthenic1378633asthenic
asthenics1486413asthenics
asthenies1278073asthenies
cathexis2045753cathexis
centesis1058143cent_esis
diathesis1345533diathesis
ecesis84611203e__cesis
ectasis9249613ect_asis
eisegesis1042023eisegesis
emesis84712623e__mesis
emphasis15117673emphasis
entasis73012573ent_asis
enthetic131110613enthetic
enthuses1138253enthuses
enuresis845493enuresis
epenthesis1593773epenthesis
escheats1346253escheats
eschews1534553esche_ws
esteems935243est_eems
esters64627733est_e_rs
esthete1047433esthe_te
estreats839423estreats
estruses838483estruses
ethenes103313873e_thenes
etheric12311783e_theric
etherish1448273e_therish
ethers94518413e_the_rs
ethoses10311763e_thoses
euthenics1466283euthenics
euthenist1249033euthenist
exegesis1643643exegesis
kinesthesis1852283kinesthesis
mestesos1045223mest_esos
metathesis1544153metathesis
orthosis1148203orthosis
osteosis846743osteosis
ostosis71310123ost_osis
phthisis1654443phthisis
prosthesis1546153prosthesis
prothesis1449433prothesis
restless82713163restles_s
restress82511773restres_s
resynthesis1753043resynthesis
stasis63116873_st_asis
sthenia1058503_sthenia
sthenias1178163_sthenias
sthenic1268903_sthenic
stress66616673_stres_s
stypsis1245243_stypsis
synesis1039163_synesis
synthesis1546053synthesis
theses96517973__theses
thesps11448263__thesps
tmesis8529793__tmesis
vestless11258843vestles_s
zestless17247433zestles_s

Search took 10 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.673265514.1
2DLD Change Limit146162798.86016496.8
3Display Results79790.0302633.3
 (SQL Overall)178691799.56318685.7
 
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.