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

110 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
sensations105985(None) 
sensation9510581sensation_
cessations1256472cessations
dentations11413632dentations
enations83316902_en_ations
mentations12312582mentations
sedations10311252se_dations
sensating1039252sensati_ng
sensational1146382sensational
seriations10316682seriations
serrations10313102serrations
sinuations1039412sinuations
venations12311722ven_ations
adnations1039753adn_ations
aerations9317903ae_rations
agnations10310033agn_ations
assentations1245833assentations
cassations1276873cassations
causations1268143causations
cessation1176853cessation_
conations111318903con_ations
connations12312943connations
crenations12511693cren_ations
dealations11311373dealations
deflations1439713deflations
delations102616593de_lations
denegations1348543denegations
denotations1239853denotations
dentation10315243dentation_
dentitions1148853dentitions
denudations1346343denudations
deviations14311163deviations
dispensations1655483dispensations
donations101112353don_ations
elations83719123_e_lations
emendations1446053emendations
enation73419233_en_ation_
equations1839493_equations
fellations1338063fellations
fetations12511383fe_tations
gelations102513093ge_lations
gemmations1545003gemmations
generations12311423generations
gestations1139773gestations
herniations1447403herniations
legations102711923le_gations
lenitions939473len_itions
lineations1039543lineations
lunations9310723lun_ations
mediations13310983mediations
mensurations1445713mensurations
mentation11313983mentation_
mentions10312893men__tions
nations74720563__n_ations
negations102811963ne_gations
nervations1359483nervations
nunnations1095903nunnations
ostentations1246123ostentations
peltations12311553peltations
pensions10311693pens__ions
pinnations1236883pinnations
pulsations1236373pulsations
reflations13311233reflations
relations92418333re_lations
renditions1149183renditions
renovations1448423renovations
restations10315843restations
saltations10310623saltations
salvations1338133salvations
sanctions1138873san_ctions
sanitations11410843sanitations
satiations10312113satiations
scalations1239783scalations
secretions12117853secretions
sections102714703se__ctions
sedation9312453se_dation_
seditions1039013se_ditions
seductions1366873seductions
selections12310873selections
senators8312953sen_at_ors
sensates8511143sensat__es
sensitises1047643sensitises
sensitives1346133sensitives
sensitizes1946963sensitizes
separations1369273separations
seriation9318063seriation_
serration9414073serration_
sessions839723se_s_sions
siltations1038553siltations
sinuation9310413sinuation_
situations1038433situations
solations9814623s_olations
solvations1336833solvations
sonications1349953sonications
speciations1548483speciations
stations82415223s__tations
striations10312793striations
sublations12410113sublations
substations1348243substations
sudations1039903s_udations
sulcations1289583sulcations
sulfations13107813sulfations
summations1456783summations
tensions8310223tens__ions
venation11513503ven_ation_
venditions1445523venditions
venerations14411313venerations
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 Limit1406031106.32622226.2
3Display Results1101100.0631746.0
 (SQL Overall)1786911106.79526297.4
 
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.