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

144 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
ammonifications245304(None) 
ammonification2353041ammonification_
ammoniations1645413ammon__i_ations
amplifications2384753a_mplifications
magnifications2245113_magnifications
modifications21106983__modifications
saponifications22133323saponifications
acetifications2146054a_cetifications
acidifications2254634a_cidifications
ammoniation1545904ammon__i_ation_
amplification2275184a_mplification_
codifications21127624__codifications
commodification2791874commodification_
cornifications2145954_cornifications
detoxifications2884244detoxifications
emulsifications2283134emulsifications
glorifications2074574_glorifications
humidifications2652814humidifications
humifications2345854hum__ifications
immobilizations30183294immobilizations
lignifications20135104_lignifications
magnification2145764_magnification_
modification20107204__modification_
mollifications21145204_mollifications
mortifications2186504_mortifications
mummifications2254014_mummifications
mystifications2445634_mystifications
notifications1848224__notifications
pontifications2187904__pontifications
ramifications2087534ram__ifications
recodifications23165454recodifications
reunifications19136914_reunifications
saponification21103534saponification_
significations20125674_significations
simplifications2463194simplifications
unifications1748044___unifications
vinifications2177694__vinifications
zombifications3263764zom_bifications
acetification2046725a_cetification_
acidification2154885a_cidification_
administrations18162405administrations
admonitions1444245admon__i__tions
ammoniating1644055ammon__i_ati_ng
ammunitions15113645ammun__i__tions
amortizations2456465a_mo_rtizations
annihilations1653995a__nnihilations
autoinfections1961775autoinfec_tions
basifications20137065__basifications
beatifications21157465_beatifications
beautifications22154685beautifications
calcifications2045415_calcifications
caprifications2385565_caprifications
certifications2147795_certifications
citifications2048545__citifications
clarifications2155265_clarifications
classifications2283085classifications
coalifications2155705_coalifications
codification20108075__codification_
communications22105735commun__ications
confiscations2044955__confiscations
cornification2046695_cornification_
dandifications2145435_dandifications
deifications18410655___deifications
demobilizations2955485demobilizations
demonetizations2755705demonetizations
demonizations25410225demon__izations
denazifications30164085denazifications
densifications2046985_densifications
detoxification2754415detoxification_
edifications1848695___edifications
emulsification2193445emulsification_
esterifications20134805esterifications
falsifications2244975_falsifications
fortifications2286215_fortifications
fructifications25113355fructifications
gasifications19116845__gasifications
gentrifications2175045gentrifications
glorification1984895_glorification_
gratifications2045985_gratifications
harmonizations28124835harmon__izations
humidification2552905humidification_
humification2246105hum__ification_
identifications2154495identifications
immobilization29183515immobilization_
immunizations26115325immun__izations
jollifications26144595_jollifications
justifications2645555_justifications
lignification19125695_lignification_
lithifications22134795_lithifications
minimizations26136545__minimizations
mobilizations2687875__mobilizations
mollification20135555_mollification_
monetizations2467625__monetizations
mortification2087295_mortification_
mummification2154315_mummification_
mystification2346185_mystification_
nazifications2745525__nazifications
nidifications1946935__nidifications
nitrifications1986625_nitrifications
nonfictions1645925__non_fic_tions
notification1749065__notification_
nullifications1954305_nullifications
ossifications18176145__ossifications
pacifications2267355__pacifications
personification2272385personification_
petrifications2148025_petrifications
pontification2089005__pontification_
premodification2582975premodification_
prettifications22135185prettifications
preunification2154305preunification_
purifications2047465__purifications
qualifications2844585_qualifications
quantifications29114405quantifications
ramification1998215ram__ification_
ratifications1899785__ratifications
recodification22125665recodification_
rectifications2148915_rectifications
reifications17411825___reifications
remobilizations2855495remobilizations
remonetizations2655765remonetizations
reunification18147455_reunification_
revivifications2694055revivifications
rigidifications2282885rigidifications
sanctifications2254135sanctifications
scarifications2155765_scarifications
signification1986285_signification_
silicifications2253075silicifications
simplification2353385simplification_
solidifications2153575solidifications
sonications1349945__son__ications
specifications2345355_specifications
stratifications2054235stratifications
stultifications2083535stultifications
typifications2344635__typifications
uglifications1945195__uglifications
umbilications1994415_um_bilications
unification1648735___unification_
verifications21159965__verifications
versifications22166905_versifications
vilifications2166745__vilifications
vinification2068235__vinification_
vitrifications2275955_vitrifications
vivifications2486125__vivifications
zombification3154065zom_bification_

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.1101624463.6
2DLD Change Limit658741444.39015005.5
3Display Results1441440.1101309.1
 (SQL Overall)1786911444.61038761.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.