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

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
emulsifications2283131emulsifications_
emulsification2193442emulsification__
amplifications2384754ampl_ifications_
falsifications2244974_falsifications_
mollifications21145204_mollifications_
mummifications2254014_mummifications_
nullifications1954304_nullifications_
stultifications2083534stultifications_
ammonifications2453045ammonifications_
amplification2275185ampl_ification__
basifications20137065__basifications_
beautifications22154685beau_tifications_
calcifications2045415_calcifications_
classifications2283085classifications_
coalifications2155705coal_ifications_
densifications2046985_densifications_
edifications1848695e___difications_
esterifications20134815esterifications_
falsification2145245_falsification__
fructifications25113355fructifications_
gasifications19116845__gasifications_
humidifications2652815humidifications_
humifications2345855_hu_mifications_
jollifications26144595_jollifications_
justifications2645555_justifications_
magnifications2245115_magnifications_
modifications21106985_m_odifications_
mollification20135555_mollification__
mortifications2186505_mortifications_
multiplications2163185_multiplications_
mummification2154315_mummification__
mystifications2445645_mystifications_
nullification1854695_nullification__
ossifications18176145__ossifications_
purifications2047465_pu_rifications_
qualifications2844585_qualifications_
reunifications19136915reu_nifications_
simplifications2463195simpl_ifications_
stultification1963905stultification__
uglifications1945195__uglifications_
unifications1748045__u_nifications_
versifications22166915_versifications_
vilifications2166745_vil_ifications_
acetifications2146056_acetifications_
acidifications2254636_acidifications_
ammonification2353046ammonification__
basification19127326__basification__
beatifications21157466_beatifications_
beautification21144886beau_tification__
calcification1945826_calcification__
caprifications2385566_caprifications_
certifications2147796_certifications_
citifications2048546__citifications_
clarifications2155266_clarifications_
classification21113216classification__
coalification2046136coal_ification__
codifications21127626__codifications_
cornifications2145956_cornifications_
dandifications2145436_dandifications_
decalcification2262806decalcification__
deifications18410656___deifications_
demystification26102696demystification__
denazifications30164086denazifications_
densification1947336_densification__
detoxifications2884256detoxifications_
edification1749356e___dification__
elicitations1446806e__l_icitations_
eliminations1447616e__l_iminations_
emulations12310946emul_____ations_
equivocations2751846equ__ivocations_
esterification1995336esterification__
exemplification3161596exempl_ification__
explications2347536expl___ications_
exsiccations2343266e__xsi_ccations_
fortifications2286216_fortifications_
fructification2483676fructification__
gasification1867106__gasification__
gentrifications2175046gentrifications_
glorifications2074586_glorifications_
gratifications2045986_gratifications_
humidification2552906humidification__
humification2246106_hu_mification__
identifications2154496identifications_
implications1847026impl___ications_
jollification25134846_jollification__
justification2546096_justification__
lignifications20135116_lignifications_
lithifications22134796_lithifications_
magnification2145766_magnification__
mastications1649416_m_as_tications_
modification20107206_m_odification__
mortification2087296_mortification__
multiplication2063336_multiplication__
mystification2346196_mystification__
nazifications2745526__nazifications_
nidifications1946946__nidifications_
nitrifications1986636_nitrifications_
notifications1848236__notifications_
ossification17116546__ossification__
pacifications2267356__pacifications_
petrifications2148026_petrifications_
pontifications2187926_pontifications_
prettifications22135186prettifications_
purification1948176_pu_rification__
qualification2745036_qualification__
quantifications29114406quantifications_
ramifications2087536__ramifications_
ratifications1899786__ratifications_
recodifications23165456recodifications_
rectifications2148916_rectifications_
reifications17411826___reifications_
reunification18147456reu_nification__
revivifications2694056revivifications_
rigidifications2282886rigidifications_
rustications1448566_ru_s_tications_
sanctifications2254136sanctifications_
saponifications22133326saponifications_
scarifications2155766_scarifications_
significations20125676_significations_
silicifications2253076silicifications_
simplification2353386simpl_ification__
solidifications2153576solidifications_
specifications2345356_specifications_
stratifications2054236stratifications_
subsidizations2653736_subsidizations_
typifications2344636__typifications_
uglification1845496__uglification__
umbilications1994416__umbilications_
unification1648736__u_nification__
verifications21159976__verifications_
versification21157496_versification__
vilification2077126_vil_ification__
vinifications2177696__vinifications_
vitrifications2275966_vitrifications_
vivifications2486126__vivifications_
zombifications3263766_zombifications_

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.313570897.8
2DLD Change Limit658741364.07616161.4
3Display Results1361360.1101236.4
 (SQL Overall)1786911364.49939717.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.