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

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

136 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
deacidification2472691deacidification_
acidification2154883__acidification_
acidifications2254633__acidifications
dandification2045904d_a_ndification_
dandifications2145434d_a_ndifications
decalcification2262804decalcification_
recodification22125664re_codification_
recodifications23165454re_codifications
acetification2046725__acetification_
acetifications2146055__acetifications
beatification20138075bea__tification_
beatifications21157465bea__tifications
beautification21144885bea_utification_
beautifications22154685bea_utifications
citification1949155___citification_
citifications2048545___citifications
codification20108075___codification_
codifications21127625___codifications
decertification2364325decertification_
deification17411665de____ification_
deifications18410655de____ifications
demystification26102695demystification_
denazification29154435de_nazification_
denazifications30164085de_nazifications
denitrification21183875denitrification_
densification1947335de__nsification_
densifications2046985de__nsifications
desertification2154125desertification_
detoxification2754415de_toxification_
detoxifications2884255de_toxifications
devitrification24133505devitrification_
edification1749355_e___dification_
edifications1848695_e___difications
humidification2552905_humidification_
humidifications2652815_humidifications
nidification1847455___nidification_
nidifications1946945___nidifications
pacification2168055_pac__ification_
pacifications2267355_pac__ifications
rectification2049515re_c_tification_
rectifications2148915re_c_tifications
revivification2564225re_vivification_
revivifications2694055re_vivifications
rigidification2173145_rigidification_
rigidifications2282885_rigidifications
solidification2053555_solidification_
solidifications2153575_solidifications
amplification2275186__amplification_
amplifications2384756__amplifications
basification19127326_ba__sification_
basifications20137066_ba__sifications
calcification1945826_ca_lcification_
calcifications2045416_ca_lcifications
caprification2256056_ca_prification_
caprifications2385566_ca_prifications
certification2048606ce__rtification_
certifications2147796ce__rtifications
clarification2045766cla__rification_
clarifications2155266cla__rifications
classification21113216cla_ssification_
classifications2283086cla_ssifications
coalification2046136coa__lification_
coalifications2155706coa__lifications
commodification2791876commodification_
deacidifying2351896deacidif___yi_ng
deactivation18156086deac___tivation_
deactivations19175066deac___tivations
decimalization2857886de_cimalization_
decimalizations2957586de_cimalizations
decortication1857536de_c_ortication_
decortications1966786de_c_ortications
dedication14311966de___d__ication_
dedications15310876de___d__ications
diversification24102786diversification_
electrification2263416electrification_
emulsification2193446_emulsification_
emulsifications2283136_emulsifications
esterification1995336_esterification_
esterifications20134816_esterifications
falsification2145246_fa_lsification_
falsifications2244976_fa_lsifications
frenchification2872026frenc_hification_
fructification2483676fruc_tification_
fructifications25113356fruc_tifications
gasification1867106_ga__sification_
gasifications19116846_ga__sifications
gentrification2065636ge_ntrification_
gentrifications2175046ge_ntrifications
gratification1946686gra__tification_
gratifications2045986gra__tifications
identification2054996ide__ntification_
identifications2154496ide__ntifications
magnification2145766_ma_gnification_
magnifications2245116_ma_gnifications
modification20107206___modification_
modifications21106986___modifications
nazification2646046_na__zification_
nazifications2745526_na__zifications
personification2272386personification_
petrification2048816pe__trification_
petrifications2148026pe__trifications
premodification2582976premodification_
qualification2745036qua__lification_
qualifications2844586qua__lifications
quantification28124936qua_ntification_
quantifications29114406qua_ntifications
ramification1998216_ra__mification_
ramifications2087536_ra__mifications
ratification17810666_ra__tification_
ratifications1899786_ra__tifications
recertification2263986recertification_
refortification2373376refortification_
reification16412906re____ification_
reifications17411826re____ifications
reunification18147456re__unification_
reunifications19136916re__unifications
sanctification2154706_sanctification_
sanctifications2254136_sanctifications
saponification21103536_saponification_
saponifications22133326_saponifications
scarification2056406__scarification_
scarifications2155766__scarifications
silicification2153166_silicification_
silicifications2253076_silicifications
specification2245766spec__ification_
specifications2345356spec__ifications
verification201810646ve___rification_
verifications21159976ve___rifications
versification21157496ve__rsification_
versifications22166916ve__rsifications
vilification2077126___vilification_
vilifications2166746___vilifications
vinification2068236___vinification_
vinifications2177696___vinifications
vivification2366346___vivification_
vivifications2486126___vivifications

Search took 6 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.330541487.9
2DLD Change Limit658741365.12312858.5
3Display Results1361360.203670.0
 (SQL Overall)1786911365.65631593.2
 
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.