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

175 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
sanctifications225413(None) 
sanctification2154701sanctification_
acetifications2146053_acetifications
calcifications2045413calc_ifications
dandifications2145433dan_difications
fructifications25113353fructifications
notifications1848233__notifications
pacifications2267353pa_c_ifications
pontifications2187923pon_tifications
quantifications29114403quan_tifications
ratifications1899783ra__tifications
rectifications2148913_rectifications
saponifications22133323saponifications
specifications2345353spec_ifications
stratifications2054233stratifications
stultifications2083533stultifications
acetification2046724_acetification_
acidifications2254634_acidifications
amplifications2384754_amplifications
anticipations1757494_an_ticipations
basifications20137064ba__sifications
beatifications21157464_beatifications
beautifications22154684beautifications
calcification1945824calc_ification_
caprifications2385564ca_prifications
certifications2147794_certifications
citifications2048544__citifications
dandification2045904dan_dification_
denazifications30164084denazifications
densifications2046984den_sifications
falsifications2244974fa_lsifications
fortifications2286214_fortifications
fructification2483674fructification_
gasifications19116844ga__sifications
gentrifications2175044gentrifications
gratifications2045984_gratifications
identifications2154494identifications
justifications2645554_justifications
magnifications2245114ma_gnifications
mortifications2186504_mortifications
mystifications2445644_mystifications
nazifications2745524__nazifications
nidifications1946944__nidifications
nitrifications1986634__nitrifications
notification1749064__notification_
pacification2168054pa_c_ification_
pontification2089014pon_tification_
prettifications22135184prettifications
quantification28124934quan_tification_
ramifications2087534ra__mifications
ratification17810664ra__tification_
rectification2049514_rectification_
sanitizations2248554san__itizations
saponification21103534saponification_
scarifications2155764s_carifications
significations20125674s_ignifications
silicifications2253074silicifications
simplifications2463194simplifications
solidifications2153574solidifications
specification2245764spec_ification_
stratification1954674stratification_
stultification1963904stultification_
unifications1748044_un__ifications
vinifications2177694vin__ifications
acidification2154885_acidification_
activations1669265_a_ct__ivations
ammonifications2453045ammonifications
amplification2275185_amplification_
anglicizations26123335_anglicizations
annihilations1653995_an_nihilations
anticipation1668285_an_ticipation_
antifriction1773985_an_tifric_tion_
antiquations2146245_an_ti_quations
bacterizations2766665ba_cterizations
basification19127325ba__sification_
beatification20138075_beatification_
beautification21144885beautification_
cantillations1545735can_ti_llations
caprification2256055ca_prification_
certification2048605_certification_
citification1949155__citification_
clarifications2155265_clarifications
classifications2283085classifications
coalifications2155705_coalifications
codifications21127625__codifications
conciliations1747205conc_ili_ations
cornifications2145955_cornifications
deifications18410655___deifications
denazification29154435denazification_
denitrification21183875denitrification_
densification1947335den_sification_
detoxifications2884255detoxifications
edifications1848695___edifications
electrification2263415electrification_
emulsifications2283135emulsifications
esterifications20134815esterifications
facilitations1845765fa_c_ilitations
factorizations2855765fa_ctorizations
falsification2145245fa_lsification_
fantastications2062055fantastications
fortification2196925_fortification_
frenchification2872025frenchification_
gasification1867105ga__sification_
gentrification2065635gentrification_
glorifications2074585_glorifications
gratification1946685_gratification_
humidifications2652815humidifications
humifications2345855__humifications
identification2054995identification_
inactivations1854245inact__ivations
incriminations18105135_incriminations
intimidations1686665_in_timidations
intoxications22135685_in_toxications
jactitations2145015ja_ct__itations
jollifications26144595_jollifications
justification2546095_justification_
laciniations1445915la_c_ini_ations
latinizations22159015la__tinizations
lignifications20135115_lignifications
lithifications22134795_lithifications
magnification2145765ma_gnification_
mastications1649415ma_st__ications
modifications21106985__modifications
mollifications21145205_mollifications
mortification2087295_mortification_
mummifications2254015_mummifications
mystification2346195_mystification_
nazification2646045__nazification_
nidification1847455__nidification_
nitrification1877065__nitrification_
nullifications1954305_nullifications
objectification3181875objectification_
ossifications18176145__ossifications
pacificators2153005pa_c_ificat_ors
participations2054535pa_rticipations
petrifications2148025_petrifications
pontificating2153775pon_tificati_ng
pontificators2053055pon_tificat_ors
prenotification2253605prenotification_
prettification21115715prettification_
purifications2047465__purifications
qualifications2844585_qualifications
ramification1998215ra__mification_
recodifications23165455recodifications
reifications17411825___reifications
reunifications19136915_reunifications
revivifications2694055revivifications
rigidifications2282885rigidifications
salinizations2258425sa__linizations
sanitations11410845san____itations
sanitization2149155san__itization_
satiations10312115sa__t__i_ations
satisfactions18141915sa__tisfac_tions
scarification2056405s_carification_
sensitisations1493625sen_sitisations
sensitizations23126095sen_sitizations
signification1986285s_ignification_
silicification2153165silicification_
simplification2353385simplification_
solidification2053555solidification_
sonications1349955son____ications
subtilizations2556065s_ubtilizations
syndications18104475syn___dications
typifications2344635__typifications
uglifications1945195__uglifications
unification1648735_un__ification_
vaticinations1845035va__ticinations
verifications21159975__verifications
versifications22166915_versifications
victimizations3064285_victimizations
vilifications2166745__vilifications
vinification2068235vin__ification_
vitrifications2275965_vitrifications
vivifications2486125__vivifications
zombifications3263765_zombifications

Search took 5 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 Filter178691658740.326548131.9
2DLD Change Limit658741753.89016934.2
3Display Results1751750.1401250.0
 (SQL Overall)1786911754.35641021.8
 
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.