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]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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

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.1101624463.6
2DLD Change Limit65874734.29615333.8
3Display Results73730.0461587.0
 (SQL Overall)178691734.45240137.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.