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

197 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
prettifications2213518(None) 
prettification21115711prettification_
petrifications2148022p_etrifications
rectifications2148912_rectifications
acetifications2146053ace_tifications
beatifications21157463_beatifications
certifications2147793_certifications
fructifications25113353fructifications
gratifications2045983gr_atifications
identifications2154493identifications
petrification2048813p_etrification_
pontifications2187903p_ontifications
prenotification2253603prenotification_
preunification2154303preunification_
ratifications1899783_r_atifications
rectification2049513_rectification_
reifications17411823_re__ifications
reunifications19136913_reunifications
acetification2046724ace_tification_
beatification20138074_beatification_
beautifications22154684beautifications
certification2048604_certification_
citifications2048544__citifications
deifications18410654_de__ifications
densifications2046984_densifications
detoxifications2884244_detoxifications
edifications1848694__e_difications
esterifications20134804esterifications
fortifications2286214_fortifications
fructification2483674fructification_
gentrifications2175044gentrifications
gratification1946684gr_atification_
identification2054994identification_
justifications2645554_justifications
lithifications22134794_lithifications
mortifications2186504_mortifications
mystifications2445634_mystifications
nitrifications1986624_nitrifications
notifications1848224__notifications
pacifications2267354p__acifications
petrifactions2083554p_etrifac_tions
pontification2089004p_ontification_
precipitations2085394pre_cipitations
predications17411174pre___dications
prefabrications2492434prefabrications
premodification2582974premodification_
prepublications2372664prepublications
preterminations1954294preterminations
prevarications2154734pre_varications
purifications2047464p__urifications
quantifications29114404quantifications
ramifications2087534_r_amifications
ratification17810664_r_atification_
recodifications23165454_recodifications
reification16412904_re__ification_
reunification18147454_reunification_
reutilizations2348714_reutilizations
revivifications2694054_revivifications
sanctifications2254134sanctifications
specifications2345354spe_cifications
stratifications2054234stratifications
stultifications2083534stultifications
verifications21159964_ve_rifications
versifications22166904_versifications
vitrifications2275954_vitrifications
acidifications2254635_acidifications
ammonifications2453045ammonifications
amplifications2384755_amplifications
basifications20137065__basifications
beautification21144885beautification_
calcifications2045415_calcifications
caprifications2385565_caprifications
certificating2153635_certificati_ng
citification1949155__citification_
clarifications2155265_clarifications
classifications2283085classifications
coalifications2155705_coalifications
codifications21127625__codifications
cornifications2145955_cornifications
dandifications2145435_dandifications
decertification2364325decertification_
deification17411665_de__ification_
denazifications30164085denazifications
densification1947335_densification_
desertification2154125desertification_
detoxications2355635_de_toxications
detoxification2754415_detoxification_
edification1749355__e_dification_
electrification2263405electrification_
emulsifications2283135emulsifications
eroticizations25115785er_oticizations
esterification1995325esterification_
extrications2149045__ext_rications
falsifications2244975_falsifications
fertilizations26137895_fertilizations
fortification2196925_fortification_
frenchification2872025frenchification_
gasifications19116845__gasifications
gentrification2065635gentrification_
ghettoizations2751965ghett_oizations
glorifications2074575_glorifications
humidifications2652815humidifications
humifications2345855__humifications
jollifications26144595_jollifications
justification2546095_justification_
keratinizations2853865keratinizations
lignifications20135105_lignifications
lithification21105165_lithification_
magnifications2245115_magnifications
metafictions1952655_me_tafic_tions
metrications1649815_me_t_rications
modifications21106985__modifications
mollifications21145205_mollifications
mortification2087295_mortification_
mummifications2254015_mummifications
mystification2346185_mystification_
nazifications2745525__nazifications
nidifications1946935__nidifications
nitrification1877065_nitrification_
notification1749065__notification_
nullifications1954305_nullifications
objectification3181875objectification_
ossifications18176145__ossifications
pacification2168055p__acification_
participations2054525p_articipations
pectinations1649255p_ect__inations
personification2272385personification_
petrifaction1953725p_etrifac_tion_
plasticizations2853535plasticizations
politicizations28204015politicizations
pontificating2153755p_ontificati_ng
pontificators2053055p_ontificat_ors
precipitation1966225pre_cipitation_
preconvictions2353355preconvic_tions
predestinations1865005predestinations
predication16412435pre___dication_
predictions1649645pre___dic_tions
predilections1853545pre_dilec_tions
predominations19105545pre_dominations
prefabrication2392825prefabrication_
prefigurations2053025pre_figurations
prelibations16127625pre___libations
premeditations1955015pre_meditations
prenominations18105765pre_nominations
preordinations1765695pre_ordinations
prepublication2252925prepublication_
pressurizations2692715pressurizations
pretermination1854775pretermination_
prevarication2055245pre_varication_
prioritizations26123835prioritizations
proliferations1952685pr_oliferations
propitiations1756205pr_opiti_ations
purification1948175p__urification_
qualifications2844585_qualifications
quantification28124935quantification_
ramification1998215_r_amification_
reapplications2054255_reapplications
recertification2263985recertification_
recodification22125665_recodification_
recriminations1856725_recriminations
rededications1746115_re_dedications
reduplications1964535_reduplications
refortification2373375_refortification_
relubrications1854195_relubrications
replications16811055_re__plications
republications2074455_republications
restimulations1654645_restimulations
restrictions1449275_rest_ric_tions
retaliations12511405_re_tali_ations
reticulations1556615_re_ticulations
retrodictions1655535_retrodic_tions
reutilization2249195_reutilization_
revivification2564225_revivification_
rigidifications2282885rigidifications
routinizations2355545_routinizations
rustications1448565_rust__ications
sanctification2154705sanctification_
saponifications22133325saponifications
scarifications2155765_scarifications
significations20125675_significations
silicifications2253075silicifications
simplifications2463195simplifications
solidifications2153575solidifications
specification2245765spe_cification_
stratification1954675stratification_
stultification1963905stultification_
typifications2344635__typifications
uglifications1945195__uglifications
unifications1748045___unifications
urtications1348035ur__t__ications
verification201810645_ve_rification_
versification21157495_versification_
vilifications2166745__vilifications
vinifications2177695__vinifications
vitrification2166465_vitrification_
vivifications2486125__vivifications
zombifications3263765_zombifications

Search took 7 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.1101624463.6
2DLD Change Limit658741976.29610462.8
3Display Results1971970.266740.6
 (SQL Overall)1786911976.67226782.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.