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

145 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
demystification26102691demystification_
mystification2346193__mystification_
mystifications2445643__mystifications
decertification2364324decertification_
densification1947334de_ns_ification_
densifications2046984de_ns_ifications
desertification2154124desertification_
beatification20138075be__atification_
beatifications21157465be__atifications
beautification21144885be_autification_
beautifications22154685be_autifications
certification2048605ce__rtification_
certifications2147795ce__rtifications
deacidification2472695deacidification_
decalcification2262805decalcification_
deification17411665de____ification_
deifications18410655de____ifications
denazification29154435de_nazification_
denazifications30164085de_nazifications
denitrification21183875denitrification_
detoxification2754415de_toxification_
detoxifications2884255de_toxifications
devitrification24133505devitrification_
domestication18114545domest__ication_
domestications19143995domest__ications
emulsification2193445_emulsification_
emulsifications2283135_emulsifications
identification2054995ide__ntification_
identifications2154495ide__ntifications
justification2546095__justification_
justifications2645555__justifications
mortification2087295__mortification_
mortifications2186505__mortifications
recertification2263985recertification_
rectification2049515re__ctification_
rectifications2148915re__ctifications
refortification2373375refortification_
versification21157495ve_rs_ification_
versifications22166915ve_rs_ifications
acetification2046726__acetification_
acetifications2146056__acetifications
ammonification2353046_ammonification_
ammonifications2453046_ammonifications
amplification2275186_am_plification_
amplifications2384756_am_plifications
basification19127326__bas_ification_
basifications20137066__bas_ifications
certificating2153646ce__rtificati_ng
citification1949156___citification_
citifications2048546___citifications
classification21113216_classification_
classifications2283086_classifications
commodification2791876commodification_
dandification2045906d__andification_
dandifications2145436d__andifications
decortication1857536decort__ication_
decortications1966776decort__ications
demobilization2855796dem_obilization_
demobilizations2955496dem_obilizations
demyelination1952956demy__elination_
demyelinations2052766demy__elinations
demystifying2551906demystif___yi_ng
desiccation1646386de__s_i_ccation_
desiccations1755656de__s_i_ccations
destination12413846de__st__ination_
destinations13412666de__st__inations
detoxication2246206de___toxication_
detoxications2355656de___toxications
diversification24102786diversification_
domesticating1953026domest__icati_ng
edification1749356_e___dification_
edifications1848696_e___difications
electrification2263416_electrification_
esterification1995336_esterification_
esterifications20134816_esterifications
exemplification3161596exem_plification_
falsification2145246_fals_ification_
falsifications2244976_fals_ifications
fortification2196926__fortification_
fortifications2286216__fortifications
fructification2483676_fructification_
fructifications25113356_fructifications
gasification1867106__gas_ification_
gasifications19116846__gas_ifications
gentrification2065636ge_ntrification_
gentrifications2175046ge_ntrifications
gratification1946686__gratification_
gratifications2045986__gratifications
humidification2552906hum_idification_
humidifications2652816hum_idifications
humification2246106hum___ification_
humifications2345856hum___ifications
indemnification2372006indem__nification_
magnification2145766__magnification_
magnifications2245116__magnifications
mastication15610296__mast__ication_
mastications1649416__mast__ications
modification20107206__m_odification_
modifications21106986__m_odifications
mollification20135556__mollification_
mollifications21145206__mollifications
mummification2154316__mummification_
mummifications2254016__mummifications
notification1749066___notification_
notifications1848236___notifications
objectification3181876objectification_
ossification17116546___ossification_
ossifications18176146___ossifications
personification2272386personification_
petrification2048816pe__trification_
petrifications2148026pe__trifications
pontification2089006__pontification_
pontifications2187916__pontifications
premodification2582976prem_odification_
prenotification2253606prenotification_
prettification21115716_prettification_
prettifications22135186_prettifications
quantification28124936_quantification_
quantifications29114406_quantifications
ramification1998216ram___ification_
ramifications2087536ram___ifications
ratification17810666___ratification_
ratifications1899786___ratifications
recodification22125666re_codification_
recodifications23165456re_codifications
reification16412906re____ification_
reifications17411826re____ifications
reunification18147456re__unification_
reunifications19136916re__unifications
revivification2564226re_vivification_
revivifications2694056re_vivifications
sanctification2154706_sanctification_
sanctifications2254136_sanctifications
simplification2353386sim_plification_
simplifications2463196sim_plifications
stratification1954676_stratification_
stratifications2054236_stratifications
stultification1963906_stultification_
stultifications2083536_stultifications
typification2244866__ty_pification_
typifications2344636__ty_pifications
verification201810646ve___rification_
verifications21159976ve___rifications
zombification3154066zom__bification_
zombifications3263766zom__bifications

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.313570897.8
2DLD Change Limit658741454.23315562.0
3Display Results1451450.1261150.8
 (SQL Overall)1786911454.67238247.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.