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

91 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
esthetes114774(None) 
aesthetes1246231aesthetes
estheses1137781estheses
esthete1047431esthete_
aesthete1145852aesthete_
estates74520182est_ates
esthesis1148462esthesis
esthetic13119772esthetic
esthetics14106962esthetics
ethenes103313872e_thenes
aesthetic1497843aesthetic
aesthetics1595813aesthetics
antheses11311473antheses
asthenies1278063asthenies
athletes1157883_athletes
catheter1338153catheter
catheters1437013catheters
cathexes2036273cathexes
enspheres1486083enspheres
ententes8312773ententes
enthetic131110613enthetic
enthuses1138253enthuses
entrees71813773entre_es
ephebes1436153e_phebes
epithets1345763epithet_s
escheated1546273escheated
escheats1346253escheats
eschewed1743443eschewed
eschewer1643163eschewer
eschewers1742873eschewers
eschews1534553esche_ws
estate64719763est_ate_
estated83715573est_ated
esteem838813est_e_em
esteemed1144473esteemed
esteems935243est_eems
esters64627733est_e_rs
esthesia1147503esthesia
esthesias1246733esthesias
esthesises1344813esthesises
estimates11911363estimates
estivates12109753estivates
estreated1039553estreated
estreats839423estreats
estrones8313323estrones
estruses838483estruses
ethanes103713513e_thanes
ethene93312923e_thene_
ethers94518413e_the_rs
ethoses10311763e_thoses
ethynes13377573e_thynes
etwees9348793e_twe_es
eusteles838043eust_eles
excretes1787573excretes
exegetes1655313exegetes
extremes1756053extremes
gestates93213733gest_ates
gothites1246013gothites
isotheres1246333isotheres
machetes1539633machetes
menthenes1447703menthenes
mestees94617753mest_e_es
pestholes1448233pestholes
restates83423433rest_ates
schemes1489663_schemes
secretes10410473secretes
sestets7911473sest_et_s
settees73513633sette_es
sheets93918503_s_heets
shotes95321913_s_hotes
shtetel1033943_shtetel
shtetels1143233_shtetels
shtetls1034583_shtetls
shutes93518223_s_hutes
sphenes123013163_sphenes
spheres123114353_spheres
stactes91914633_stactes
states64337083_st_ates
steeves103410903_steeves
steles63725663_st_eles
steres63929533_st_eres
stets55423913_st_et_s
streets73312613_streets
testates83615453test_ates
testees74215913test_e_es
thebes115914493__thebes
themes115319253__themes
theres96525473__theres
theses96517973__theses
thetas93011573__thetas
vestees103513173vest_e_es

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.406440125.6
2DLD Change Limit146162916.26623326.2
3Display Results91910.0303033.3
 (SQL Overall)178691916.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.