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

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

138 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
accreditations1912262(None) 
accreditation18112871accreditation_
acceptations1864503acc_e_ptations
crepitations1647473__crepitations
decrepitations1984333decrepitations
reaccreditation2081183reaccreditation_
abbreviations202145024abbrevi_ations
accelerations1754184acc_elerations
accentuations1753094acc_entuations
acceptation1765324acc_e_ptation_
acclimations18146294acc__limations
accrediting1752464accredi__ti_ng
accretions1444924accre____tions
appreciations1964734appreci_ations
crepitation1548394__crepitation_
decrepitation1884804decrepitation_
meditations1449334___meditations
predications17411174__predications
premeditations1955014premeditations
recitations13314194___recitations
abbreviation191175265abbrevi_ation_
abdications1657655a___bdications
acceleration1654815acc_eleration_
accentuation1653465acc_entuation_
acclamations18164045acc__lamations
acclimation17127095acc__limation_
accommodations23202495accommodations
accreditable1951805accredita__ble
accredits1443435accredi__t___s
accretion1345935accre____tion_
acculturations18182905acculturations
accumulations19143625acc_umulations
accusations1546005acc___usations
accustomations2061725accustomations
acetifications2146055acetifications
acetylations1743545a_c_etylations
acidifications2254635acidifications
acidulations15104815a_c_idulations
activations1669265a_c__tivations
actualizations25126945actualizations
adjudications2452325a_djudications
affectations2043435a_ffe_ctations
afforestations2062225affore_stations
aggradations1552705aggrad__ations
aggregations1553845aggre__gations
agitations11310065a____gitations
alimentations1594985alime_ntations
alleviations1554495a_llevi_ations
amortizations2456465amor_tizations
anodizations2276925a__nodizations
appreciation1855285appreci_ation_
approximations2761965approximations
arbitrations1445755a__r_bitrations
ascriptions1544975ascr__i_ptions
assentations1245825a_sse_ntations
attestations1244465a_tte_stations
augmentations1654115augme_ntations
bacterizations2766655bacterizations
capacitations1953625_capacitations
capitations1549855__c_apitations
caprifications2385565caprifications
cartelizations2556545cartelizations
cauterizations25197145cauterizations
cavitations1647845__c_avitations
cementations1659005_ceme_ntations
cerebrations1646935_cere_brations
citations11312495__c___itations
claudications1852885_claudications
coeducations1745855__coeducations
cogitations1448885__c_ogitations
cohabitations2053455_cohabitations
concretizations2854025concretizations
coordinations1684975_coordinations
corotations1349735_cor__otations
creations112614535__cre___ations
cremations14410705__cre__mations
crenations12511675__cre__nations
crenelations1446185__crenelations
crenulations1446495__crenulations
creolizations2457885__creolizations
crepitating1645805__crepitati_ng
criminations1648065__criminations
curarizations2447475_curarizations
decapitations1847655dec_apitations
decrepitating1953025decrepitati_ng
dedications15310865___dedications
depreciations1846545depreci_ations
depredations1646725depred__ations
encrustations15123085encr_ustations
eradications1549295__eradications
excitations2049005exc___itations
excogitations2353815exc_ogitations
excruciations24112985excruci_ations
exercitations2254555exer_citations
facilitations1845765fac_ilitations
forestations1546305_fore_stations
gravitations1644765__gravitations
hereditarians1762665_hereditarians
hesitations1448535___hesitations
hybridizations3252095hybridizations
incardinations1754415incardinations
incitations13310875inc___itations
incriminations18105125incriminations
incrustations15134275incr_ustations
irradiations1394885_irradi_ations
irritations1147825__ir_ritations
jactitations2145015jac__titations
lacrimations1645705lacr__imations
levitations1448295___levitations
mediations13310985___medi_ations
medications1649925___medications
meditation13410745___meditation_
mercerizations2756095mercerizations
necessitations16122795necessitations
occultations1644375occ__ultations
ordinations1247975__or_dinations
overeducations2054955overeducations
overmedications2363635overmedications
predations13812145__pred__ations
predication16412435__predication_
predictions1649645__predi_ctions
prelibations16127625__prelibations
premeditation1855705premeditation_
racemizations2665465rac_emizations
radiations11311925___radi_ations
recitation12315945___recitation_
recreations13412235recre___ations
recriminations1856725recriminations
rededications1746115_rededications
refutations1448675___refutations
remediations1548275_remedi_ations
reputations13410735___reputations
reradiations1349495_reradi_ations
restations10315835___re_stations
ruggedizations2652045ruggedizations
scarifications2155765scarifications
trepidations1554935__trepidations
vaccinations1945675vacc___inations

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 Filter178691950240.1101624463.6
2DLD Change Limit950241387.78012213.9
3Display Results1381380.0961437.5
 (SQL Overall)1786911387.98622375.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.