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

115 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
dandification204590(None) 
dandifications2145431dandifications
densification1947332densification
acidification2154883acidification
basification19127323ba_sification
calcification1945823calcification
caprification2256053caprification
codification20108073_codification
deacidification2472693deacidification
deification17411663d__eification
denazification29154433denazification
densifications2046983densifications
edification1749353__edification
falsification2145243falsification
gasification1867103ga_sification
identification2054993identification
magnification2145763magnification
modification20107203_modification
nazification2646043na_zification
nidification1847453_nidification
pacification2168053pa_cification
pontification2089013pontification
quantification28124933quantification
ramification1998213ra_mification
ratification17810663ra_tification
sanctification2154703sanctification
unification1648733_un_ification
vinification2068233vin_ification
abdication1548224_abd__ication
acetification2046724acetification
acidifications2254634acidifications
amplification2275184amplification
annihilation1594504_annihilation
anticipation1668284_anticipation
antifriction1773984_antifric_tion
basifications20137064ba_sifications
beatification20138074beatification
beautification21144884beautification
calcifications2045414calcifications
caprifications2385564caprifications
certification2048604certification
citification1949154_citification
clarification2045764clarification
classification21113214classification
coalification2046134coalification
codifications21127624_codifications
cornification2046694cornification
decalcification2262804decalcification
dedication14311964d_ed__ication
deifications18410654d__eifications
denazifications30164084denazifications
denitrification21183874denitrification
detoxification2754414detoxification
edifications1848694__edifications
falsifications2244974falsifications
fortification2196924fortification
gasifications19116844ga_sifications
gentrification2065634gentrification
glorification1984894glorification
gratification1946684gratification
humidification2552904humidification
humification2246104_humification
identifications2154494identifications
indication13312034_ind__ication
jollification25134844jollification
justification2546094justification
latensification2071924latensification
lignification19125704lignification
lithification21105164lithification
magnifications2245114magnifications
modifications21106984_modifications
mollification20135554mollification
mortification2087294mortification
mummification2154314mummification
mystification2346194mystification
nazifications2745524na_zifications
nidifications1946944_nidifications
nitrification1877064nitrification
notification1749064_notification
nullification1854694nullification
ossification17116544_ossification
pacifications2267354pa_cifications
petrification2048814petrification
pontifications2187924pontifications
purification1948174_purification
qualification2745034qualification
quantifications29114404quantifications
ramifications2087534ra_mifications
randomization2563864randomization
ratifications1899784ra_tifications
recodification22125664recodification
rectification2049514rectification
reification16412904__reification
reunification18147454reunification
rigidification2173144rigidification
sanctifications2254134sanctifications
sanitization2149154san_itization
saponification21103534saponification
scarification2056404scarification
signification1986284signification
solidification2053554solidification
specification2245764specification
syndication17124964synd__ication
typification2244864_typification
uglification1845494_uglification
unifications1748044_un_ifications
vandalization2656734vandalization
verification201810644_verification
versification21157494versification
vilification2077124_vilification
vindication1746354vind__ication
vinifications2177694vin_ifications
vitrification2166464vitrification
vivification2366344_vivification
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.376475242.0
2DLD Change Limit950241154.57620765.7
3Display Results1151150.0801437.5
 (SQL Overall)1786911155.03235510.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.