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

154 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
mentation1131398(None) 
dentation10315241dentation
mentations12312581mentations
cementation1559702cementation
denotation11311082denotation
dentations11413632dentations
dentition1049632dentition
emendation1346552emendation
enation73419232_en_ation
fetation11613142fe_tation
fomentation1647712fomentation
gestation10310662gestation
lamentation13106572lamentation
mediation12312292mediation
meditation13410742meditation
mention9314372men__tion
mutation101412882m_utation
peltation11312962peltation
restation9316912restation
sensation9510582sensation
venation11513502ven_ation
adnation9310783adn_ation
aeration8319933ae_ration
agitation10311223agitation
agnation9311723agn_ation
alimentation14105333alimentation
amputation1447343amputation
annotation1047753annotation
assentation1146183assentation
augmentation1554393augmentation
betatron1045233be_tatron
cementations1659013cementations
centurion1165883centurion
cessation1176853cessation
citation10314363_citation
conation101420883con_ation
connation11314263connation
contagion1246993contagion
crenation11412923cren_ation
cunctation1476913cunctation
dealation10313003dealation
decantation1448943decantation
deflation13310653deflation
delation92318083de_lation
denegation1249413denegation
denotations1239853denotations
dentitions1148853dentitions
denudation1247303denudation
deputation1339393deputation
deviation13312393deviation
dictation12810563dictation
donation91513783don_ation
dotation91412733_dotation
elation73620453_e_lation
emanation11910783emanation
emendations1446053emendations
emulation11312393emulation
enations83316903_en_ations
equation17310483_equation
fellation1238843fellation
fenthion1444613fent_hion
fermentation1756823fermentation
fetations12511383fe_tations
flotation1267813flotation
fomentations1746793fomentations
gelation93014433ge_lation
gemmation1445963gemmation
generation11312423generation
gestations1139773gestations
gustation1047963gustation
guttation1046173guttation
hebetation1557093hebetation
herniation1348443herniation
hesitation1349633hesitation
imitation11510853imitation
imputation1447123imputation
indentation1248373indentation
jactation1838143jactation
lactation11310813lactation
lamentations1495983lamentations
legation92412933le_gation
lenition8310083len_ition
levitation1349443levitation
lineation9310763lineation
lunation8311923lun_ation
mediations13310983mediations
medication15411173medication
meditations1449333meditations
megaton10269853me_gat_on
menadione1243783men_adione
menazon1846053men_a_zon
menstruation1455223menstruation
mensuration1346493mensuration
mentalism13511643mentalism
mentalist11515553mentalist
mentality1449133mentality
mentions10312893men__tions
metazoon1944053me_tazoon
migration12179703migration
molestation1365963molestation
monition10311723mon_ition
munition1038763mun_ition
mutations111211453m_utations
natation81513933_natation
nation64322803__n_ation
negation92913023ne_gation
nervation12610243nervation
nictation1189273nictation
notation81414603_notation
nunnation9126563nunnation
nutation81513103_nutation
orientation1147573orientation
ostentation1146963ostentation
peltations12311553peltations
penetration1349893penetration
pentagon1146323penta_gon
pentathlon1552393pentathlon
petition10711753pe_tition
pigmentation1754483pigmentation
pinnation1138013pinnation
plantation1248533plantation
potation101716783_potation
punctation1486053punctation
quotation18146973quotation
recantation1349863recantation
recitation12315943recitation
reflation12412333reflation
refutation1349913refutation
relation82619773re_lation
rendition1058933rendition
renovation1358783renovation
reputation12411883reputation
restations10315843restations
rotation81615453_rotation
saltation9312003saltation
sanitation10412043sanitation
sedation9312453se_dation
segmentation1556003segmentation
sensations1059853sensations
seriation9318063seriation
serration9414073serration
siltation939213siltation
sinuation9310413sinuation
station72717243__station
temptation1446383temptation
tentative1247813tentative
vegetation1448213vegetation
venations12311723ven_ations
vendition1345693vendition
veneration13412343veneration
ventilation1448163ventilation
vernation12311083vernation
vexation1838783ve_xation
zonation171410723zon_ation

Search took 9 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.423422437.4
2DLD Change Limit1486411547.58019609.6
3Display Results1541540.0762026.3
 (SQL Overall)1786911548.07922118.0
 
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.