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

173 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
esterifications20134811esterifications_
esterification1995332esterification__
gentrifications2175044gent_rifications_
nitrifications1986634nit_rifications_
petrifications2148024pet_rifications_
scarifications2155764_scarifications_
specifications2345354_specifications_
sterilizations2357984_sterilizations_
verifications21159974__verifications_
vitrifications2275964vit_rifications_
acetifications2146055_acetifications_
beatifications21157465beat__ifications_
caprifications2385565_caprifications_
certifications2147795__certifications_
citifications2048545cit__ifications_
clarifications2155265_clarifications_
deifications18410655__de_ifications_
desertification2154125des_ertification__
detoxifications2884255detoxifications_
edifications1848695___edifications_
emulsifications2283135emulsifications_
eternizations2258075e_ter_nizations_
exterminations2365125exter_minations_
extrications2149055ext_r__ications_
gentrification2065635gent_rification__
glorifications2074585_glorifications_
justifications2645555just__ifications_
lithifications22134795lit_hifications_
mystifications2445645myst__ifications_
nitrification1877065nit_rification__
notifications1848235not__ifications_
ossifications18176145os__sifications_
petrification2048815pet_rification__
prettifications22135185prettifications_
purifications2047465__purifications_
ratifications1899785rat__ifications_
rectifications2148915rect__ifications_
reifications17411825__re_ifications_
scarification2056405_scarification__
significations20125675_significations_
specification2245765_specification__
sterilization2258865_sterilization__
stratifications2054235_stratifications_
stultifications2083535_stultifications_
typifications2344635__typifications_
verification201810645__verification__
versifications22166915__versifications_
vitrification2166465vit_rification__
westernisations18172435wester_nisations_
westernizations27154135wester_nizations_
acetification2046726_acetification__
acidifications2254636_acidifications_
altercations1446376alter___cations_
ammonifications2453046ammonifications_
amplifications2384756_amplifications_
basifications20137066__basifications_
beatification20138076beat__ification__
beautifications22154686beautifications_
calcifications2045416_calcifications_
caprification2256056_caprification__
centrifugations2161486cent_rifugations_
certification2048606__certification__
citification1949156cit__ification__
clarification2045766_clarification__
classifications2283086classifications_
coalifications2155706_coalifications_
codifications21127626__codifications_
cornifications2145956_cornifications_
dandifications2145436_dandifications_
decertification2364326decertification__
deification17411666__de_ification__
denazifications30164086denazifications_
denitrification21183876denitrification__
densifications2046986_densifications_
deteriorations15164696deteri_orations_
determinations1766896deter_minations_
detoxification2754416detoxification__
devitrification24133506devitrification__
diversification24102786diversification__
edification1749356___edification__
electrification2263416electrification__
emulsification2193446emulsification__
energizations2356186e_ner_gizations_
eradications1549306___eradications_
estimations1349946est____imations_
estivations1449276est____ivations_
eternization2158676e_ter_nization__
etherizations2557236ether__izations_
eutrophications2261716eutrophications_
exercitations2254566e_xer_citations_
exteriorization3173076exteriorization__
extermination2275746exter_mination__
extrication2049796ext_r__ication__
falsifications2244976_falsifications_
fortifications2286216_fortifications_
fructifications25113356fructifications_
gasifications19116846__gasifications_
glorification1984896_glorification__
gratifications2045986_gratifications_
humidifications2652816humidifications_
humifications2345856__humifications_
identifications2154496identifications_
intensification2092766intensification__
interanimations17115196interanimations_
interdictions1667496inter_dic_tions_
jollifications26144596_jollifications_
justification2546096just__ification__
latensification2071926latensification__
lateralizations2487006lateralizations_
laterizations22410076later__izations_
lignifications20135116_lignifications_
literalizations2476996literalizations_
lithification21105166lit_hification__
luteinizations2355066lute_inizations_
magnifications2245116_magnifications_
metrications1649836met_r__ications_
modifications21106986__modifications_
mollifications21145206_mollifications_
mortifications2186506_mortifications_
mummifications2254016_mummifications_
mystification2346196myst__ification__
nazifications2745526__nazifications_
nidifications1946946__nidifications_
notification1749066not__ification__
nullifications1954306_nullifications_
ossification17116546os__sification__
pacifications2267356__pacifications_
petrifactions2083566pet_rifac_tions_
pontifications2187926_pontifications_
prettification21115716prettification__
purification1948176__purification__
qualifications2844586_qualifications_
quantifications29114406quantifications_
ramifications2087536__ramifications_
ratification17810666rat__ification__
recertification2263986recertification__
recodifications23165456recodifications_
rectification2049516rect__ification__
reification16412906__re_ification__
restrictions1449286rest_r__ic_tions_
reunifications19136916_reunifications_
revivifications2694056revivifications_
rigidifications2282886rigidifications_
sanctifications2254136sanctifications_
saponifications22133326saponifications_
securitizations2654176securitizations_
serializations23710936_s_erializations_
seriations10316686_s_er__i_ations_
signification1986286_signification__
silicifications2253076silicifications_
simplifications2463196simplifications_
solidifications2153576solidifications_
stabilizations2565606_stabilizations_
sternutations1353756_ster_nutations_
stratification1954676_stratification__
striations10312796_st_r__i_ations_
strictions1249146_st_r__ic_tions_
stridulations1454406_st_ridulations_
strobilations1553886_st_robilations_
stultification1963906_stultification__
terminations14149766__ter_minations_
trifurcations1852866__t_rifurcations_
triplications1795076__t_riplications_
typification2244866__typification__
uglifications1945196__uglifications_
unifications1748046___unifications_
versification21157496__versification__
vilifications2166746__vilifications_
vinifications2177696__vinifications_
vivifications2486126__vivifications_
westernisation17152576wester_nisation__
westernization26134486wester_nization__
zombifications3263766_zombifications_

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.310576422.6
2DLD Change Limit658741735.06313010.9
3Display Results1731730.1401235.7
 (SQL Overall)1786911735.51332412.7
 
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.