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

97 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
venerations1441131(None) 
generations12311421generations
veneration13412341veneration_
deaerations12311672deaerations
denegations1348542denegations
denervations1657092denervations
enervations1478572_enervations
federations1548882federations
generation11312422generation_
penetrations1448852penetrations
vegetations1547322vegetations
venations12311722ven__ations
venerating14410052venerati_ng
venerators1347062venerat_ors
abnegations1444923abnegations
aerations9317903__aerations
alterations11511663alterations
annexations1844263annexations
benefactions1952693benefactions
celebrations1645743celebrations
cerebrations1646963cerebrations
cogenerations1655913cogenerations
crenelations1446183crenelations
deaeration11313013deaeration_
decorations14312883decorations
defecations1779003defecations
degenerations1546353degenerations
delegations1348033delegations
denegation1249413denegation_
denervation1567943denervation_
denigrations1447353denigrations
denotations1239853denotations
dentations11413633den_tations
denudations1346343denudations
desecrations1559213desecrations
desertions1139883deser_tions
desperations1559523desperations
deuterations1348083deuterations
elevations1338633_elevations
enations83316903_en__ations
enervation1369473_enervation_
enumerations14135513_enumerations
execrations2048923_execrations
exenterations2054483exenterations
exertions1639763_exer_tions
exonerations1947013exonerations
federation1449573federation_
fenestrations1695403fenestrations
generating12310383generati_ng
generational1354823generational
generators1147533generat_ors
hebetations1656463hebetations
innervations1546923innervations
intenerations1347463intenerations
iterations10413823_iterations
itinerations1245683itinerations
lacerations1348333lacerations
liberations1358943liberations
lineations1039543line_ations
literations11610583literations
macerations1548473macerations
mensurations1445713mensurations
mentations12312583men_tations
moderations1448273moderations
negations102811963__negations
nervations1359483__nervations
numerations13127293numerations
operations12312953_operations
penetration1349893penetration_
perorations13314063perorations
recreations13412253recreations
regenerations1447143regenerations
reiterations12410873reiterations
relegations1248973relegations
remunerations1556203remunerations
renovations1448423renovations
reoperations14410063reoperations
reparations13611663reparations
reservations1588583reservations
revelations14410303revelations
sensations1059853sen_sations
separations1369273separations
serrations10313093se_rrations
tolerations1158133tolerations
ulcerations1346363ulcerations
vegetation1448213vegetation_
venation11513503ven__ation_
venditions1445523ven_ditions
venenating1446013venenati_ng
venerates12312263venerat__es
venerator1247263venerat_o_r
venesections1752933venesections
venetians1244673vene__tians
ventilations1547403ventilations
vernations13310333ve_rnations
vexations1937753v__exations
vibrations15157373v_ibrations

Search took 5 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.390458182.1
2DLD Change Limit121633974.40627606.2
3Display Results97970.0462108.7
 (SQL Overall)178691974.84236904.4
 
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.