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

57 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
hydrogenations2210324(None) 
hydrogenation21103341hydrogenation_
hydrogenating2262952hydrogenati_ng
dehydrogenation2471293dehydrogenation_
halogenations1772933h_alogenations
hydrogenates20115073hydrogenat__es
hydroxylations3163123hydroxylations
dehydrogenating2571344dehydrogenati_ng
halogenation1683184h_alogenation_
hydrations1745284hydr____ations
hydrogenases20104614hydrogena__ses
hydrogenate19115054hydrogenat___e
hydrogenated21114004hydrogenat__ed
hydrogenous1953954hydrogen___ous
hydroxylation3063364hydroxylation_
hyphenations2393524hy__phenations
abrogations14116465_abrog__ations
arrogations12126485_arrog__ations
brominations1646745__brominations
cognations1339595___cog_nations
coronations13410705_coro__nations
crenations12511695__cr__enations
dehydrogenates23122015dehydrogenat__es
deoxygenations2661745deoxygenations
derogations1349395_derog__ations
dominations14611045__d_ominations
donations101112355__d_o__nations
emarginations1674155emar_ginations
halogenating1752525h_alogenati_ng
homogenisations21192635h_omogenisations
homogenizations30153955h_omogenizations
hybridizations3252095hybridizations
hydration1646075hydr____ation_
hydrocarbons2362135hydro__carbons
hydrodynamics2863015hydrodynami_cs
hydrogenase19104475hydrogena___se
hydrogens1746065hydroge_____ns
hydrometeors2162715hydrome__teors
hydrostatics2174005hydro_stati_cs
hydroxylating3163245hydroxylati_ng
hyphenation22123955hy__phenation_
hypotensions2052995hy_poten_sions
hypothecations27132575hypothecations
impregnations1853775impreg_nations
indignations1446045ind_ig_nations
lysogenizations2862625ly_sogenizations
marginations1546455_mar_ginations
miscegenations1963025miscegenations
originations13106185__originations
oxygenations2352695__oxygenations
profanations17175255__profanations
pronations12314035__pro__nations
prorogations1556715prorog__ations
protonations1449065__protonations
refrigerations1863775refrigerations
rogations101510825___rog__ations
subrogations1545455subrog__ations

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.1231452772.4
2DLD Change Limit95024576.61014375.8
3Display Results57570.0301900.0
 (SQL Overall)178691576.76326421.9
 
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.