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

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

187 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
gentrifications2175041gentrifications_
gentrification2065632gentrification__
petrifications2148023pe_trifications_
beatifications21157464beat_ifications_
centrifugations2161484centrifugations_
certifications2147794cert_ifications_
denazifications30164084denazifications_
denitrification21183874denitrification__
densifications2046984den_sifications_
esterifications20134814_esterifications_
glorifications2074584g_lorifications_
gratifications2045984grat_ifications_
identifications2154494ident_ifications_
nitrifications1986634_nitrifications_
petrification2048814pe_trification__
pontifications2187924pont_ifications_
rectifications2148914rect_ifications_
verifications21159974ve__rifications_
vitrifications2275964_vitrifications_
acetifications2146055acet_ifications_
beatification20138075beat_ification__
beautifications22154685beautifications_
caprifications2385565_caprifications_
centralizations26157785centralizations_
centrifugation2061715centrifugation__
certification2048605cert_ification__
citifications2048545_cit_ifications_
clarifications2155265_clarifications_
dandifications2145435dan_difications_
deifications18410655de___ifications_
denazification29154435denazification__
densification1947335den_sification__
detoxifications2884255detoxifications_
devitrification24133505devitrification__
edifications1848695_e__difications_
electrification2263415electrification__
esterification1995335_esterification__
extrications2149055_extr__ications_
fortifications2286215fort_ifications_
gasifications19116845g__asifications_
generalisations1673625generalisations_
generalizations2557155generalizations_
glorification1984895g_lorification__
gratification1946685grat_ification__
identification2054995ident_ification__
justifications2645555just_ifications_
lithifications22134795_lithifications_
metrications1649835me_tr__ications_
mortifications2186505mort_ifications_
mystifications2445645myst_ifications_
nazifications2745525__nazifications_
nidifications1946945__nidifications_
nitrification1877065_nitrification__
notifications1848235__notifications_
petrifactions2083565pe_trifac_tions_
pontification2089015pont_ification__
prettifications22135185prettifications_
purifications2047465__purifications_
quantifications29114405quant_ifications_
ratifications1899785_rat_ifications_
recodifications23165455recodifications_
rectification2049515rect_ification__
reifications17411825re___ifications_
reunifications19136915re_unifications_
revivifications2694055revivifications_
sanctifications2254135sanctifications_
scarifications2155765_scarifications_
unifications1748045_un__ifications_
verification201810645ve__rification__
versifications22166915ve_rsifications_
vinifications2177695vin__ifications_
vitrification2166465_vitrification__
acetification2046726acet_ification__
acidifications2254636_acidifications_
ammonifications2453046ammonifications_
amplifications2384756_amplifications_
anticipations1757496_ant_icipations_
basifications20137066__basifications_
beautification21144886beautification__
beneficiations21182216ben__eficiations_
calcifications2045416_calcifications_
caprification2256056_caprification__
centralization25108156centralization__
certificating2153646cert_ificati_n_g
citification1949156_cit_ification__
clarification2045766_clarification__
classifications2283086classifications_
coalifications2155706_coalifications_
codifications21127626__codifications_
contradictions1954146contradic_tions_
cornifications2145956_cornifications_
dandification2045906dan_dification__
decertification2364326decertification__
decortications1966786decor_tications_
deification17411666de___ification__
denticulations1753916dent_iculations_
desertification2154126desertification__
detoxications2355656de_t_oxications_
detoxification2754416detoxification__
edification1749356_e__dification__
emulsifications2283136emulsifications_
energizations2356186_ener_gizations_
eradications1549316_e__radications_
eutrophications2261716_eutrophications_
extrication2049796_extr__ication__
falsifications2244976_falsifications_
fantastications2062056fantastications_
fertilizations26137896fert_ilizations_
fortification2196926fort_ification__
frenchification2872026frenchification__
fructifications25113356fructifications_
gasification1867106g__asification__
gelatinizations2554086gelatinizations_
generalisation1553726generalisation__
generalization2457546generalization__
generations12311426gener____ations_
germinations15137946ge__r_minations_
gesticulations1784116gest_iculations_
humidifications2652816humidifications_
humifications2345856__humifications_
incriminations18105136_incriminations_
intimidations1686666_int_imidations_
intoxications22135686_int_oxications_
jollifications26144596_jollifications_
justification2546096just_ification__
lignifications20135116_lignifications_
lithification21105166_lithification__
magnifications2245116_magnifications_
metafictions1952656me_t_afic_tions_
metrication15410656me_tr__ication__
modifications21106986__modifications_
mollifications21145206_mollifications_
mortification2087296mort_ification__
mummifications2254016_mummifications_
mystification2346196myst_ification__
nazification2646046__nazification__
neutralizations2456436neutralizations_
nidification1847456__nidification__
notification1749066__notification__
nullifications1954306_nullifications_
ossifications18176146__ossifications_
pacifications2267356__pacifications_
petrifaction1953726pe_trifac_tion__
pontificating2153776pont_ificati_n_g
pontificators2053056pont_ificat_ors_
prenotification2253606prenotification__
prettification21115716prettification__
purification1948176__purification__
qualifications2844586_qualifications_
quantification28124936quant_ification__
ramifications2087536__ramifications_
ratification17810666_rat_ification__
recertification2263986recertification__
recodification22125666recodification__
recriminations1856726re_criminations_
refortification2373376refortification__
reification16412906re___ification__
restrictions1449296restr__ic_tions_
retrodictions1655536re_trodic_tions_
reunification18147456re_unification__
reutilizations2348716reut_ilizations_
revivification2564226revivification__
rigidifications2282886rigidifications_
sanctification2154706sanctification__
saponifications22133326saponifications_
scarification2056406_scarification__
securitizations2654176securitizations_
sensitisations1493626sen_sitisations_
sensitizations23126096sen_sitizations_
significations20125676_significations_
silicifications2253076silicifications_
simplifications2463196simplifications_
solidifications2153576solidifications_
specifications2345356_specifications_
stratifications2054236stratifications_
stultifications2083536stultifications_
trifurcations1852866___trifurcations_
triplications1795076___triplications_
typifications2344636__typifications_
uglifications1945196__uglifications_
unification1648736_un__ification__
ventilations1547406vent___ilations_
versification21157496ve_rsification__
vilifications2166746__vilifications_
vinification2068236vin__ification__
vivifications2486126__vivifications_
zombifications3263766_zombifications_

Search took 8 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.673265514.1
2DLD Change Limit658741877.0169389.1
3Display Results1871870.1531222.2
 (SQL Overall)1786911877.84222786.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.