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 “petrifications” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

133 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
petrifications214802(None) 
petrification2048811petrification_
certifications2147792certifications
gentrifications2175042gentrifications
nitrifications1986632nitrifications
petrifactions2083552petrifac_tions
prettifications22135182prettifications
purifications2047462p_urifications
verifications21159962ve_rifications
vitrifications2275962vitrifications
acetifications2146053acet_ifications
beatifications21157463beatifications
caprifications2385563caprifications
certification2048603certification_
citifications2048543cit_ifications
clarifications2155263clarifications
deifications18410653de__ifications
densifications2046983densifications
detoxifications2884253detoxifications
edifications1848693_e_difications
esterifications20134803esterifications
fortifications2286213fortifications
gentrification2065633gentrification_
glorifications2074583glorifications
lithifications22134793lithifications
metrications1649823metr__ications
mortifications2186503mortifications
nitrification1877063nitrification_
notifications1848223not_ifications
pacifications2267353p_acifications
petrifaction1953723petrifac_tion_
pontifications2187903pontifications
prettification21115713prettification_
purification1948173p_urification_
ratifications1899783rat_ifications
rectifications2148913rectifications
reifications17411823re__ifications
reunifications19136913reunifications
scarifications2155763scarifications
specifications2345353spe_cifications
verification201810643ve_rification_
versifications22166903versifications
vitrification2166463vitrification_
acetification2046724acet_ification_
acidifications2254634acidifications
amplifications2384754amplifications
basifications20137064_basifications
beatification20138074beatification_
beautifications22154684beautifications
calcifications2045414calcifications
caprification2256054caprification_
centrifugations2161484centrifugations
certificating2153634certificati_ng
citification1949154cit_ification_
clarification2045764clarification_
coalifications2155704coalifications
codifications21127624_codifications
cornifications2145954cornifications
dandifications2145434dandifications
deification17411664de__ification_
denazifications30164084denazifications
denitrification21183874denitrification_
densification1947334densification_
detoxications2355644det_oxications
detoxification2754414detoxification_
devitrification24133504devitrification_
edification1749354_e_dification_
electrification2263404electrification_
eradications1549294_e_radications
esterification1995324esterification_
extrications2149044extr__ications
falsifications2244974falsifications
fertilizations26137894fertilizations
fortification2196924fortification_
gasifications19116844_gasifications
glorification1984894glorification_
gratifications2045984gratifications
humifications2345854_humifications
identifications2154494identifications
jollifications26144594jollifications
justifications2645554justifications
lignifications20135114lignifications
lithification21105164lithification_
magnifications2245114magnifications
metafictions1952654met_afic_tions
metrication15410654metr__ication_
modifications21106984_modifications
mollifications21145204mollifications
mortification2087294mortification_
mummifications2254014mummifications
mystifications2445634mystifications
nazifications2745524_nazifications
nidifications1946934_nidifications
notification1749064not_ification_
nullifications1954304nullifications
ossifications18176144_ossifications
pacification2168054p_acification_
participations2054524participations
patronizations2576184patronizations
perfections1848124pe_r_fec_tions
perforations1747854pe_r_forations
periodizations2655574pe_riodizations
perspirations1786164pe_rspirations
pontification2089004pontification_
predications17411174p__redications
preunification2154304preunification_
purificators1962444p_urificat_ors
putrefactions2052264putrefac_tions
qualifications2844584qualifications
ramifications2087534_ramifications
ratification17810664rat_ification_
recodifications23165454recodifications
recriminations1856724recriminations
rectification2049514rectification_
reification16412904re__ification_
retrodictions1655534retrodic_tions
reunification18147454reunification_
revivifications2694054revivifications
scarification2056404scarification_
significations20125674significations
specification2245764spe_cification_
sterilizations2357964sterilizations
stratifications2054234_stratifications
trifurcations1852864__trifurcations
triplications1795074__triplications
typifications2344634_typifications
uglifications1945194_uglifications
unifications1748044__unifications
versification21157494versification_
vilifications2166744_vilifications
vinifications2177694_vinifications
vivifications2486124_vivifications
zombifications3263764zombifications

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 Limit658741334.48314694.2
3Display Results1331330.0931430.1
 (SQL Overall)1786911334.68638132.9
 
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.