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

155 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
fructifications2511335(None) 
fructification2483671fructification_
rectifications2148912_rectifications
fortifications2286213f_ortifications
gratifications2045983gr_atifications
justifications2645553_justifications
prettifications22135183prettifications
ratifications1899783_r_atifications
rectification2049513_rectification_
sanctifications2254133sanctifications
stultifications2083533stultifications
acetifications2146054_acetifications
beatifications21157464_beatifications
beautifications22154684beautifications
calcifications2045414calc_ifications
certifications2147794_certifications
citifications2048544__citifications
emulsifications2283134emulsifications
falsifications2244974f_alsifications
fortification2196924f_ortification_
fractionations1952864fracti_onations
frenchification2872024frenchification_
gratification1946684gr_atification_
humifications2345854_hu_mifications
identifications2154494identifications
justification2546094_justification_
mortifications2186504_mortifications
mummifications2254014_mummifications
mystifications2445644_mystifications
notifications1848234__notifications
nullifications1954304_nullifications
pacifications2267354_pac_ifications
pontifications2187924_pontifications
prettification21115714prettification_
purifications2047464_pu_rifications
qualifications2844584_qualifications
quantifications29114404quantifications
ramifications2087534_r_amifications
ratification17810664_r_atification_
recodifications23165454_recodifications
reifications17411824_r__eifications
reunifications19136914_reunifications
rustications1448564_rust__ications
sanctification2154704sanctification_
specifications2345354spec_ifications
stratifications2054234stratifications
stultification1963904stultification_
uglifications1945194__uglifications
unifications1748044__u_nifications
acetification2046725_acetification_
acidifications2254635_acidifications
ammonifications2453045ammonifications
amplifications2384755_amplifications
basifications20137065__basifications
beatification20138075_beatification_
beautification21144885beautification_
brutalizations25146865bru_talizations
calcification1945825calc_ification_
caprifications2385565_caprifications
certification2048605_certification_
citification1949155__citification_
clarifications2155265_clarifications
classifications2283085classifications
coalifications2155705_coalifications
codifications21127625__codifications
cornifications2145955_cornifications
crucifixions266805cruc_ifi__xions
dandifications2145435_dandifications
deifications18410655___deifications
denazifications30164085denazifications
densifications2046985_densifications
detoxifications2884255detoxifications
edifications1848695___edifications
electrification2263415electrification_
emulsification2193445emulsification_
eroticizations25115785er_oticizations
eructations1347235eruct____ations
esterifications20134815esterifications
facilitations1845765f_ac_ilitations
factorizations2855765f_actorizations
falsification2145245f_alsification_
fertilizations26137895f_ertilizations
fictionizations2953495f_ictionizations
fluctuations1752565fluct___uations
fluidizations2663415flu__idizations
fractionation1853205fracti_onation_
frustrations1544535frust___rations
fustigations1644765f_ust__igations
gasifications19116845__gasifications
gentrifications2175045gentrifications
glorifications2074585_glorifications
humidifications2652815humidifications
humification2246105_hu_mification_
identification2054995identification_
jollifications26144595_jollifications
lignifications20135115_lignifications
lithifications22134795_lithifications
magnifications2245115_magnifications
modifications21106985__modifications
mollifications21145205_mollifications
mortification2087295_mortification_
multiplications2163185_multiplications
mummification2154315_mummification_
mystification2346195_mystification_
nazifications2745525__nazifications
nidifications1946945__nidifications
nitrifications1986635_nitrifications
notification1749065__notification_
nullification1854695_nullification_
objectification3181875objectification_
ossifications18176145__ossifications
pacification2168055_pac_ification_
petrifications2148025_petrifications
pontification2089015_pontification_
precipitations2085395prec_ipitations
prenotification2253605prenotification_
preunification2154305preunification_
purification1948175_pu_rification_
qualification2745035_qualification_
quantification28124935quantification_
ramification1998215_r_amification_
recertification2263985_recertification_
recodification22125665_recodification_
recriminations1856725_recriminations
reification16412905_r__eification_
reunification18147455_reunification_
reutilizations2348715_reutilizations
revivifications2694055revivifications
rigidifications2282885rigidifications
routinizations2355545_routinizations
rubrications1646265_ru__brications
rustication1349225_rust__ication_
saponifications22133325saponifications
scarifications2155765_scarifications
significations20125675_significations
silicifications2253075silicifications
simplifications2463195simplifications
solidifications2153575solidifications
specification2245765spec_ification_
stratification1954675stratification_
subtilizations2556065_subtilizations
typifications2344635__typifications
uglification1845495__uglification_
umbilications1994415__umbilications
unification1648735__u_nification_
urtications1348035__urt__ications
utilizations2148895__u_tilizations
verifications21159975__verifications
versifications22166915_versifications
victimizations3064285_victimizations
vilifications2166745__vilifications
vinifications2177695__vinifications
vitrifications2275965_vitrifications
vivifications2486125__vivifications
zombifications3263765_zombifications

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.313570897.8
2DLD Change Limit658741553.62318182.2
3Display Results1551550.1101409.1
 (SQL Overall)1786911554.04644164.9
 
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.