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

60 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
actively164706(None) 
active11313742active__
actives12311522active_s
activity1647582activity
amatively1745082amatively
datively1545672datively
fictively2044602fictively
inactively1845312inactively
natively1446412natively
reactively1845882reactively
tactilely1443432tactilely
votively1744192votively
ablatively1844433ablatively
abortively1844343abortively
abusively1743483abusively
achingly1736613achingly
acidly125211793ac_i_dly
acridly13396533acri_dly
actinal9312293actinal_
actinally1448233actinally
activate13510373activate
activism15117083activism
activist13109483activist
activize2246613activize
actorly1246413act_orly
actually1366853actually
acutely1246123ac_utely
adaptively1953053adaptively
additively1853433additively
adjectively2753633adjectively
adoptively1953323adoptively
affectively2553973affectively
affinely1743863affinely
agilely1135123a_gilely
alpinely1344343alpinely
anticly12410053anti_cly
antiquely2144223antiquely
artily92814713arti__ly
astutely1153643astutely
cicely1338833_c_icely
costively1746353costively
ductilely1543563ductilely
electively1846383electively
emotively1744403emotively
entirely1147333entirely
facilely1644363fac_ilely
factitively2252853factitively
festively1845773festively
furtively1844843furtively
futilely1444083futilely
lively123310813__lively
massively1744153massively
naively1335903_naively
passively1744613passively
restively1548313restively
timely113410113__timely
unitively1586173unitively
unlively1445753unlively
untimely1346903untimely
vocatively2144463vocatively

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 Filter1786911461620.406440125.6
2DLD Change Limit146162606.78021557.8
3Display Results60600.0163750.0
 (SQL Overall)178691607.20224811.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.