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

155 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
emulsification219344(None) 
emulsifications2283131emulsifications
amplification2275183ampl_ification
falsification2145243_falsification
mollification20135553_mollification
mummification2154313_mummification
nullification1854693_nullification
stultification1963903stultification
ammonification2353044ammonification
amplifications2384754ampl_ifications
basification19127324__basification
beautification21144884beau_tification
calcification1945824_calcification
classification21113214classification
coalification2046134coal_ification
decalcification2262804decalcification
demystification26102694demystification
densification1947334_densification
edification1749354e___dification
esterification1995334esterification
exemplification3161594exempl_ification
falsifications2244974_falsifications
fructification2483674fructification
gasification1867104__gasification
humidification2552904humidification
humification2246104_hu_mification
jollification25134844_jollification
justification2546094_justification
magnification2145764_magnification
modification20107204_m_odification
mollifications21145204_mollifications
mortification2087294_mortification
multiplication2063334_multiplication
mummifications2254014_mummifications
mystification2346194_mystification
nullifications1954304_nullifications
ossification17116544__ossification
purification1948174_pu_rification
qualification2745034_qualification
reunification18147454reu_nification
simplification2353384simpl_ification
stultifications2083534stultifications
uglification1845494__uglification
unification1648734__u_nification
versification21157494_versification
vilification2077124_vil_ification
acetification2046725_acetification
acidification2154885_acidification
ammonifications2453045ammonifications
basifications20137065__basifications
beatification20138075_beatification
beautifications22154685beau_tifications
calcifications2045415_calcifications
caprification2256055_caprification
certification2048605_certification
citification1949155__citification
clarification2045765_clarification
classifications2283085classifications
coalifications2155705coal_ifications
codification20108075__codification
commodification2791875commodification
cornification2046695_cornification
dandification2045905_dandification
deacidification2472695deacidification
decertification2364325decertification
deification17411665___deification
denazification29154435denazification
denitrification21183875denitrification
densifications2046985_densifications
desertification2154125desertification
detoxification2754415detoxification
devitrification24133505devitrification
diversification24102785diversification
edifications1848695e___difications
electrification2263415electrification
elicitation1347535e__l_icitation
elimination1348535e__l_imination
emulation11312395emul_____ation
emulsifiable1961155emulsifi_a_ble
equivocation2652065equ__ivocation
esterifications20134815esterifications
explication2248455expl___ication
exsiccation2243625e__xsi_ccation
fortification2196925_fortification
fructifications25113355fructifications
gasifications19116845__gasifications
gentrification2065635gentrification
glorification1984895_glorification
gratification1946685_gratification
humidifications2652815humidifications
humifications2345855_hu_mifications
identification2054995identification
implication1747775impl___ication
intensification2092765intensification
jollifications26144595_jollifications
justifications2645555_justifications
latensification2071925latensification
lignification19125705_lignification
lithification21105165_lithification
magnifications2245115_magnifications
mastication15610295_m_as_tication
modifications21106985_m_odifications
mortifications2186505_mortifications
multifunction2062055_multifunction
multination1348975_mul__tination
multiplications2163185_multiplications
mystifications2445645_mystifications
nazification2646045__nazification
nidification1847455__nidification
nitrification1877065_nitrification
notification1749065__notification
ossifications18176145__ossifications
pacification2168055__pacification
personification2272385personification
petrification2048815_petrification
pontification2089015_pontification
premodification2582975prem_odification
prettification21115715prettification
preunification2154305preunification
purifications2047465_pu_rifications
qualifications2844585_qualifications
quantification28124935quantification
ramification1998215__ramification
ratification17810665__ratification
recertification2263985recertification
recodification22125665recodification
rectification2049515_rectification
refortification2373375refortification
reification16412905___reification
reunifications19136915reu_nifications
revivification2564225revivification
rigidification2173145rigidification
rustication1349225_ru_s_tication
sanctification2154705sanctification
saponification21103535saponification
scarification2056405_scarification
signification1986285_signification
silicification2153165silicification
simplifications2463195simpl_ifications
solidification2053555solidification
specification2245765_specification
stratification1954675stratification
subsidization2553985_subsidization
syllabification2561545syllabification
typification2244865__typification
uglifications1945195__uglifications
umbilication1884745__umbilication
unifications1748045__u_nifications
verification201810645__verification
versifications22166915_versifications
vilifications2166745_vil_ifications
vinification2068235__vinification
vitrification2166465_vitrification
vivification2366345__vivification
zombification3154065_zombification

Search took 7 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.376475242.0
2DLD Change Limit950241556.42014801.2
3Display Results1551550.1101409.1
 (SQL Overall)1786911556.90625874.7
 
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.