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 “acceptations” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

128 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
acceptations186450(None) 
acceptation1765321acceptation_
accentuations1753092accentuations
accelerations1754193accelerations
accentuation1653463accentuation_
acclamations18164043acclamations
acclimations18146293acclimations
accreditations19122623accreditations
accusations1546003acc_usations
adaptations1464573a_daptations
affectations2043433affectations
assentations1245843assentations
attestations1244463attestations
coaptations1547543_coaptations
crepitations1647473_crepitations
occultations1644373occultations
occupations1744543occup_ations
aberrations1346694a_berrations
abnegations1444924abne_gations
acceleration1654814acceleration_
accentuating1762834accentuati_ng
acceptances1653174accepta_nces
acceptant1545044accepta___nt
accepting1695824accep__ti_ng
acceptors15114814accep__t_ors
accessions1445254acce__ssions
acclamation17144754acclamation_
acclimation17127094acclimation_
accreditation18112874accreditation_
accretions1444924acc__retions
acculturations18182904acculturations
accumulations19143624accumulations
accusation1466904acc_usation_
accustomations2061724accustomations
acetylations1743544acetylations
acidulations15104814acidulations
activations1669264a_ctivations
actuations1239294a_c_tuations
acylations1547604a_c_ylations
adaptation1355224a_daptation_
aerations9317904a__e_rations
affectation1943844affectation_
agitations11310064a__gitations
alienations1147884alie_nations
alimentations1594994alimentations
allegations1246044alle_gations
alleviations1554504alleviations
alterations11511664alte_rations
altercations1446374altercations
alternations1246774alternations
amputations1546444a_mputations
annexations1844264anne_xations
annotations1146884a_nnotations
appellations1643534appellations
arcuations1249344arc__uations
ascertains1244264ascerta_i_ns
assentation1146194assentation_
attenuations1243804attenuations
attestation1145184attestation_
augmentations1654124augmentations
auscultations1553054auscultations
cancelations1657094cance_lations
cancellations1754394cancellations
capitations1549854_capitations
caseations1258304case__ations
catenations1348364cate_nations
cavitations1647844_cavitations
cementations1659014cementations
cessations1256474__cessations
chelations1539084_che_lations
citations11312504__c_itations
coaptation1448344_coaptation_
cogitations1448904_cogitations
computations1848124_computations
corotations1349774_corotations
creations112614544_cre__ations
cremations14410714_cre_mations
crenations12511694_cre_nations
crepitation1548394_crepitation_
cunctations1576154_cunctations
decantations1547944decantations
decapitations1847664decapitations
deceptions1547864decep__tions
decrepitations1984344decrepitations
delectations1547454delectations
dentations11413634__dentations
deputations1448344__deputations
detestations1347584detestations
dictations1389704dic__tations
exceptions2146864excep__tions
excitations2049004exc_itations
expectations2365844expectations
facilitations1845764facilitations
fetations12511384__fe_tations
fomentations1746794fomentations
forestations1546324forestations
gestations1139774__gestations
hebetations1656464hebe_tations
incantations1446644incantations
inceptions1448544incep__tions
incitations13310884inc_itations
indentations1347884indentations
infestations1546624infestations
jactations1936894jac__tations
jactitations2145014jactitations
lacerations1348334lace_rations
lactations1239424lac__tations
lamentations1495984lamentations
macerations1548474mace_rations
mentations12312584__mentations
molestations1475474molestations
nictations1278314nic__tations
occultation1545134occultation_
occupation1645184occup_ation_
orientations1246914orientations
ostentations1246134ostentations
peltations12311554__peltations
placentations17103634placentations
recantations1448874recantations
receptions1449744recep__tions
recitations13314204rec_itations
reputations13410734__reputations
restations10315844__restations
sacculations1646664sacc_ulations
temptations1545414_temptations
ulcerations1346364ulce_rations
vaccinations1945684vacc_inations
vegetations1547324vege_tations

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 Filter1786911247900.470380193.6
2DLD Change Limit1247901287.09317593.4
3Display Results1281280.0801600.0
 (SQL Overall)1786911287.64323379.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.