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

82 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
annually114583(None) 
actually1366852actually
anally9513502a_n_ally
animally1368642animally
annual64710702annua_l_
annuals7388192annua_ls
annularly1243612annularly
anodally1246292anodally
biannually1552302biannually
manually1347042manually
aborally1347063aborally
aerially11911913aerially
amorally1348093amorally
angularly1344163angularly
annal56520763ann_a_l_
annals66415923ann_a_ls
anneal64812293annea_l_
annealed936343annealed
annealer845503annealer
anneals7449943annea_ls
annualize1845613annualize
annuity1045543annu_ity
annul55813383annu__l_
annular737693annu_lar
annulate8310923annulate
annulet7311593annu_let
annuli6459053annu__li
annulled944843annulled
annuls64711733annu__ls
annulus7426613annu_lus
anomaly1238843anoma_ly
antically14315683antically
apically1539833apically
areally10411243a_really
arguably1444503arguably
asexually1943773asexually
astrally1148883astrally
atonally1148633atonally
aurally10310543a_urally
awfully1644003awfu_lly
axially1737233a_xially
banally1249223ban_ally
carnally1339513carn_ally
casually1356823casually
dentally121110063dentally
dually103210063__dually
equally1936873_equally
factually1744663factually
faunally1445433faun_ally
finally13310103fin_ally
genially12129523genially
lineally1137793lineally
lingually1344373lingually
manfully1645653manfu_lly
manically16311703manically
menially131111093menially
mentally131010403mentally
mutually1345203mutually
nasally1057443_nasally
naturally1246523naturally
navally1366473_navally
neurally1137933_neurally
nodally1137913_nodally
nounally1146483_nounally
panically16310433panically
penally121111773pen_ally
ritually1167483ritually
sensually1245313sensually
sexually1845603sexually
squally1937673_squally
tactually1445003tactually
tarnally1138273tarn_ally
tonally10311373ton_ally
uncially1339073uncially
unequally2144183unequally
unreally1148233unreally
unusually1243333unusually
usually1066063_usually
venally13119563ven_ally
venially1499423venially
visually1465493visually
zonally1938003zon_ally

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.420425454.8
2DLD Change Limit146162826.95321021.4
3Display Results82820.0332484.8
 (SQL Overall)178691827.40624127.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.