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

187 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
dentations1141363(None) 
denotations1239851denotations
dentation10315241dentation_
dentitions1148851dentitions
mentations12312581mentations
dealations11311372dealations
decantations1547942decantations
deflations1439712deflations
delations102616592de_lations
denegations1348542denegations
denotation11311082denotation_
dentition1049632dentition_
denudations1346342denudations
deputations1448342deputations
deviations14311162deviations
dictations1389702dictations
donations101112352don_ations
dotations101411632d_otations
enations83316902_en_ations
fetations12511382fe_tations
gestations1139772gestations
indentations1347882indentations
mentation11313982mentation_
peltations12311552peltations
restations10315842restations
sensations1059852sensations
venations12311722ven_ations
adaptations1464573adaptations
adnations1039753adn_ations
aerations9317903ae_rations
agitations11310063agitations
agnations10310033agn_ations
annotations1146883annotations
assentations1245833assentations
betatrons1145083be_tatrons
cementations1659013cementations
centurions1255513centurions
cessations1256473cessations
citations11312503_citations
conations111318903con_ations
connations12312943connations
contagions1346603contagions
crenations12511693cren_ations
cunctations1576153cunctations
damnations1337083damnations
darnations1138413darnations
deaerations12311673deaerations
dealation10313003dealation_
decantation1448943decantation_
deceptions1547863deceptions
decimations16410163decimations
decoctions1547143decoctions
decorations14312883decorations
dedications15310873dedications
deductions1467133deductions
defamations1745893defamations
defecations1779003defecations
defections161510203defections
deflation13310653deflation_
degustations1444833degustations
dejections20168353dejections
delation92318083de_lation_
delectations1547453delectations
delegations1348033delegations
deletions102610933de_letions
delineations1346763delineations
demotions1258443de_motions
denaturations1444953denaturations
denegation1249413denegation_
denervations1657093denervations
denigrations1447353denigrations
dentaliums1343743dentaliums
dentins83419223den__ti_ns
denudation1247303denudation_
depictions1546893depictions
depilations14310903depilations
depletions1355743depletions
deportations1548463deportations
deputation1339393deputation_
derivations15611493derivations
derogations1349393derogations
desertions1139883desertions
desolations12310593desolations
destains9311813desta_i_ns
destinations13412663destinations
detains83716093de_ta_i_ns
detections131410043detections
detentions11148803detentions
detestations1347583detestations
detonations1239373detonations
detractions14118273detractions
detritions1148953detritions
deuterations1348083deuterations
devastations1645823devastations
deviation13312393deviation_
devotions1356593de_votions
dictation12810563dictation_
dilatations1246413dilatations
dilations102614453d_ilations
donation91513783don_ation_
dotation91412733d_otation_
dubitations1456673dubitations
durations10311463d_urations
dynatrons1343393dyn_atrons
educations1339233educations
elations83719123_e_lations
emendations1446053emendations
enation73419233_en_ation_
equations1839493_equations
fellations1338063fellations
fenthions1544233fent_hions
fetation11613143fe_tation_
flotations1366873flotations
fomentations1746793fomentations
gelations102513093ge_lations
gemmations1545003gemmations
generations12311423generations
gestation10310663gestation_
gustations1147233gustations
guttations1145593guttations
hebetations1656463hebetations
herniations1447403herniations
hesitations1448543hesitations
ideations1039903ide__ations
imitations1259963imitations
indentation1248373indentation_
jactations1936893jactations
lactations1239423lactations
lamentations1495983lamentations
legations102711923le_gations
lenitions939473len_itions
levitations1448293levitations
lineations1039543lineations
lunations9310723lun_ations
mediations13310983mediations
meditations1449333meditations
mentions10312893men__tions
mutations111211453_mutations
natations91412493_natations
nations74720563__n_ations
negations102811963ne_gations
nervations1359483nervations
nictations1278313nictations
notations91512973_notations
nunnations1095903nunnations
nutations91411763_nutations
orientations1246913orientations
ostentations1246123ostentations
peltation11312963peltation_
penetrations1448853penetrations
pentagons1246153penta_gons
pentathlons1652323pentathlons
petitions11511083pe_titions
pinnations1236883pinnations
plantations1347473plantations
potations111615073_potations
punctations1585353punctations
quotations19146283quotations
recantations1448873recantations
recitations13314203recitations
reflations13311233reflations
refutations1448673refutations
relations92418333re_lations
renditions1149183renditions
renovations1448423renovations
reputations13410733reputations
restation9316913restation_
rotations91613843_rotations
saltations10310623saltations
sanitations11410843sanitations
sedations10311253se_dations
sensation9510583sensation_
seriations10316683seriations
serrations10313103serrations
siltations1038553siltations
sinuations1039413sinuations
stations82415223__stations
temptations1545413temptations
tentatives1345483tentatives
vegetations1547323vegetations
venation11513503ven_ation_
venditions1445523venditions
venerations14411313venerations
ventilations1547403ventilations
vernations13310333vernations
vexations1937753ve_xations
zonations18139313zon_ations

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.406440125.6
2DLD Change Limit1406031875.73324525.2
3Display Results1871870.0932010.8
 (SQL Overall)1786911876.23228673.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.