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

100 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
veneration1341234(None) 
generation11312421generation
venerations14411311venerations
deaeration11313012deaeration
denegation1249412denegation
denervation1567942denervation
enervation1369472_enervation
federation1449572federation
generations12311422generations
penetration1349892penetration
vegetation1448212vegetation
venation11513502ven__ation
venerating14410052venerating
venerator1247262venerat_or
abnegation1345413abnegation
aeration8319933__aeration
alteration10612903alteration
annexation1744953annexation
benefaction1852823benefaction
celebration1546463celebration
cerebration1547923cerebration
cogeneration1546443cogeneration
crenelation1346853crenelation
deaerations12311673deaerations
decoration13314423decoration
defecation1679803defecation
degeneration1447283degeneration
delegation1238883delegation
denegations1348543denegations
denervations1657093denervations
denigration1348463denigration
denotation11311083denotation
dentation10315243den_tation
denudation1247303denudation
desecration14410073desecration
desertion10410203deser_tion
desperation14510113desperation
deuteration1249103deuteration
elevation1239233_elevation
enation73419233_en__ation
enervations1478573_enervations
enumeration13105913_enumeration
execration1949833_execration
exenteration1955293exenteration
exertion15310083_exer_tion
exoneration1847653exoneration
federations1548883federations
fenestration1596073fenestration
generating12310383generating
generational1354823generational
generative1458563generative
generator1067593generat_or
hebetation1557093hebetation
innervation1447443innervation
inteneration1248623inteneration
iteration9515033_iteration
itineration1156323itineration
laceration1249573laceration
liberation1269993liberation
lineation9310763line_ation
literation10511413literation
maceration1449613maceration
mensuration1346493mensuration
mentation11313983men_tation
moderation1348653moderation
negation92913023__negation
nervation12610243__nervation
numeration12137963numeration
operation11314003_operation
penetrations1448853penetrations
peroration12316003peroration
recreation12413613recreation
regeneration1348193regeneration
reiteration11412163reiteration
relegation11610023relegation
remuneration1446933remuneration
renovation1358783renovation
reoperation13410903reoperation
reparation12612723reparation
reservation1489143reservation
revelation13410923revelation
sensation9510583sen_sation
separation12510433separation
serration9414073se_rration
toleration1048963toleration
ulceration1247263ulceration
vegetations1547323vegetations
venations12311723ven__ations
vendition1345693ven_dition
venenating1446013venenating
venerate11312903venerat__e
venerated1339953venerat_ed
venerates12312263venerat_es
venerators1347063venerators
venesection1652943venesection
venetian1146073vene__tian
ventilation1448163ventilation
vernation12311083ve_rnation
vexation1838783v__exation
vibration14138203v_ibration

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 Filter1786911406030.546327272.9
2DLD Change Limit1406031006.47021731.5
3Display Results1001000.0601666.7
 (SQL Overall)1786911007.07625253.1
 
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.