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

101 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
devitrification2413350(None) 
denitrification21183871denitrification
vitrification2166462__vitrification
decertification2364323decertification
desertification2154123desertification
gentrification2065633ge_ntrification
nitrification1877063__nitrification
petrification2048813pe__trification
revivification2564223revi_vification
vitrifications2275963__vitrifications
beatification20138074be_at_ification
beautification21144884beaut_ification
certification2048604ce_rt_ification
citification1949154__cit_ification
deacidification2472694deacidification
decalcification2262804decalcification
deification17411664de____ification
demystification26102694demystification
denazification29154434de_nazification
densification1947334de__nsification
detoxification2754414de_toxification
diversification24102784diversification
electrification2263414electrification
esterification1995334_esterification
gentrifications2175044ge_ntrifications
identification2054994ide_nt_ification
lithification21105164__lithification
nitrifications1986634__nitrifications
petrifications2148024pe__trifications
recertification2263984recertification
rectification2049514re_ct_ification
refortification2373374refortification
revivifications2694054revi_vifications
verification201810644__v_erification
vilification2077124__vi_lification
vinification2068234__vi_nification
vivification2366344__vi_vification
acetification2046725_acet_ification
acidification2154885_aci_dification
beatifications21157465be_at_ifications
beautifications22154685beaut_ifications
caprification2256055__caprification
centrifugation2061715ce_ntrifugation
certifications2147795ce_rt_ifications
citifications2048545__cit_ifications
clarification2045765__clarification
dandification2045905d__andification
decortication1857535de_cor_tication
defibrillation2061905defibri_llation
defibrination1953865defibr__ination
deifications18410655de____ifications
denazifications30164085de_nazifications
densifications2046985de__nsifications
detoxication2246205de__t_oxication
detoxifications2884255de_toxifications
divarication1855905div_ar__ication
edification1749355_e___dification
emulsification2193445_emulsification
esterifications20134815_esterifications
extrication2049795_e_xtr__ication
fortification2196925_fort_ification
fructification2483675fruct_ification
glorification1984895__glorification
gratification1946685_grat_ification
humidification2552905humi_dification
identifications2154495ide_nt_ifications
justification2546095_just_ification
legitimization2673605legit_imization
lignification19125705__lignification
lithifications22134795__lithifications
metrication15410655me__tr__ication
mortification2087295_mort_ification
mystification2346195_myst_ification
nidification1847455__ni_dification
notification1749065__not_ification
personification2272385personification
petrifaction1953725pe__trifac_tion
pontification2089005_pont_ification
prenotification2253605prenot_ification
prettification21115715_prettification
purification1948175___purification
quantification28124935quant_ification
ratification17810665__rat_ification
recodification22125665re_codification
rectifications2148915re_ct_ifications
reification16412905re____ification
reunification18147455re__unification
revitalization2667805revit_alization
rigidification2173145rigi_dification
sanctification2154705sanct_ification
scarification2056405__scarification
signification1986285__signification
silicification2153165sili_cification
solidification2053555soli_dification
stratification1954675strat_ification
stultification1963905stult_ification
verifications21159975__v_erifications
versification21157495__versification
vilifications2166745__vi_lifications
vinifications2177695__vi_nifications
vivifications2486125__vi_vifications

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.0931921408.6
2DLD Change Limit658741014.84313601.9
3Display Results1011010.0801262.5
 (SQL Overall)1786911015.01635624.2
 
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.