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

193 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
dentation1031524(None) 
denotation11311081denotation
dentations11413631dentations
dentition1049631dentition
mentation11313981mentation
dealation10313002dealation
decantation1448942decantation
deflation13310652deflation
delation92318082de_lation
denegation1249412denegation
denotations1239852denotations
dentitions1148852dentitions
denudation1247302denudation
deputation1339392deputation
deviation13312392deviation
dictation12810562dictation
donation91513782don_ation
dotation91412732d_otation
enation73419232_en_ation
fetation11613142fe_tation
gestation10310662gestation
indentation1248372indentation
mentations12312582mentations
peltation11312962peltation
restation9316912restation
sensation9510582sensation
venation11513502ven_ation
adaptation1355223adaptation
adnation9310783adn_ation
aeration8319933ae_ration
agitation10311223agitation
agnation9311723agn_ation
annotation1047753annotation
assentation1146183assentation
betatron1045233be_tatron
cementation1559703cementation
centurion1165883centurion
cessation1176853cessation
citation10314363_citation
conation101420883con_ation
connation11314263connation
contagion1246993contagion
crenation11412923cren_ation
cunctation1476913cunctation
damnation1238403damnation
darnation1039823darnation
deaeration11313013deaeration
dealations11311373dealations
decantations1547943decantations
deception1448323deception
decimation15411623decimation
decoction1447523decoction
decoration13314423decoration
dedication14311963dedication
deduction1377083deduction
defamation1646843defamation
defecation1679803defecation
defection151610643defection
deflations1439713deflations
degustation1345633degustation
dejection19178663dejection
delations102616593de_lations
delectation1448553delectation
delegation1238883delegation
deletion92011973de_letion
delineation1247763delineation
demotion1169073de_motion
denaturation1345883denaturation
denegations1348543denegations
denervation1567943denervation
denigration1348463denigration
denotative1456723denotative
dentalia947533dentali_a
dentality1348473dentality
dentalium1245333dentalium
dentate8315153dentat__e
dentated10411703dentat_ed
dentately1344953dentately
dentin73919573den__ti_n
denudations1346343denudations
depiction1437273depiction
depilation13312033depilation
depletion1256663depletion
deportation1449303deportation
deputations1448343deputations
derivation14712783derivation
derogation12410393derogation
desertion10410203desertion
desolation11311403desolation
destain8412083desta_i_n
destination12413843destination
detain74617383de_ta_i_n
detection121310413detection
detention10169543detention
detestation1248363detestation
detonation11310943detonation
detraction13138583detraction
detrition1049133detrition
deuteration1249103deuteration
devastation1546733devastation
deviations14311163deviations
devotion1256763de_votion
dictations1389703dictations
dilatation1147393dilatation
dilation92215463d_ilation
donations101112353don_ations
dotations101411633d_otations
dubitation1377333dubitation
duration9312693d_uration
dynatron1243623dyn_atron
education12310203education
elation73620453_e_lation
emendation1346553emendation
enations83316903_en_ations
equation17310483_equation
fellation1238843fellation
fenthion1444613fent_hion
fetations12511383fe_tations
flotation1267813flotation
fomentation1647713fomentation
gelation93014433ge_lation
gemmation1445963gemmation
generation11312423generation
gestations1139773gestations
gustation1047963gustation
guttation1046173guttation
hebetation1557093hebetation
herniation1348443herniation
hesitation1349633hesitation
ideation9310493ide__ation
imitation11510853imitation
indentations1347883indentations
jactation1838143jactation
lactation11310813lactation
lamentation13106573lamentation
legation92412933le_gation
lenition8310083len_ition
levitation1349443levitation
lineation9310763lineation
lunation8311923lun_ation
mediation12312293mediation
meditation13410743meditation
mention9314373men__tion
mutation101412883_mutation
natation81513933_natation
nation64322803__n_ation
negation92913023ne_gation
nervation12610243nervation
nictation1189273nictation
notation81414603_notation
nunnation9126563nunnation
nutation81513103_nutation
orientation1147573orientation
ostentation1146963ostentation
peltations12311553peltations
penetration1349893penetration
pentagon1146323penta_gon
pentathlon1552393pentathlon
petition10711753pe_tition
pinnation1138013pinnation
plantation1248533plantation
potation101716783_potation
punctation1486053punctation
quotation18146973quotation
recantation1349863recantation
recitation12315943recitation
reflation12412333reflation
refutation1349913refutation
relation82619773re_lation
rendition1058933rendition
renovation1358783renovation
reputation12411883reputation
restations10315843restations
rotation81615453_rotation
saltation9312003saltation
sanitation10412043sanitation
sedation9312453se_dation
sensations1059853sensations
seriation9318063seriation
serration9414073serration
siltation939213siltation
sinuation9310413sinuation
station72717243__station
temptation1446383temptation
tentative1247813tentative
vegetation1448213vegetation
venations12311723ven_ations
vendition1345693vendition
veneration13412343veneration
ventilation1448163ventilation
vernation12311083vernation
vexation1838783ve_xation
zonation171410723zon_ation

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411937.28320409.3
3Display Results1931930.0902144.4
 (SQL Overall)1786911937.80922882.7
 
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.