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

189 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
esterification199533(None) 
esterifications20134811esterifications
desertification2154123des_ertification
gentrification2065633gent_rification
nitrification1877063nit_rification
petrification2048813pet_rification
scarification2056403_scarification
specification2245763_specification
sterilization2258863_sterilization
verification201810643__verification
vitrification2166463vit_rification
acetification2046724_acetification
beatification20138074beat__ification
caprification2256054_caprification
certification2048604__certification
citification1949154cit__ification
clarification2045764_clarification
decertification2364324decertification
deification17411664__de_ification
denitrification21183874denitrification
detoxification2754414detoxification
devitrification24133504devitrification
diversification24102784diversification
edification1749354___edification
electrification2263414electrification
emulsification2193444emulsification
eternization2158674e_ter_nization
exteriorization3173074exteriorization
extermination2275744exter_mination
extrication2049794ext_r__ication
gentrifications2175044gent_rifications
glorification1984894_glorification
intensification2092764intensification
justification2546094just__ification
latensification2071924latensification
lithification21105164lit_hification
mystification2346194myst__ification
nitrifications1986634nit_rifications
notification1749064not__ification
ossification17116544os__sification
petrifications2148024pet_rifications
prettification21115714prettification
purification1948174__purification
ratification17810664rat__ification
recertification2263984recertification
rectification2049514rect__ification
reification16412904__re_ification
scarifications2155764_scarifications
signification1986284_signification
specifications2345354_specifications
sterilizations2357984_sterilizations
stratification1954674_stratification
stultification1963904_stultification
typification2244864__typification
verifications21159974__verifications
versification21157494__versification
vitrifications2275964vit_rifications
westernisation17152574wester_nisation
westernization26134484wester_nization
acetifications2146055_acetifications
acidification2154885_acidification
altercation1347015alter___cation
ammonification2353045ammonification
amplification2275185_amplification
basification19127325__basification
beatifications21157465beat__ifications
beautification21144885beautification
calcification1945825_calcification
caprifications2385565_caprifications
centrifugation2061715cent_rifugation
certifications2147795__certifications
citifications2048545cit__ifications
clarifications2155265_clarifications
classification21113215classification
coalification2046135_coalification
codification20108075__codification
cornification2046695_cornification
dandification2045905_dandification
deacidification2472695deacidification
decalcification2262805decalcification
deifications18410655__de_ifications
demystification26102695demystification
denazification29154435denazification
densification1947335_densification
destabilization2763335destabilization
deterioration14145285deteri_oration
determination1657645deter_mination
detoxifications2884255detoxifications
edifications1848695___edifications
emulsifications2283135emulsifications
energization2256495e_ner_gization
eradication14410115___eradication
estimation12410845est____imation
estivation1349815est____ivation
eternizations2258075e_ter_nizations
etherization2457685ether__ization
eutrophication2161925eutrophication
exemplification3161595exemplification
exercitation2155385e_xer_citation
exterminations2365125exter_minations
externalisation2272765externalisation
externalization3164525externalization
extrications2149055ext_r__ications
falsification2145245_falsification
fortification2196925_fortification
fructification2483675fructification
gasification1867105__gasification
glorifications2074585_glorifications
gratification1946685_gratification
humidification2552905humidification
humification2246105__humification
identification2054995identification
indemnification2372005indemnification
interanimation16136015interanimation
interdiction1568145inter_dic_tion
interdigitation1763145interdigitation
interiorization2464785interiorization
intervisitation1862855intervisitation
jollification25134845_jollification
justifications2645555just__ifications
lateralization2367465lateralization
laterization21410685later__ization
lignification19125705_lignification
literalization2397425literalization
lithifications22134795lit_hifications
luteinization2255305lute_inization
magnification2145765_magnification
materialization2675215materialization
metrication15410655met_r__ication
modification20107205__modification
mollification20135555_mollification
mortification2087295_mortification
mummification2154315_mummification
mystifications2445645myst__ifications
nazification2646045__nazification
nidification1847455__nidification
notifications1848235not__ifications
nullification1854695_nullification
objectification3181875objectification
ossifications18176145os__sifications
pacification2168055__pacification
personification2272385personification
petrifaction1953725pet_rifac_tion
pontification2089015_pontification
prettifications22135185prettifications
preunification2154305preunification
purifications2047465__purifications
qualification2745035_qualification
quantification28124935quantification
ramification1998215__ramification
ratifications1899785rat__ifications
recodification22125665recodification
rectifications2148915rect__ifications
refortification2373375refortification
reifications17411825__re_ifications
restriction1349365rest_r__ic_tion
reunification18147455_reunification
revivification2564225revivification
rigidification2173145rigidification
sanctification2154705sanctification
saponification21103535saponification
securitization2554315securitization
serialization22911725_s_erialization
seriation9318065_s_er__i_ation
significations20125675_significations
silicification2153165silicification
simplification2353385simplification
solidification2053555solidification
stabilization2466195_stabilization
sternutation1253965_ster_nutation
stratifications2054235_stratifications
striation9313485_st_r__i_ation
striction1148985_st_r__ic_tion
stridulation1354775_st_ridulation
strobilation1454055_st_robilation
stultifications2083535_stultifications
termination131311165__ter_mination
trifurcation1753275__t_rifurcation
triplication1695385__t_riplication
typifications2344635__typifications
uglification1845495__uglification
unification1648735___unification
versifications22166915__versifications
vilification2077125__vilification
vinification2068235__vinification
vivification2366345__vivification
westernisations18172435wester_nisations
westernizations27154135wester_nizations
zombification3154065_zombification

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 Filter178691950240.360496363.9
2DLD Change Limit950241896.71614148.9
3Display Results1891890.1431321.7
 (SQL Overall)1786911897.21924752.9
 
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.