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 “denotation” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
denotation1131108(None) 
denotations1239851denotations
dentation10315241den_tation
annotation1047752annotation
decoration13314422decoration
denegation1249412denegation
denotative1456722denotative
dentations11413632den_tations
dentition1049632den_tition
denudation1247302denudation
deportation1449302deportation
deputation1339392deputation
derogation12410392derogation
desolation11311402desolation
detonation11310942detonation
dotation91412732d__otation
mentation11313982men_tation
notation81414602__notation
renovation1358782renovation
annotations1146883annotations
connotation1347983connotation
corotation12410973corotation
cunctation1476913cunctation
deaeration11313013deaeration
dealation10313003de_alation
decantation1448943decantation
decimation15411623decimation
decoction1447523deco_ction
decollation1448193decollation
decorations14312883decorations
dedication14311963dedication
defamation1646843defamation
defecation1679803defecation
deflation13310653de_flation
defloration1547263defloration
defoliation1548313defoliation
deformation1747663deformation
degustation1345633degustation
delation92318083de__lation
delectation1448553delectation
delegation1238883delegation
demolition1376983demolition
demotion1169073demo__tion
denaturation1345883denaturation
denegations1348543denegations
denervation1567943denervation
denigration1348463denigration
denomination15118833denomination
dentitions1148853den_titions
denudations1346343denudations
depilation13312033depilation
deportations1548463deportations
deposition13107833deposition
deputations1448343deputations
derivation14712783derivation
derogations1349393derogations
desolations12310593desolations
desorption1346223desorption
detestation1248363detestation
detonations1239373detonations
devastation1546733devastation
deviation13312393de_viation
devolution1486283devolution
devotion1256763devo__tion
dictation12810563d_ictation
dilatation1147393dilatation
donation91513783d__onation
dotations101411633d__otations
dubitation1377333dubitation
enation73419233_en__ation
evocation142010293_evocation
fetation11613143fe__tation
flotation1267813_flotation
generation11312433generation
gestation10310663ge_station
hebetation1557093hebetation
hesitation1349633hesitation
indentation1248373inden_tation
innovation1345643innovation
levitation1349443levitation
meditation13410743meditation
mentations12312583men_tations
natation81513933__natation
negotiation1245773negotiation
notations91512973__notations
novation111710013__novation
nutation81513103__nutation
peltation11312963pe_ltation
penetration1349893penetration
peroration12316003peroration
potation101716783__potation
punctation1486053punctation
quotation18146973_quotation
recitation12315943recitation
refutation1349913refutation
relocation12312113relocation
renovations1448423renovations
reputation12411883reputation
restation9316913re_station
revocation15410813revocation
rotation81615453__rotation
sanitation10412043sanitation
sensation9510583sen_sation
temptation1446383temptation
vegetation1448213vegetation
venation11513503ven__ation
veneration13412343veneration

Search took 7 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.420425454.8
2DLD Change Limit1406031076.00023433.8
3Display Results1071070.0502140.0
 (SQL Overall)1786911076.47027618.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.