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

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

43 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
gastronomically236227(None) 
astronomically2163901_astronomically
gastronomical1862442gastronomica_l_
agronomically2184703_a_gronomically
astrologically2055433_astrologically
astronomical1654123_astronomica_l_
autonomically2054893_aut_onomically
metronomically2354553_metronomically
acronymically2553544_a_cronymically
astronautically2092644_astronautically
gastronomic1653584gastronomic____
taxonomically2753154ta__xonomically
aeronomical1555335_a_eronomica_l_
antidromically2262665_antidromically
astrological1547025_astrologica_l_
astronomic1445605_astronomic____
astrophysically2882815_astrophysically
atomically1749875_a_t___omically
cationically1956845ca_tion__ically
diastrophically2672735diastro_phically
economically2156805___economically
ergonomically2153995__ergonomically
estrogenically2093245_estrogenically
gastronomies1553695gastronomi___es
gastronomist1563375gastronomi___st
gastronomists1662695gastronomi__sts
gastronomy1652935gastronom_____y
geostrophically2672555geostro_phically
geotropically2154925geotr__opically
histologically2364315hist_ologically
histrionically2262525histr_ionically
iatrogenically20103445ia_trogenically
macrocosmically2592095ma_crocosmically
metronomical1854165_metronomica_l_
nonastronomical1971135nonastronomica_l_
paranoically1956555pa__rano_ically
pathologically2585555pa_thologically
patriotically2057015pa_tr_iotically
petrologically2256065_petrologically
pronominally1954165___pronominally
seriocomically2373105__seriocomically
serologically1957125__serologically
tautologically2094175taut_ologically

Search took 6 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 Filter178691658740.326548131.9
2DLD Change Limit65874435.01613132.8
3Display Results43430.0331303.0
 (SQL Overall)178691435.37533244.8
 
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.