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

189 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
beautifications22154681beautifications_
beatifications21157462bea_tifications_
beautification21144882beautification__
beatification20138073bea_tification__
basifications20137064b_a_sifications_
certifications2147794ce_rtifications_
gratifications2045984gra_tifications_
quantifications29114404quantifications_
ratifications1899784_ra_tifications_
rectifications2148914re_ctifications_
reunifications19136914re_unifications_
acetifications2146055_acetifications_
basification19127325b_a_sification__
calcifications2045415_calcifications_
caprifications2385565_caprifications_
certification2048605ce_rtification__
citifications2048545__citifications_
clarifications2155265cla_rifications_
classifications2283085classifications_
coalifications2155705coa_lifications_
dandifications2145435_dandifications_
deifications18410655de___ifications_
denazifications30164085denazifications_
densifications2046985de_nsifications_
detoxifications2884255detoxifications_
edifications1848695_e__difications_
emulsifications2283135_emulsifications_
falsifications2244975_falsifications_
fortifications2286215_fortifications_
fructifications25113355fructifications_
gasifications19116845_ga_sifications_
gentrifications2175045gentrifications_
gratification1946685gra_tification__
humifications2345855__humifications_
identifications2154495identifications_
justifications2645555_justifications_
magnifications2245115_magnifications_
mortifications2186505_mortifications_
mystifications2445635_mystifications_
nazifications2745525_na_zifications_
notifications1848225__notifications_
pacifications2267355_pa_cifications_
petrifications2148025pe_trifications_
pontifications2187905_pontifications_
prettifications22135185prettifications_
purifications2047465__purifications_
qualifications2844585qua_lifications_
quantification28124935quantification__
ramifications2087535_ra_mifications_
ratification17810665_ra_tification__
recodifications23165455recodifications_
rectification2049515re_ctification__
reifications17411825re___ifications_
reunification18147455re_unification__
reutilizations2348715re_utilizations_
revivifications2694055revivifications_
sanctifications2254135sanctifications_
scarifications2155765sca_rifications_
stratifications2054235stratifications_
stultifications2083535stultifications_
unifications1748045___unifications_
verifications21159965ve__rifications_
versifications22166905ve_rsifications_
acetification2046726_acetification__
acidifications2254636_acidifications_
ammonifications2453046ammonifications_
amplifications2384756_amplifications_
anticipations1757486__anticipations_
autoxidations2153556__autoxidations_
bacterizations2766656b_acterizations_
beauticians1552876beaut__ic__ians_
beneficiations21182216be__neficiations_
bituminizations2882516bituminizations_
brutalizations25146856b_rutalizations_
calcification1945826_calcification__
caprification2256056_caprification__
cauterizations25197146_cauterizations_
certificating2153636ce_rtificati_n_g
citification1949156__citification__
clarification2045766cla_rification__
classification21113216classification__
claudications1852886clau__dications_
coalification2046136coa_lification__
codifications21127626__codifications_
cornifications2145956_cornifications_
dandification2045906_dandification__
deacidification2472696deacidification__
deactivations19175066deact__ivations_
decalcification2262806decalcification__
decertification2364326decertification__
deification17411666de___ification__
demystification26102696demystification__
denazification29154436denazification__
denitrification21183876denitrification__
densification1947336de_nsification__
deputizations2546736deput__izations_
desertification2154126desertification__
detoxications2355646de__toxications_
detoxification2754416detoxification__
devitrification24133506devitrification__
edification1749356_e__dification__
elutriations1246026_elut_ri_ations_
emulsification2193446_emulsification__
equivocations2751836_equ_ivocations_
eroticizations25115786_eroticizations_
esterifications20134806esterifications_
extrications2149046_e_xt_rications_
falsification2145246_falsification__
fertilizations26137896fe_rtilizations_
fortification2196926_fortification__
fructification2483676fructification__
gasification1867106_ga_sification__
gelatinizations2554086gelatinizations_
gentrification2065636gentrification__
glorifications2074586_glorifications_
humidifications2652816humidifications_
humification2246106__humification__
identification2054996identification__
jollifications26144596_jollifications_
justification2546096_justification__
keratinizations2853866keratinizations_
latinizations22159016_la_tinizations_
legitimizations2773336legitimizations_
lignifications20135116_lignifications_
lithifications22134796_lithifications_
magnification2145766_magnification__
mastications1649416_mast__ications_
metafictions1952656me__tafic_tions_
metrications1649826me__t_rications_
misutilizations26145156misutilizations_
modifications21106986__modifications_
mollifications21145206_mollifications_
mortification2087296_mortification__
mummifications2254016_mummifications_
mystification2346186_mystification__
nazification2646046_na_zification__
nidifications1946936__nidifications_
nitrifications1986636_nitrifications_
notification1749066__notification__
nullifications1954306_nullifications_
objectification3181876objectification__
ossifications18176146__ossifications_
pacification2168056_pa_cification__
participations2054526_participations_
petrification2048816pe_trification__
plasticizations2853536plasticizations_
pontification2089006_pontification__
prenotification2253606prenotification__
prettification21115716prettification__
preunification2154306preunification__
purification1948176__purification__
qualification2745036qua_lification__
ramification1998216_ra_mification__
reactivations18176146react__ivations_
reapplications2054256rea_pplications_
recertification2263986recertification__
recodification22125666recodification__
reduplications1964536redu_plications_
refortification2373376refortification__
reification16412906re___ification__
relubrications1854196relu_brications_
republications2074456repu_blications_
reutilization2249196re_utilization__
revivification2564226revivification__
rigidifications2282886rigidifications_
routinizations2355546_routinizations_
sanctification2154706sanctification__
saponifications22133326saponifications_
scarification2056406sca_rification__
securitizations2654166securitizations_
significations20125676_significations_
silicifications2253076silicifications_
simplifications2463196simplifications_
solidifications2153576solidifications_
specifications2345356_specifications_
stratification1954676stratification__
stultification1963906stultification__
typifications2344636__typifications_
uglifications1945196__uglifications_
unification1648736___unification__
utilizations2148896___utilizations_
vaticinations1845036_va_ticinations_
verification201810646ve__rification__
versification21157496ve_rsification__
vilifications2166746__vilifications_
vinifications2177696__vinifications_
vitrifications2275966_vitrifications_
vivifications2486126__vivifications_
zombifications3263766_zombifications_

Search took 6 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.0931921408.6
2DLD Change Limit658741895.06313010.9
3Display Results1891890.1401350.0
 (SQL Overall)1786911895.29633740.7
 
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.