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

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
emulsifications228313(None) 
emulsification2193441emulsification_
amplifications2384753ampl_ifications
falsifications2244973_falsifications
mollifications21145203_mollifications
mummifications2254013_mummifications
nullifications1954303_nullifications
stultifications2083533stultifications
ammonifications2453044ammonifications
amplification2275184ampl_ification_
basifications20137064__basifications
beautifications22154684beau_tifications
calcifications2045414_calcifications
classifications2283084classifications
coalifications2155704coal_ifications
densifications2046984_densifications
edifications1848694e___difications
esterifications20134814esterifications
falsification2145244_falsification_
fructifications25113354fructifications
gasifications19116844__gasifications
humidifications2652814humidifications
humifications2345854_hu_mifications
jollifications26144594_jollifications
justifications2645554_justifications
magnifications2245114_magnifications
modifications21106984_m_odifications
mollification20135554_mollification_
mortifications2186504_mortifications
multiplications2163184_multiplications
mummification2154314_mummification_
mystifications2445644_mystifications
nullification1854694_nullification_
ossifications18176144__ossifications
purifications2047464_pu_rifications
qualifications2844584_qualifications
reunifications19136914reu_nifications
simplifications2463194simpl_ifications
stultification1963904stultification_
uglifications1945194__uglifications
unifications1748044__u_nifications
versifications22166914_versifications
vilifications2166744_vil_ifications
acetifications2146055_acetifications
acidifications2254635_acidifications
ammonification2353045ammonification_
basification19127325__basification_
beatifications21157465_beatifications
beautification21144885beau_tification_
calcification1945825_calcification_
caprifications2385565_caprifications
certifications2147795_certifications
citifications2048545__citifications
clarifications2155265_clarifications
classification21113215classification_
coalification2046135coal_ification_
codifications21127625__codifications
cornifications2145955_cornifications
dandifications2145435_dandifications
decalcification2262805decalcification_
deifications18410655___deifications
demystification26102695demystification_
denazifications30164085denazifications
densification1947335_densification_
detoxifications2884255detoxifications
edification1749355e___dification_
elicitations1446805e__l_icitations
eliminations1447615e__l_iminations
emulations12310945emul_____ations
equivocations2751845equ__ivocations
esterification1995335esterification_
exemplification3161595exempl_ification_
explications2347535expl___ications
exsiccations2343265e__xsi_ccations
fortifications2286215_fortifications
fructification2483675fructification_
gasification1867105__gasification_
gentrifications2175045gentrifications
glorifications2074585_glorifications
gratifications2045985_gratifications
humidification2552905humidification_
humification2246105_hu_mification_
identifications2154495identifications
implications1847025impl___ications
jollification25134845_jollification_
justification2546095_justification_
lignifications20135115_lignifications
lithifications22134795_lithifications
magnification2145765_magnification_
mastications1649415_m_as_tications
modification20107205_m_odification_
mortification2087295_mortification_
multiplication2063335_multiplication_
mystification2346195_mystification_
nazifications2745525__nazifications
nidifications1946945__nidifications
nitrifications1986635_nitrifications
notifications1848235__notifications
ossification17116545__ossification_
pacifications2267355__pacifications
petrifications2148025_petrifications
pontifications2187925_pontifications
prettifications22135185prettifications
purification1948175_pu_rification_
qualification2745035_qualification_
quantifications29114405quantifications
ramifications2087535__ramifications
ratifications1899785__ratifications
recodifications23165455recodifications
rectifications2148915_rectifications
reifications17411825___reifications
reunification18147455reu_nification_
revivifications2694055revivifications
rigidifications2282885rigidifications
rustications1448565_ru_s_tications
sanctifications2254135sanctifications
saponifications22133325saponifications
scarifications2155765_scarifications
significations20125675_significations
silicifications2253075silicifications
simplification2353385simpl_ification_
solidifications2153575solidifications
specifications2345355_specifications
stratifications2054235stratifications
subsidizations2653735_subsidizations
typifications2344635__typifications
uglification1845495__uglification_
umbilications1994415__umbilications
unification1648735__u_nification_
verifications21159975__verifications
versification21157495_versification_
vilification2077125_vil_ification_
vinifications2177695__vinifications
vitrifications2275965_vitrifications
vivifications2486125__vivifications
zombifications3263765_zombifications

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 Filter178691658740.563317390.8
2DLD Change Limit658741366.36010357.5
3Display Results1361360.266511.3
 (SQL Overall)1786911367.18924856.2
 
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.