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

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

62 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
aesthetically215643(None) 
anesthetically2254261anesthetically
aesthetical1655742aesthetica_l_
apathetically2356052apathetically
antithetically2264493antithetically
aphetically2159243a__phetically
arithmetically2453853arithmetically
ascetically1848393a_s_cetically
asthmatically2355613a_sthmatically
athletically2047223a__thletically
authentically2155543a_uthentically
bathetically2247353_bathetically
kinesthetically2761903kinesthetically
metathetically2454103metathetically
parenthetically2562683parenthetically
pathetically2249203_pathetically
prosthetically2454603prosthetically
synthetically2455033synthetically
thetically18410483___thetically
aesthetic1497844aesthetic____
aesthetician1763364aesthetic_ian
aestheticians1862744aestheticians
aestheticism1963104aesthetic_ism
aestheticisms2062634aestheticisms
aestheticize2662614aesthetic_ize
aestheticized2862084aestheticized
aestheticizes2762214aestheticizes
aesthetics1595814aesthetic___s
alchemically2454774a_lchemically
amitotically1946914amit_otically
arthritically2154824a_rthritically
artistically1748694a_rtistically
aseptically1847394a_s_eptically
asyndetically2283544asyndetically
atheistically2166344a__theistically
autistically1747564a_utistically
cosmetically2147914cos_metically
despotically2075884des_potically
dietetically1856654diet_etically
ecstatically1956454ecst_atically
eidetically1768224_e_idetically
emetically17411414_e__metically
empathetically2653454empathetically
emphatically2456424_emphatically
esoterically17126104_esoterically
ethically1748694_e_th__ically
ethnically1847814_e_th_nically
genetically1759194ge__netically
geochemically2654834geochemically
heretically19410664he__retically
hermetically2248374he_rmetically
hypothetically3064384hypothetically
hysterically2354894hyst_erically
jesuitically2454164jes_uitically
mesmerically2154814mes_merically
methodically2356144me_thodically
obstetrically2053054obst_etrically
prophetically2577454prophetically
spherically2146934__spherically
statically15411564__st_atically
sterically15410464__st_erically
systemically2254134syst_emically

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 Filter178691950240.1261418182.5
2DLD Change Limit95024626.45314725.6
3Display Results62620.0461347.8
 (SQL Overall)178691626.62526972.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.