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

170 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
aggregatenesses1871571aggregatenesses_
aggregateness1662333aggregatene_s_s_
agreeablenesses1873365a_greeablenesses_
greatnesses1247795__gre_at_nesses_
accuratenesses1853086a_ccuratenesses_
adequatenesses2462636a_dequatenesses_
aggregates1344126aggregat_____es_
animatenesses1555946a__nimatenesses_
averagenesses1755016a__veragenesses_
conjugatenesses25132416conjugatenesses_
desperatenesses1863746desperatenesses_
eggheadednesses2262476egghe_adednesses_
gravenesses1548176__gr__avenesses_
greasinesses1347046__gre_asinesses_
intricatenesses1763316intricatenesses_
iratenesses11411446__ir__atenesses_
literatenesses1464786_literatenesses_
moderatenesses1764406_moderatenesses_
ornatenesses1257306__or_natenesses_
privatenesses1855346__privatenesses_
regalnesses1246196___rega_lnesses_
relatednesses1445006___relatednesses_
remotenesses1446816___remotenesses_
sedatenesses1346966___sedatenesses_
temperatenesses19113156temperatenesses_
abjectnesses2352567a_bje_ct_nesses_
abortivenesses1985297abor_tivenesses_
abrasivenesses19105557a_brasivenesses_
abruptnesses1652617a_br_upt_nesses_
absolutenesses1662407a_bsolutenesses_
acutenesses13126977a____cutenesses_
adeptnesses1444837a__de_pt_nesses_
adhesivenesses2155057a_dhesivenesses_
adorablenesses1755447ador_ablenesses_
adroitnesses1344137a_dr_oit_nesses_
adversarinesses1971507adversarinesses_
adversenesses1753397a_dve_rsenesses_
affectednesses2382607a_ffe_ctednesses_
agednesses1237417a_g_e___dnesses_
agelessnesses1387627a_g_elessnesses_
aggrandises1492767aggr__a__ndises_
aggregate1244207aggregat_____e__
aggregated1443717aggregat_____e_d
aggregately1751977aggregat_____ely
aggregating1343587aggregatin_____g
aggregations1553847aggregat___ions_
aggregative1753367aggregat___ive__
aggregatively2262137aggregat___ively
aggresses1146147aggr______esses_
aggressiveness1962667aggressivene_s_s_
agilenesses1247777a____gilenesses_
agreeableness1654107a_greeablene_s_s_
agribusinesses1751667a_gribusinesses_
airtightnesses1851847airtight_nesses_
alertnesses1147237a__le_rt_nesses_
almightinesses2051837a_lmightinesses_
ancientnesses1553287ancie_nt_nesses_
androgeneses1464327androg__ene_ses_
angiogeneses14123737angiog__ene_ses_
angrinesses1247287angr____inesses_
apartnesses1346827apar___t_nesses_
apparentnesses18121777appare_nt_nesses_
appositenesses1863717a_ppositenesses_
artinesses10815217a__r___tinesses_
assertivenesses1754937assertivenesses_
astutenesses1245597a___stutenesses_
augustnesses1352687aug__ust_nesses_
austerenesses1354177auste__renesses_
aversenesses1545667a__ve_rsenesses_
aversivenesses2056567aver_sivenesses_
awarenesses1447257a____warenesses_
awesomenesses1853387a__wesomenesses_
barefacednesses2381187_barefacednesses_
belatednesses1644337___belatednesses_
bravenesses1647957__br__avenesses_
breathinesses1853677__bre_athinesses_
brightnesses1844187__bright_nesses_
concretenesses1854167concre__tenesses_
correctnesses1754217corre_ct_nesses_
creakinesses1845997__cre_akinesses_
creaminesses1646137__cre_aminesses_
creativenesses1967037__cre_ativenesses_
currentnesses1552997curre_nt_nesses_
desolatenesses1553977_desolatenesses_
directednesses1863387_dire_ctednesses_
directnesses1595287_dire_ct_nesses_
discretenesses1753387discre__tenesses_
disparatenesses18122887disparatenesses_
dreaminesses1545717__dre_aminesses_
drearinesses1347447__dre_arinesses_
effetenesses1854527_effe__tenesses_
egregiousnesses1764267_egregiousnesses_
elaboratenesses1762047elaboratenesses_
elatednesses1346117____elatednesses_
erectnesses1347477__ere_ct_nesses_
extremenesses2252887extre__menesses_
femalenesses1746867___femalenesses_
forgivenesses2045847_for_givenesses_
fortunatenesses1862517fortunatenesses_
freakinesses1945597__fre_akinesses_
freenesses1339877__fre___enesses_
gamenesses1368987_____gamenesses_
gamesomenesses1962727_gamesomenesses_
gastightnesses19131827gastight_nesses_
gentlenesses1366017__g_entlenesses_
glegnesses1245077__gleg___nesses_
gorgeousnesses1655097_gorgeousnesses_
gracilenesses1655167__gracilenesses_
grandnesses1348117__gr__andnesses_
grapinesses1438577__gr__apinesses_
graynesses1436147__gr__a_ynesses_
greatness1036907__gre_at_ne_s_s_
greedinesses1446467__gre_edinesses_
greennesses1247037__gre__ennesses_
greynesses1446327__gre___ynesses_
grittinesses1345847__gr_ittinesses_
grogginesses1544077__grog_ginesses_
gruesomenesses1753077_gruesomenesses_
haggardnesses1952257hag__gardnesses_
hirsutenesses1653597_hir_sutenesses_
immediatenesses2062187immediatenesses_
imprecisenesses2161867imprecisenesses_
inanimatenesses1762747inanimatenesses_
inchoatenesses1953597_inchoatenesses_
innatenesses1247187___innatenesses_
insatiatenesses1593487insatiatenesses_
intimatenesses1655027_intimatenesses_
inviolatenesses1892807inviolatenesses_
jaggednesses2242797jagg_e___dnesses_
laggardnesses1652397lag__gardnesses_
largenesses1247557_lar_g__enesses_
latenesses10413367_____latenesses_
meatinesses13311987___me_atinesses_
neatnesses10310017___ne_at_nesses_
negativenesses1855857___negativenesses_
obduratenesses1752907_obduratenesses_
oblatenesses1475777___oblatenesses_
obstinatenesses1792627obstinatenesses_
overeagernesses1961797overeagernesses_
petitenesses14169367___petitenesses_
pigheadednesses23142947pighe_adednesses_
precisenesses1756287__precisenesses_
prematurenesses1971957__prematurenesses_
preparednesses1963097__preparednesses_
prettinesses1447547__pre_ttinesses_
profanenesses1853487__profanenesses_
proximatenesses2662147proximatenesses_
raggednesses1543867ragg_e___dnesses_
rarenesses10313117___r__arenesses_
readinesses12611277___re_adinesses_
realnesses10310857___re_a_lnesses_
regretfulnesses1963277regretfulnesses_
relaxednesses2152947___relaxednesses_
repletenesses1554497___repletenesses_
rightnesses1546237___right_nesses_
secretivenesses2055687secretivenesses_
separatenesses1654267_separatenesses_
serenenesses12117117_sere__nenesses_
streakinesses1743637_stre_akinesses_
supremenesses1753177supre__menesses_
sveltenesses1545237__sve_ltenesses_
sweatinesses1546917__swe_atinesses_
threadinesses1753347_thre_adinesses_
throatinesses1653277_thr_oatinesses_
tiresomenesses1653347_tiresomenesses_
tritenesses11710397__tr__itenesses_
ultimatenesses1652997_ultimatenesses_
unreadinesses1484587_unre_adinesses_
uprightnesses19122787_upright_nesses_
woebegonenesses216877woebegonenesses_

Search took 10 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.356501941.0
2DLD Change Limit950241708.81310782.3
3Display Results1701700.1431188.8
 (SQL Overall)1786911709.31219189.3
 
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.