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

113 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
sensation951058(None) 
sensations1059851sensations
cessation1176852cessation
dentation10315242dentation
enation73419232_en_ation
mentation11313982mentation
sedation9312452se_dation
sensating1039252sensating
sensational1146382sensational
seriation9318062seriation
serration9414062serration
sinuation9310412sinuation
venation11513502ven_ation
adnation9310783adn_ation
aeration8319933ae_ration
agnation9311723agn_ation
assentation1146183assentation
cassation1197913cassation
causation1199523causation
cessations1256473cessations
conation101420883con_ation
connation11314263connation
crenation11412923cren_ation
dealation10313003dealation
deflation13310653deflation
delation92318083de_lation
denegation1249413denegation
denotation11311083denotation
dentations11413633dentations
dentition1049633dentition
denudation1247303denudation
deviation13312393deviation
dispensation1555603dispensation
donation91513783don_ation
elation73620453_e_lation
emendation1346553emendation
enations83316903_en_ations
equation17310483_equation
fellation1238843fellation
fetation11613143fe_tation
gelation93014433ge_lation
gemmation1445963gemmation
generation11312423generation
gestation10310663gestation
herniation1348443herniation
legation92412933le_gation
lenition8310083len_ition
lineation9310763lineation
lunation8311923lun_ation
mediation12312293mediation
mensuration1346493mensuration
mentations12312583mentations
mention9314373men__tion
nation64322803__n_ation
negation92913023ne_gation
nervation12610243nervation
nunnation9126563nunnation
ostentation1146963ostentation
peltation11312963peltation
pension9412203pens__ion
pinnation1138013pinnation
pulsation1137143pulsation
reflation12412333reflation
relation82619773re_lation
rendition1058933rendition
renovation1358783renovation
restation9316913restation
saltation9312003saltation
salvation1239293salvation
sanction1049533san_ction
sanitation10412043sanitation
satiation9313433satiation
scalation11311073scalation
secretion11118303secretion
section92515663se__ction
sedations10311253se_dations
sedition939333se_dition
seduction1266983seduction
selection11311273selection
senator7313073sen_at_or
sensate7311893sensat__e
sensated938193sensat_ed
sensately1244283sensately
sensates8511143sensat_es
sensitise947293sensitise
sensitive1246963sensitive
sensitize1846563sensitize
separation12510433separation
seriations10316683seriations
serrations10313093serrations
session739763se_s_sion
siltation939213siltation
sinuations1039413sinuations
situation949423situation
solation8916153s_olation
solvation1237773solvation
sonication12411183sonication
speciation1449393speciation
station72717243s__tation
striation9313483striation
sublation11311013sublation
substation1248993substation
sudation9310803s_udation
sulcation11710733sulcation
sulfation1288783sulfation
summation1347803summation
tension7311803tens__ion
venations12311723ven_ations
vendition1345693vendition
veneration13412343veneration
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.420425454.8
2DLD Change Limit1486411136.67322275.0
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.13925030.3
 
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.