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

162 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
opportunenesses196142(None) 
opportuneness17111802opportunene_s_s
inopportuneness1971014inopportunene_s_s
oppositenesses1854204oppo_sitenesses
sportivenesses1956284_sportivenesses
abortivenesses1985295_abortivenesses
apparentnesses18121775appar_entnesses
appositenesses1863715appo_sitenesses
fortunatenesses1862515__fortunatenesses
obtusenesses1445065___obtusenesses
odorousnesses1456735o_dorou_snesses
opaquenesses2352965o_p_aqu_enesses
operativenesses2055775operativenesses
operosenesses1575325o_per_osenesses
opportunisms1861535opportu__n_isms
opportunists1661885opportu__n_ists
opportunities1771855opportu__nities
porousnesses1469285__porou_snesses
porteresses1345525__port__eresses
portlinesses1446995__port_linesses
profanenesses1853485_pro_fanenesses
profoundnesses2061495_profoundnesses
profusenesses18113875_pro_fusenesses
pronenesses1379265__p_r_onenesses
rotundnesses1343825__ro_tundnesses
sportfulnesses1964175_sportfulnesses
sportinesses1447875_sport__inesses
sprucenesses1694615_sp_r_ucenesses
vaporousnesses1956005vaporou_snesses
absolutenesses1662406abso_lutenesses
abstrusenesses1552566abstr_usenesses
adorablenesses1755446_adorablenesses
alonenesses1147216_alo___nenesses
amorousnesses1547816_amorou_snesses
apartnesses1346826_apart___nesses
assertivenesses1754936assertivenesses
astutenesses1245596___astutenesses
boringnesses15105026__bor_ingnesses
boundnesses1446626__bo__undnesses
canorousnesses16127066canorou_snesses
colorfulnesses1993836colorfu_lnesses
completenesses2053996complet__enesses
copiousnesses1747806copio__u_snesses
corninesses13410596__cor__ninesses
corporealnesses1961886corpor_ealnesses
corruptnesses1752846__corruptnesses
costivenesses1848166__costivenesses
crudenesses1476656___cr_udenesses
decorousnesses1756566decorou_snesses
destitutenesses1662676destitutenesses
dolorousnesses1555786dolorou_snesses
donenesses11310566__do___nenesses
effortfulnesses20112186effortfulnesses
expertnesses2144846expert___nesses
favorablenesses2354126favorablenesses
fertilenesses1648036__fertilenesses
forgivenesses2045846__forgivenesses
forlornnesses1652576forlor__n_nesses
furtivenesses1947236__furtivenesses
gonenesses11310256__go___nenesses
hirsutenesses1653596__hirsutenesses
honorablenesses2064206honorablenesses
hornednesses1645516__hor__nednesses
horninesses1459006__hor__ninesses
humorousnesses1955446humorou_snesses
ignorantnesses1562216ignor_antnesses
impolitenesses1853956impo_litenesses
importunateness1971406importunatene_s_s
impurenesses16164436imp___urenesses
incorruptnesses19101376incorruptnesses
jejunenesses1852626___jejunenesses
lonenesses10311346__lo___nenesses
lornnesses1037826__lor__n_nesses
memorablenesses2154836memorablenesses
morenesses12811396__mor___enesses
morosenesses1446866__mor_osenesses
obduratenesses1752906obdur_atenesses
objectivenesses2994476objectivenesses
oblatenesses1475776o_blat__enesses
obliquenesses2452206o_bliqu_enesses
obscurenesses1752736o__bscurenesses
obsoletenesses1662226obso_letenesses
odiousnesses1347996odio__u_snesses
onenesses9311826___o___nenesses
onerousnesses1348976o_nerou_snesses
ongoingnesses1583106ongo__ingnesses
opennesses1246316o_p___en_nesses
opponencies1752696oppo___nen_cies
opportune1352996opportu__n___e_
opportunely1861646opportu__ne__ly
opportunism1761786opportu__n_is_m
opportunist1562626opportu__n_is_t
opportunistic1971366opportu__nistic
oppositeness1653436oppo_sitene_s_s
oppresses1346876opp_r_____esses
ornatenesses1257306___ornatenesses
otiosenesses1245706otio___senesses
overtnesses1448716o_vert___nesses
peartnesses1338746_peart___nesses
pertnesses12310316__pert___nesses
petitenesses14169366__p_etitenesses
phoninesses1636456_pho___ninesses
piousnesses1348986_pio__u_snesses
planenesses1349036__p__lanenesses
politenesses1448596__po_litenesses
pompousnesses1955466pompo__u_snesses
poornesses1236806_poor____nesses
populousnesses1864746populou_snesses
porkinesses1748776__por__kinesses
portresses1247316__port___resses
positivenesses1965976_positivenesses
potablenesses1746506__potablenesses
pottinesses1339106__po_t_tinesses
prematurenesses1971956prematurenesses
primenesses1548996__p_r_imenesses
promotivenesses22113896_promotivenesses
proudnesses1447506__p_rou_dnesses
provablenesses2154896_provablenesses
puninesses121110756__p___uninesses
punitivenesses1965656_punitivenesses
purenesses12810746__p___urenesses
remotenesses1446816remo_t__enesses
repletenesses1554496replet__enesses
resolutenesses1493496reso_lutenesses
rigorousnesses1565856rigorou_snesses
rottennesses1244426__rotten_nesses
roundnesses1247046____roundnesses
rudenesses1188876____r_udenesses
separablenesses1954786separablenesses
separatenesses1654266separ_atenesses
serenenesses12117116__ser_enenesses
shortnesses1446796_short___nesses
sonorousnesses1356516sonorou_snesses
sorenesses101313496__sor___enesses
soundnesses1247526__so__undnesses
sparenesses1339176_spar___enesses
sparsenesses1345806_spar__senesses
spiritualnesses1782136spiritualnesses
sporogeneses1554856_spor_ogene_ses
sportiveness1766986_sportivene_s_s
spottinesses1445686_spo_t_tinesses
superablenesses1964906superablenesses
supinenesses1446016sup___inenesses
supportiveness2162676supportivene_s_s
supremenesses1753176sup_r_emenesses
thorninesses1544396_thor__ninesses
thoroughnesses2171876_thoroughnesses
timorousnesses1655696timorou_snesses
toploftinesses1951276toploft__inesses
tortuousnesses1455766__tortuousnesses
truenesses1039316___tr_u_enesses
unsoundnesses1453286unso__undnesses
unworthinesses2052676unwort_hinesses
uppitinesses16103706upp_it__inesses
uppitynesses19101936upp_it__ynesses
uprootednesses1752346uproot_ednesses
vaporishnesses2252236vapor_ishnesses
vigorousnesses1865526vigorou_snesses
votivenesses1847586__vo_tivenesses
wornnesses1337136__wor__n_nesses
worthinesses1845766__wort_hinesses
youngnesses1544286__yo__ungnesses

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 Filter178691950240.1261418182.5
2DLD Change Limit950241627.11013364.8
3Display Results1621620.1101472.7
 (SQL Overall)1786911627.34624324.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.