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

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
gastronomically2362271gastronomically_
astronomically2163902_astronomically_
gastronomical1862443gastronomica_l__
agronomically2184704_a_gronomically_
astrologically2055434_astrologically_
astronomical1654124_astronomica_l__
autonomically2054894_aut_onomically_
metronomically2354554_metronomically_
acronymically2553545_a_cronymically_
astronautically2092645_astronautically_
gastronomic1653595gastronomic_____
taxonomically2753155ta__xonomically_
aeronomical1555336_a_eronomica_l__
antidromically2262666_antidromically_
astrological1547026_astrologica_l__
astronomic1445616_astronomic_____
astrophysically2882816_astrophysically_
atomically1749876_a_t___omically_
cationically1956846ca_tion__ically_
diastrophically2672736diastro_phically_
economically2156806___economically_
ergonomically2153996__ergonomically_
estrogenically2093246_estrogenically_
gastronomies1553706gastronomi____es
gastronomist1563386gastronomi____st
gastronomists1662706gastronomi___sts
gastronomy1652946gastronom_____y_
geostrophically2672556geostro_phically_
geotropically2154926geotr__opically_
histologically2364316hist_ologically_
histrionically2262526histr_ionically_
iatrogenically20103446ia_trogenically_
macrocosmically2592096ma_crocosmically_
metronomical1854166_metronomica_l__
nonastronomical1971136nonastronomica_l__
paranoically1956556pa__rano_ically_
pathologically2585556pa_thologically_
patriotically2057016pa_tr_iotically_
petrologically2256066_petrologically_
pronominally1954166___pronominally_
seriocomically2373106__seriocomically_
serologically1957126__serologically_
tautologically2094176taut_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.343520965.0
2DLD Change Limit65874435.50011977.1
3Display Results43430.0331303.0
 (SQL Overall)178691435.87630410.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.