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 “nitrification” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
nitrification187706(None) 
nitrifications1986631nitrifications
vitrification2166461vitrification
citification1949152cit_ification
denitrification21183872denitrification
lithification21105162lithification
nidification1847452ni_dification
notification1749062not_ification
petrification2048812petrification
vitrifications2275962vitrifications
caprification2256053caprification
certification2048603certification
citifications2048543cit_ifications
clarification2045763clarification
devitrification24133503devitrification
esterification1995333esterification
fortification2196923fortification
gentrification2065633gentrification
glorification1984893glorification
lignification19125703lignification
lithifications22134793lithifications
mortification2087293mortification
nazification2646043n_azification
nidifications1946943ni_difications
notifications1848233not_ifications
nullification1854693nullification
petrifications2148023petrifications
purification1948173_purification
ratification17810663rat_ification
scarification2056403scarification
signification1986283signification
verification201810643_verification
vilification2077123vi_lification
vinification2068233vi_nification
vivification2366343vi_vification
acetification2046724acetification
acidification2154884acidification
amplification2275184amplification
basification19127324_basification
beatification20138074beatification
calcification1945824calcification
caprifications2385564caprifications
certifications2147794certifications
clarifications2155264clarifications
coalification2046134coalification
codification20108074_codification
cornification2046694cornification
dandification2045904dandification
deification17411664__deification
densification1947334densification
detoxification2754414detoxification
diversification24102784diversification
edification1749354__edification
electrification2263414electrification
esterifications20134814esterifications
extrication2049794extr__ication
falsification2145244falsification
fortifications2286214fortifications
gasification1867104_gasification
gentrifications2175044gentrifications
glorifications2074584glorifications
gratification1946684gratification
humification2246104_humification
incrimination17145654incrimination
intensification2092764intensification
intimidation1547364int_imidation
intoxication21156354int_oxication
jollification25134844jollification
justification2546094justification
lignifications20135114lignifications
magnification2145764magnification
metrication15410654metr__ication
modification20107204_modification
mollification20135554mollification
mortifications2186504mortifications
mummification2154314mummification
mystification2346194mystification
nazifications2745524n_azifications
nitration9313444nitr____ation
nullifications1954304nullifications
ossification17116544_ossification
pacification2168054_pacification
petrifaction1953724petrifac_tion
pontification2089014pontification
prettification21115714prettification
purifications2047464_purifications
qualification2745034qualification
ramification1998214_ramification
ratifications1899784rat_ifications
rectification2049514rectification
reification16412904__reification
reunification18147454reunification
rigidification2173144rigidification
sanctification2154704sanct_ification
scarifications2155764scarifications
significations20125674significations
silicification2153164silicification
simplification2353384simplification
specification2245764specification
stratification1954674_stratification
trifurcation1753274__trifurcation
triplication1695384__triplication
typification2244864_typification
uglification1845494_uglification
unification1648734__unification
verifications21159974_verifications
versification21157494versification
vilifications2166744vi_lifications
vinifications2177694vi_nifications
vivifications2486124vi_vifications
zombification3154064zombification

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 Filter178691950240.360496363.9
2DLD Change Limit950241115.17318369.2
3Display Results1111110.0601850.0
 (SQL Overall)1786911115.59331949.0
 
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.