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

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

48 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
dithyrambically319901dithyrambically_
dithyrambic2461235dithyrambic_____
digraphically2564276di__graphically_
dynamically2244366d___ynam_ically_
thermically2146686__ther_m_ically_
thoracically2285446__thora_cically_
tyrannically2054376__t_yrannically_
antidromically2262667antidrom_ically_
arthritically2154847arth_r_itically_
asthmatically2355647asth_ma_tically_
autocratically2164837autocra_tically_
autographically2663807autographically_
bathymetrically3062157bathymetrically_
biographically2764417bi_ographically_
cherubically2452607__cher_ubically_
democratically2454067democra_tically_
demographically2963887demographically_
diachronically2562217diachr_onically_
diastrophically2672737diastrophically_
dichotically2356227dich___otically_
didactically2154417di___dactically_
diplomatically2453457diploma_tically_
dithyramb2072067dithyramb_______
dithyrambs2171507dithyramb______s
diuretically18155707di__ur_etically_
dramatically2047617d____ramatically_
drastically1748947d____rastically_
dyadically2055317d___y_a_dically_
dynastically2155727d___ynastically_
exothermically3172407exother_m_ically_
heraldically2154937___heraldically_
hieratically2048177hi__era_tically_
hydraulically25132047___hydraulically_
ideographically27113717ideographically_
impractically2454367_i_mpractically_
lethargically2272467leth__argically_
lithologically2364067lith_ologically_
liturgically1852517lit_ur__gically_
mathematically2654657mathema_tically_
panoramically2274607_panoram_ically_
piratically18411227pi___ra_tically_
pyramidally2252487___pyram_idally_
rhythmically2862917__rhythm_ically_
theatrically2055697__th_eatrically_
thematically2257897__thema_tically_
thrasonically2153417__th_rasonically_
titanically1646577tit___a_nically_
tragically1648877__t__ra_gically_

Search took 9 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.356501941.0
2DLD Change Limit95024488.00311873.5
3Display Results48480.0301600.0
 (SQL Overall)178691488.38921300.6
 
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.