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

132 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
diversification24102781diversification_
versification21157493__versification_
versifications22166913__versifications
decertification2364324decertification_
densification1947334d__ensification_
densifications2046984d__ensifications
desertification2154124desertification_
verification201810644__ver_ification_
verifications21159974__ver_ifications
certification2048605__certification_
certifications2147795__certifications
deification17411665d__e__ification_
deifications18410655d__e__ifications
devitrification24133505devitrification_
divarication1855905divar___ication_
divarications1955505divar___ications
esterification1995335ester_ification_
esterifications20134815ester_ifications
identification2054995_identification_
identifications2154495_identifications
intensification2092765intensification_
latensification2071925latensification_
nitrification1877065ni_tr_ification_
nitrifications1986635ni_tr_ifications
recertification2263985recertification_
vitrification2166465vi_tr_ification_
vitrifications2275965vi_tr_ifications
vivification2366345viv___ification_
vivifications2486125viv___ifications
acetification2046726_ace_tification_
acetifications2146056_ace_tifications
basification19127326___basification_
basifications20137066___basifications
beatification20138076__beatification_
beatifications21157466__beatifications
caprification2256056_capr_ification_
caprifications2385566_capr_ifications
certificating2153646__certificati_ng
citification1949156ci___tification_
citifications2048546ci___tifications
clarification2045766_clar_ification_
clarifications2155266_clar_ifications
classification21113216_classification_
classifications2283086_classifications
cornification2046696__cornification_
cornifications2145956__cornifications
dandification2045906d__andification_
dandifications2145436d__andifications
deacidification2472696deacidification_
decalcification2262806decalcification_
demystification26102696demystification_
denazification29154436d_enazification_
denazifications30164086d_enazifications
denitrification21183876denitrification_
desensitization25152956desensitization_
desiccation1646386d__e_si_ccation_
desiccations1755656d__e_si_ccations
detoxification2754416d_etoxification_
detoxifications2884256d_etoxifications
dieselization2356056di_e_selization_
dieselizations2455916di_e_selizations
dimerization2449086dimer___ization_
dimerizations2548546dimer___izations
discrimination1955356discr_imination_
discriminations2074606discr_iminations
dissimilation1656526di__ssimilation_
dissimilations1755866di__ssimilations
divaricating1953596divar___icati_ng
diversifying2352166diversif___yi_ng
domestication18114546dome_s_tication_
domestications19143996dome_s_tications
edification1749356___e_dification_
edifications1848696___e_difications
emulsification2193446_emulsification_
emulsifications2283136_emulsifications
falsification2145246__falsification_
falsifications2244976__falsifications
fortification2196926__fortification_
fortifications2286216__fortifications
gasification1867106___gasification_
gasifications19116846___gasifications
gentrification2065636gentr_ification_
gentrifications2175046gentr_ifications
glorification1984896_glor_ification_
glorifications2074586_glor_ifications
indemnification2372006indemnification_
lignification19125706li__gnification_
lignifications20135116li__gnifications
lithification21105166li__thification_
lithifications22134796li__thifications
mortification2087296__mortification_
mortifications2186506__mortifications
nidification1847456ni___dification_
nidifications1946946ni___difications
objectification3181876objectification_
ossification17116546___ossification_
ossifications18176146___ossifications
overmedication2264006_overmedication_
overmedications2363666_overmedications
personification2272386__personification_
petrification2048816__petrification_
petrifications2148026__petrifications
prettification21115716_prettification_
prettifications22135186_prettifications
preunification2154306_preunification_
purification1948176__pur_ification_
purifications2047466__pur_ifications
rectification2049516__rectification_
rectifications2148916__rectifications
refortification2373376refortification_
reification16412906____reification_
reifications17411826____reifications
reunification18147456__reunification_
reunifications19136916__reunifications
revivification2564226rev_ivification_
revivifications2694056rev_ivifications
rigidification2173146ri_gidification_
rigidifications2282886ri_gidifications
scarification2056406_scar_ification_
scarifications2155766_scar_ifications
signification1986286si__gnification_
significations20125676si__gnifications
silicification2153166si_licification_
silicifications2253076si_licifications
simplification2353386si_mplification_
simplifications2463196si_mplifications
specification2245766_spe_cification_
specifications2345356_spe_cifications
vilification2077126__v_ilification_
vilifications2166746__v_ilifications
vinification2068236__v_inification_
vinifications2177696__v_inifications

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 Filter178691658740.313570897.8
2DLD Change Limit658741324.93613345.6
3Display Results1321320.1101200.0
 (SQL Overall)1786911325.35933344.1
 
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.