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

88 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
denegations134854(None) 
delegations1348031delegations
denegation1249411denegation_
abnegations1444922abnegations
deaerations12311672deaerations
defecations1779002defecations
delegation1238882delegation_
denervations1657092denervations
denigrations1447352denigrations
denotations1239852denotations
dentations11413632den_tations
denudations1346342denudations
derogations1349392derogations
generations12311422generations
negations102811962__negations
relegations1248972relegations
venerations14411312venerations
abnegation1345413abnegation_
allegations1246043allegations
annexations1844263annexations
benefactions1952693benefactions
crenelations1446183crenelations
deaeration11313013deaeration_
dealations11311373de_alations
deceptions1547863dece_ptions
decimations16410163decimations
decorations14312883decorations
dedications15310873dedications
defamations1745893defamations
defecation1679803defecation_
defections161510203defe_ctions
deflations1439713de_flations
degenerations1546353degenerations
dejections20168353deje_ctions
delations102616593d__elations
delectations1547453delectations
delegating1337673delegati_ng
delegators1245633delegat_ors
deletions102610933dele__tions
delineations1346763deline_ations
denervation1567943denervation_
denigration1348463denigration_
denotation11311083denotation_
dentation10315243den_tation_
dentitions1148853den_titions
denudation1247303denudation_
depilations14310903depilations
deprecations1748563deprecations
depredations1646733depredations
deputations1448343deputations
deregulations1545203deregulations
derivations15611493derivations
derogation12410393derogation_
desecrations1559213desecrations
desertions1139883dese_rtions
designations1456943designations
desolations12310593desolations
desperations1559523desperations
detections131410043dete_ctions
detentions11148803dete_ntions
detestations1347583detestations
detonations1239373detonations
deuterations1348083deuterations
deviations14311163de_viations
divagations16103833divagations
donations101112353don__ations
elevations1338633_elevations
enations83316903_en__ations
enervations1478573_enervations
federations1548883federations
generation11312423generation_
hebetations1656463hebetations
legations102711923__legations
levigations1546213levigations
lineations1039543line_ations
mentations12312583men_tations
negation92913023__negation_
negatons9299273__negat_ons
negatrons10275843__negatrons
penetrations1448853penetrations
relegation11610023relegation_
renovations1448423renovations
revelations14410303revelations
segregations1445803segregations
sensations1059853sen_sations
vegetations1547323vegetations
venations12311723ven__ations
veneration13412343veneration_

Search took 6 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 Limit121633884.81325271.8
3Display Results88880.0461913.0
 (SQL Overall)178691885.24934042.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.