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

206 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
prettification2111571(None) 
prettifications22135181prettifications
petrification2048812p_etrification
prenotification2253602prenotification
preunification2154302preunification
rectification2049512_rectification
acetification2046723ace_tification
beatification20138073_beatification
certification2048603_certification
fructification2483673fructification
gratification1946683gr_atification
identification2054993identification
petrifications2148023p_etrifications
pontification2089003p_ontification
premodification2582973premodification
ratification17810663_r_atification
rectifications2148913_rectifications
reification16412903_re__ification
reunification18147453_reunification
acetifications2146054ace_tifications
beatifications21157464_beatifications
beautification21144884beautification
certifications2147794_certifications
citification1949154__citification
decertification2364324decertification
deification17411664_de__ification
densification1947334_densification
desertification2154124desertification
detoxification2754414_detoxification
edification1749354__e_dification
electrification2263414electrification
esterification1995334esterification
fortification2196924_fortification
frenchification2872024frenchification
fructifications25113354fructifications
gentrification2065634gentrification
gratifications2045984gr_atifications
identifications2154494identifications
justification2546094_justification
lithification21105164_lithification
mortification2087294_mortification
mystification2346194_mystification
nitrification1877064_nitrification
notification1749064__notification
objectification3181874objectification
pacification2168054p__acification
personification2272384personification
petrifaction1953724p_etrifac_tion
pontifications2187914p_ontifications
precipitation1966224pre_cipitation
predication16412434pre___dication
prefabrication2392824prefabrication
prepublication2252924prepublication
pretermination1854774pretermination
prevarication2055244pre_varication
purification1948174p__urification
quantification28124934quantification
ramification1998214_r_amification
ratifications1899784_r_atifications
recertification2263984recertification
recodification22125664_recodification
refortification2373374_refortification
reifications17411824_re__ifications
reunifications19136914_reunifications
reutilization2249194_reutilization
revivification2564224_revivification
sanctification2154704sanctification
specification2245764spe_cification
stratification1954674stratification
stultification1963904stultification
verification201810644_ve_rification
versification21157494_versification
vitrification2166464_vitrification
acidification2154885_acidification
ammonification2353045ammonification
amplification2275185_amplification
basification19127325__basification
beautifications22154685beautifications
calcification1945825_calcification
caprification2256055_caprification
certificating2153645_certificating
citifications2048545__citifications
clarification2045765_clarification
classification21113215classification
coalification2046135_coalification
codification20108075__codification
cornification2046695_cornification
dandification2045905_dandification
deifications18410655_de__ifications
demystification26102695demystification
denazification29154435denazification
denitrification21183875denitrification
densifications2046985_densifications
detoxication2246205_de_toxication
detoxifications2884255_detoxifications
devitrification24133505devitrification
diversification24102785diversification
edifications1848695__e_difications
emulsification2193445emulsification
eroticization2476035er_oticization
esterifications20134815esterifications
exemplification3161595exemplification
extrication2049795__ext_rication
falsification2145245_falsification
fertilization2588455_fertilization
fortifications2286215_fortifications
gasification1867105__gasification
gentrifications2175045gentrifications
ghettoization2652185ghett_oization
glorification1984895_glorification
humidification2552905humidification
humification2246105__humification
indemnification2372005indemnification
intensification2092765intensification
jollification25134845_jollification
justifications2645555_justifications
keratinization2754005keratinization
latensification2071925latensification
lignification19125705_lignification
lithifications22134795_lithifications
magnification2145765_magnification
metafiction1852845_me_tafic_tion
metrication15410655_me_t_rication
modification20107205__modification
mollification20135555_mollification
mortifications2186505_mortifications
mummification2154315_mummification
mystifications2445645_mystifications
nazification2646045__nazification
nidification1847455__nidification
nitrifications1986635_nitrifications
notifications1848235__notifications
nullification1854695_nullification
ossification17116545__ossification
pacifications2267355p__acifications
participation1955255p_articipation
pectination15410335p_ect__ination
petrifactions2083565p_etrifac_tions
plasticization2764005plasticization
politicization27194205politicization
pontificating2153765p_ontificating
pontificator1953465p_ontificat_or
precipitations2085395pre_cipitations
preconviction2253705preconvic_tion
predestination1765485predestination
predications17411185pre___dications
prediction15410305pre___dic_tion
predilection1754105pre_dilec_tion
predomination1896535pre_domination
prefabrications2492435prefabrications
prefiguration1953455pre_figuration
prelibation15128665pre___libation
premeditation1855705pre_meditation
premigration1755695pre_mi_gration
prenomination17126755pre_nomination
preordination1656155pre_ordination
prepublications2372665prepublications
pressurization2593125pressurization
preterminations1954305preterminations
prevarications2154745pre_varications
prioritization2584155prioritization
proliferation1853035pr_oliferation
propitiation1656915pr_opiti_ation
purifications2047465p__urifications
qualification2745035_qualification
quantifications29114405quantifications
ramifications2087535_r_amifications
reapplication1954725_reapplication
recodifications23165455_recodifications
recrimination1757405_recrimination
rededication1646505_re_dedication
reduplication1855045_reduplication
relubrication1754505_relubrication
replication15712015_re__plication
republication1964635_republication
restimulation1555375_restimulation
restriction1349365_rest_ric_tion
retaliation11612325_re_tali_ation
reticulation1448055_re_ticulation
retrodiction1555655_retrodic_tion
reutilizations2348715_reutilizations
revivifications2694055_revivifications
rigidification2173145rigidification
routinization2255835_routinization
rustication1349225_rust__ication
sanctifications2254135sanctifications
saponification21103535saponification
scarification2056405_scarification
signification1986285_signification
silicification2153165silicification
simplification2353385simplification
solidification2053555solidification
specifications2345355spe_cifications
stratifications2054235stratifications
stultifications2083535stultifications
typification2244865__typification
uglification1845495__uglification
unification1648735___unification
urtication1249115ur__t__ication
verifications21159975_ve_rifications
versifications22166915_versifications
vilification2077125__vilification
vinification2068235__vinification
vitrifications2275965_vitrifications
vivification2366345__vivification
zombification3154065_zombification

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 Filter178691950240.360496363.9
2DLD Change Limit950242066.43614764.4
3Display Results2062060.1561320.5
 (SQL Overall)1786912066.95225703.5
 
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.