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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
deacidification247269(None) 
acidification2154882__acidification
acidifications2254633__acidifications
dandification2045903d_a_ndification
decalcification2262803decalcification
recodification22125663re_codification
acetification2046724__acetification
beatification20138074bea__tification
beautification21144884bea_utification
citification1949154___citification
codification20108074___codification
dandifications2145434d_a_ndifications
decertification2364324decertification
deification17411664de____ification
demystification26102694demystification
denazification29154434de_nazification
denitrification21183874denitrification
densification1947334de__nsification
desertification2154124desertification
detoxification2754414de_toxification
devitrification24133504devitrification
edification1749354_e___dification
humidification2552904_humidification
nidification1847454___nidification
pacification2168054_pac__ification
recodifications23165454re_codifications
rectification2049514re_c_tification
revivification2564224re_vivification
rigidification2173144_rigidification
solidification2053554_solidification
acetifications2146055__acetifications
amplification2275185__amplification
basification19127325_ba__sification
beatifications21157465bea__tifications
beautifications22154685bea_utifications
calcification1945825_ca_lcification
caprification2256055_ca_prification
certification2048605ce__rtification
citifications2048545___citifications
clarification2045765cla__rification
classification21113215cla_ssification
coalification2046135coa__lification
codifications21127625___codifications
commodification2791875commodification
deactivation18156085deac___tivation
decimalization2857885de_cimalization
decortication1857535de_c_ortication
dedication14311965de___d__ication
deifications18410655de____ifications
denazifications30164085de_nazifications
densifications2046985de__nsifications
detoxifications2884255de_toxifications
diversification24102785diversification
edifications1848695_e___difications
electrification2263415electrification
emulsification2193445_emulsification
esterification1995335_esterification
falsification2145245_fa_lsification
frenchification2872025frenc_hification
fructification2483675fruc_tification
gasification1867105_ga__sification
gentrification2065635ge_ntrification
gratification1946685gra__tification
humidifications2652815_humidifications
identification2054995ide__ntification
magnification2145765_ma_gnification
modification20107205___modification
nazification2646045_na__zification
nidifications1946945___nidifications
pacifications2267355_pac__ifications
personification2272385personification
petrification2048815pe__trification
premodification2582975premodification
qualification2745035qua__lification
quantification28124935qua_ntification
ramification1998215_ra__mification
ratification17810665_ra__tification
recertification2263985recertification
rectifications2148915re_c_tifications
refortification2373375refortification
reification16412905re____ification
reunification18147455re__unification
revivifications2694055re_vivifications
rigidifications2282885_rigidifications
sanctification2154705_sanctification
saponification21103535_saponification
scarification2056405__scarification
silicification2153165_silicification
solidifications2153575_solidifications
specification2245765spec__ification
verification201810645ve___rification
versification21157495ve__rsification
vilification2077125___vilification
vinification2068235___vinification
vivification2366345___vivification

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.310576422.6
2DLD Change Limit65874954.14315900.1
3Display Results95950.0761250.0
 (SQL Overall)178691954.52939454.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.