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

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

53 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
heretically1941068(None) 
hermetically2248381hermetically
emetically17411422_emetically
erotically15414312_erotically
genetically1759202genetically
hectically2049602he_ctically
heretical1448632heretica_l_
heroically18410622her_oically
hieratically2048172hieratically
theoretically2186252theoretically
vertically18410932ver_tically
aerobically1848113aerobically
aphetically2159253aphetically
arctically17410373_arctically
ascetically1848403ascetically
cherubically2452603cherubically
cortically17411823cor_tically
critically17411273_critically
deistically1749043deistically
dietetically1856663dietetically
diuretically18155703diuretically
eidetically1768223eidetically
energetically1985263energetically
eristically16411343_eristically
erratically16410123erratically
exotically2249493_exotically
frenetically2056333frenetically
gametically1948213gametically
generically1747393generically
hedonically2046883hedonically
helically1749433h__elically
heraldically2154933heraldically
hermetical1746383hermetica_l_
heuristically2155573heuristically
irenically15710313_irenically
kinetically2047743kinetically
meiotically1849773meiotically
meristically1949013meristically
mimetically2048303mimetically
neurotically1747733neurotically
operatically1949323operatically
phonetically2249093phonetically
phyletically2555933phyletically
piratically18411213piratically
poetically17412883_poetically
theistically2067363theistically
thematically2257893thematically
thermically2146683ther_mically
thetically18410493_thetically
tonetically16410823tonetically
veridically2046083veridically
vortically1849193vor_tically
xerically2149533xer__ically

Search took 8 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 Filter1786911216330.283631417.0
2DLD Change Limit121633536.89017653.6
3Display Results53530.0331606.1
 (SQL Overall)178691537.20624797.5
 
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.