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

109 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
exemplification3161591exemplification_
amplification2275184__amplification_
amplifications2384754__amplifications
simplification2353384_simplification_
simplifications2463194_simplifications
electrification2263415electrification_
emulsification2193445__emulsification_
emulsifications2283135__emulsifications
explication2248455ex__pl__ication_
explications2347535ex__pl__ications
premodification2582975premodification_
acetification2046726ace__tification_
acetifications2146056ace__tifications
ammonification2353046_ammonification_
ammonifications2453046_ammonifications
beatification20138076_be_atification_
beatifications21157466_be_atifications
beautification21144886_beautification_
beautifications22154686_beautifications
caprification2256056__caprification_
caprifications2385566__caprifications
certification2048606_ce_rtification_
certifications2147796_ce_rtifications
coalification2046136__coalification_
coalifications2155706__coalifications
commodification2791876commodification_
complication2048206_compl__ication_
complications2147436_compl__ications
decalcification2262806_decalcification_
decertification2364326dece_rtification_
deification17411666_de___ification_
deifications18410656_de___ifications
demystification26102696_demystification_
denazification29154436_denazification_
denazifications30164086_denazifications
densification1947336_de_nsification_
densifications2046986_de_nsifications
desertification2154126dese_rtification_
detoxification2754416_detoxification_
detoxifications2884256_detoxifications
edification1749356__e__dification_
edifications1848696__e__difications
esterification1995336e_sterification_
esterifications20134816e_sterifications
exemplifying3051516exemplif___yi_ng
explicating2356126ex__pl__icati_ng
exploitation2154706ex__pl_oitation_
exploitations2254216ex__pl_oitations
extemporisation2661776extemp_orisation_
extemporization3562436extemp_orization_
frenchification2872026frenchification_
gentrification2065636_gentrification_
gentrifications2175046_gentrifications
humidification2552906_humidification_
humidifications2652816_humidifications
humification2246106_hum__ification_
humifications2345856_hum__ifications
identification2054996ide_ntification_
identifications2154496ide_ntifications
implication1747776__impl__ication_
implications1847026__impl__ications
indemnification2372006indem_nification_
jollification25134846__jollification_
jollifications26144596__jollifications
modification20107206___modification_
modifications21106986___modifications
mollification20135556__mollification_
mollifications21145206__mollifications
mummification2154316_mum_mification_
mummifications2254016_mum_mifications
nullification1854696__nullification_
nullifications1954306__nullifications
petrification2048816_pe_trification_
petrifications2148026_pe_trifications
prenotification2253606prenotification_
prettification21115716pre_ttification_
prettifications22135186pre_ttifications
preunification2154306pre_unification_
qualification2745036__qualification_
qualifications2844586__qualifications
ramification1998216_ram__ification_
ramifications2087536_ram__ifications
recertification2263986rece_rtification_
recodification22125666_recodification_
recodifications23165456_recodifications
rectification2049516_re_ctification_
rectifications2148916_re_ctifications
reification16412906_re___ification_
reifications17411826_re___ifications
replication15712016_re_pl__ication_
replications16811056_re_pl__ications
reunification18147456_re_unification_
reunifications19136916_re_unifications
revivification2564226_revivification_
revivifications2694056_revivifications
specification2245766spe__cification_
specifications2345356spe__cifications
typification2244866__typ_ification_
typifications2344636__typ_ifications
uglification1845496___uglification_
uglifications1945196___uglifications
verification201810646_ve__rification_
verifications21159976_ve__rifications
versification21157496_ve_rsification_
versifications22166916_ve_rsifications
vilification2077126___vilification_
vilifications2166746___vilifications
zombification3154066_zom_bification_
zombifications3263766_zom_bifications

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.326548131.9
2DLD Change Limit658741094.84313601.9
3Display Results1091090.0801362.5
 (SQL Overall)1786911095.24934042.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.