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

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

110 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
biodegradations20121161biodegradations_
biodegradation19141192biodegradation__
degradations1544554___degradations_
biodegrading1851675biodegrad__i_n_g
degradation1445385___degradation__
intergradations17123455_intergradations_
aggradations1552706___aggradations_
biodegradable208966biodegrada___ble
biodegrades1672006biodegrad____es_
bioremediations2061256bioremediations_
depravations1885376___depravations_
depredations1646736___depredations_
gradations1286866_____gradations_
integrations13129476_integr__ations_
intergradation16114096_intergradation__
moderations1448276_mode_r__ations_
retrogradations17151646retrogradations_
aggradation1452997___aggradation__
aggravations1752437___aggravations_
bacterizations2766677bacte_rizations_
bifurcations1982937bi__fur_cations_
biodegrade1572057biodegrad______e
biodegraded1771537biodegrad_____ed
bioregions1362557bioreg_____ions_
bioremediation1961087bioremediation__
bipolarizations2883877bipolarizations_
botherations1754197b_other__ations_
bowdlerizations3062417bowdlerizations_
congregations17186417_co_ngregations_
cooperations1659197coope_r__ations_
dealations11311377___de__alations_
debarkations1943657___debarkations_
declamations1745307___declamations_
declarations1546807___declarations_
defamations1745897___de_famations_
deglaciations1753917___deglaciations_
degradative1763087___degradati__ve
degranulations1652747___degranulations_
degustations1444837___degustations_
demarcations1746127___demarcations_
denudations1346347___de_nudations_
deodorizations2556327deod_orizations_
deoxidations2145247___deoxidations_
depravation1785697___depravation__
deprecations1748567___deprecations_
depredation1546927___depredation__
deprivations1897927___deprivations_
derivations15611497___de_rivations_
derogations1349397___de_rogations_
desegregations1763567_desegregations_
detractions14118277___detra_ctions_
dimerizations2548547di_me_rizations_
disaggregations1962517disaggregations_
dissertations1465907disse_r_tations_
exonerations1947017exone_r__ations_
federations1548887_fede_r__ations_
fiberizations27136377fi_be_rizations_
geometrizations2753427geometrizations_
gradation11107717_____gradation__
gradational1354477_____gradational
graduations1385237_____graduations_
hibernations1744057hi_be_r_nations_
idealizations2379457_i_dealizations_
ideations1039907_i_de____ations_
immigrations1743727_immigr__ations_
immoderations1853077immode_r__ations_
impetrations1645447_impetr__ations_
indagations1345407_ind___agations_
indentations1347887_inde__ntations_
indexations1946027_inde___xations_
indignations1446047_indig__nations_
indurations1249587_ind_ur__ations_
inebriations1456327_i_nebr_iations_
ingratiations1455157_i__ngratiations_
innervations1546927_inne_r_vations_
integration121310497_integr__ation__
integrationist1583687_integr__ationist
interactions14410467_inte_ra_ctions_
intercalations1655917_intercalations_
interrelations1457617_interrelations_
interrogations1556817_interrogations_
iodations1039117_io_____dations_
iodinations1268847_iod___inations_
irradiations1394887_i___rradiations_
isomerizations2555157isome_rizations_
iterations10413827_i_te_r__ations_
liberations1358947li_be_r__ations_
linearizations2355927li_nearizations_
literations11610587li_te_r__ations_
migrations13168687mi___gr__ations_
miscegenations1963027misceg_enations_
moderation1348657_mode_r__ation__
modernisations1752727_modernisations_
modernizations2654937_modernizations_
nonsegregations17162697nonsegregations_
operations12312957__ope_r__ations_
overactions1648217__ove_ra_ctions_
overtaxations2353517__overtaxations_
peregrinations17114687_peregrinations_
postgraduation1862047_postgraduation__
reintegrations15164787reintegr__ations_
reoperations14410067reope_r__ations_
reradiations1349497___re_radiations_
resegregations1653697_resegregations_
retardations1396517___retardations_
retrogradation16151887retrogradation__
segregations1445807___segregations_
tenderizations2455697tende_rizations_
tolerations1158137_tole_r__ations_
winterizations26157507winte_rizations_

Search took 9 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 Filter178691950240.360496363.9
2DLD Change Limit950241108.36011366.5
3Display Results1101100.0931182.8
 (SQL Overall)1786911108.81320275.8
 
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.