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 “hierarchically” 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
hierarchically276221(None) 
hierarchical2262212hierarchica_l_
hieratically2048173hiera__tically
anarchically2254164__anarchically
digraphically2564274digra_phically
heraldically2154934h_era_ldically
hierarchal1852084hierarch__a_l_
hierarchic2052944hierarchic____
monarchically2553544_monarchically
seraphically2256534_sera_phically
archaically2145825____archaically
arctically17410375____arctically
biographically2764415biogra_phically
didactically2154415di_da_ctically
edaphically2254935__eda_phically
epigraphically2763275epigra_phically
erratically16410125__er_ratically
farcically2046325___farc_ically
graphically2256225__gra_phically
hectically2049605h_e___ctically
herbicidally2351655h_erbic_idally
heretically19410685h_e__retically
hermetically2248385h_er_metically
heroically18410625h_e__r_oically
hierarchies1973525hierarchi___es
hierarchize28202205hierarchi___ze
hierarchized30151875hierarchi__zed
hierarchizes29152165hierarchi__zes
hierarchizing3161255hierarchi_zing
hierarchy2052735hierarch_____y
historically2056465histor__ically
horrifically2363355h_or_rifically
hydraulically25132045hydra_ulically
hyperbarically2962085hyperbar__ically
hypercritically3062035hypercritically
impractically2454365impra_ctically
mineralogically2372375mineralogically
nonhierarchical2511985nonhierarchica_l_
operatically1949325opera__tically
piratically18411215pi_ra__tically
practically20410445__pra_ctically
terrifically2053685_ter_rifically
thoracically2285445thora_c_ically

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.343520965.0
2DLD Change Limit95024435.81316346.8
3Display Results43430.0162687.5
 (SQL Overall)178691436.17228951.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.