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

251 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
essentialnesses1462641essentialnesses_
essentialness1363263essentialne_s_s_
assertivenesses1754935assertivenesses_
effectualnesses2391815effectualnesses_
essentialisms1563275essential__isms_
essentialists1363065essential__ists_
essentialities1473245essential_ities_
essentializes2263485essential__izes_
eventfulnesses2054275e_ventfulnesses_
identicalnesses1882425_identicalnesses_
resentfulnesses1883745resentfulnesses_
specialnesses1753865_spe_cialnesses_
venialnesses1555705__ven_ialnesses_
attentivenesses1874696attentivenesses_
colonialnesses1653056colon_ialnesses_
effectivenesses2665106effectivenesses_
electivenesses1957646e_lectivenesses_
entirenesses1249666___entirenesses_
essentialism1463396essential____ism
essentialist1263876essential____ist
essentialize2163766essential__ize__
essentialized2363266essential__ize_d
essentials1054586essential_____s_
eternalnesses1353696e_te_rnalnesses_
etherealnesses1762316ethe_realnesses_
expensivenesses27105496expensivenesses_
extensivenesses2595286extensivenesses_
genteelnesses1453536__genteelnesses_
gentilesses1243496__genti_l_esses_
initialnesses1395616__initialnesses_
inventivenesses21136256inventivenesses_
materialnesses1653916mate_rialnesses_
neutralnesses1354356__neutralnesses_
palatialnesses1653396_palatialnesses_
plentifulnesses2093176_plentifulnesses_
poeticalnesses1853106_poe_ticalnesses_
retentivenesses1896406retentivenesses_
scantinesses1437316_scanti__nesses_
selectivenesses2056006selectivenesses_
sensiblenesses1555256__sensiblenesses_
stillnesses1146736__s__tillnesses_
sweatinesses1546916_sweati__nesses_
verticalnesses1953676__verticalnesses_
acceptingnesses2261517acceptingnesses_
assertiveness1655507assertivene_s_s_
bountifulnesses2073197_bountifulnesses_
bustinesses131310107bus__ti__nesses_
casualnesses1443787cas___ualnesses_
cordialnesses1654577__cordialnesses_
costivenesses1848167cos__tivenesses_
creativenesses1967037_creativenesses_
criticalnesses1853157__criticalnesses_
daintinesses1346247_dainti__nesses_
deceitfulnesses2173047deceitfulnesses_
deceptivenesses23125897deceptivenesses_
defectivenesses2496077defectivenesses_
defensivenesses2255787defensivenesses_
dementednesses1853817dement_ednesses_
dismalnesses1553987dis___malnesses_
dustinesses121110357dus__ti__nesses_
easinesses10314447eas___i__nesses_
easygoingnesses20101077easygoingnesses_
eerinesses10612607e__e_ri__nesses_
effectualness2171937effectualne_s_s_
effetenesses1854527effe_t__enesses_
effortfulnesses20112187effortfulnesses_
elderlinesses1453267elderli__nesses_
emptinesses1545997e__mpti__nesses_
enviablenesses1965927___enviablenesses_
equivocalnesses2971217equivocalnesses_
erectnesses1347477e_rect___nesses_
essential946087essential_______
essentiality1563507essential____ity
essentializing2462897essential__izing
essentially1455127essential_____ly
estimablenesses1954097e_s__timablenesses_
ethicalnesses1853207e__thicalnesses_
evennesses1345947e_ven____nesses_
eventfulness1854647e_ventfulne_s_s_
everydaynesses246837e_verydaynesses_
evilnesses1346007___e_vi_lnesses_
evocativenesses2364347evocativenesses_
exactingnesses2452667e_xactingnesses_
excessivenesses2675147excessivenesses_
exoticnesses2142687e__xoti_cnesses_
expansivenesses2794527expansivenesses_
expectednesses2662957expect_ednesses_
expertnesses2144847expert___nesses_
extendednesses2362657exten_dednesses_
eyewitnesses1852117e_ye_wi_tnesses_
factualnesses1853697__factualnesses_
faintishnesses2053307_faintishnesses_
fanaticalnesses2082317_fanaticalnesses_
fatalnesses1456287___fat_alnesses_
feistinesses1555897feis__ti__nesses_
fertilenesses1648037__fertilenesses_
festivenesses1998437__festivenesses_
fetidnesses1546657__fe_ti_dnesses_
fiendishnesses2172477_fiendishnesses_
finicalnesses1853837__finicalnesses_
fleetingnesses1872807_fleetingnesses_
flintinesses1546327_flinti__nesses_
franticnesses1843677_franti_cnesses_
fretfulnesses1945907_fre_tfulnesses_
fustinesses14129787fus__ti__nesses_
gentilesse1142547__genti_l_esse__
gentlenesses1366017__gent_lenesses_
genuinenesses1475307__genuinenesses_
greenishnesses1882967green_ishnesses_
greensicknesses2261477greensicknesses_
gustinesses12139537gus__ti__nesses_
habitualnesses1962217_habitualnesses_
hastinesses141210697has__ti__nesses_
heavenlinesses2051807heavenli__nesses_
heftinesses1737137__hefti__nesses_
identicalness1662667_identicalne_s_s_
insatiatenesses1593487ins_atiatenesses_
intensivenesses1856287intensivenesses_
intentnesses1277127intent___nesses_
invectivenesses23106017invectivenesses_
ironicalnesses1662587_ironicalnesses_
jauntinesses1944687_jaunti__nesses_
jettinesses1836387__jetti__nesses_
lastingnesses1444137las__tingnesses_
liberalnesses1554267libe__ralnesses_
literalnesses1355247lite__ralnesses_
lustfulnesses1655157lus__tfulnesses_
lustinesses11910427lus__ti__nesses_
meatinesses13311987__meati__nesses_
mentaleses1245957__ment_al_e_ses_
mercurialnesses1981437mercurialnesses_
messinesses1297517mess___i__nesses_
miserlinesses1554667miserli__nesses_
mistinesses131310627mis__ti__nesses_
momentarinesses1972347momentarinesses_
momentousnesses1963597momentousnesses_
mustinesses131010417mus__ti__nesses_
nastinesses111110747nas__ti__nesses_
objectivenesses2994477objectivenesses_
obsessivenesses18104447obsessivenesses_
offensivenesses2464577offensivenesses_
pastinesses13911727pas__ti__nesses_
pastoralnesses1653137pas_toralnesses_
pensivenesses1849027__pensivenesses_
petitenesses14169367__pe_titenesses_
pettinesses1338637__petti__nesses_
pettishnesses1844387__pettishnesses_
pictorialnesses1962147pictorialnesses_
plaintivenesses2054317plaintivenesses_
positivenesses1965977pos_itivenesses_
practicalnesses2162957_practicalnesses_
presentnesses1554427present___nesses_
prettinesses1447547_pretti__nesses_
queenlinesses2252297queenli__nesses_
realnesses10310857__re___alnesses_
recentnesses1465377recent___nesses_
receptivenesses22106057receptivenesses_
regalnesses1246197__re__galnesses_
regretfulnesses1963277regre_tfulnesses_
resentfulness1664797resentfulne_s_s_
resistivenesses1755767resistivenesses_
restfulnesses1646627__restfulnesses_
restivenesses1679447__restivenesses_
runtinesses111210967__runti__nesses_
rustinesses11911567rus__ti__nesses_
saintlinesses1344367_saint_linesses_
saltinesses11311457__salti__nesses_
sandinesses12911397__sandi__nesses_
scantnesses1376537_scant___nesses_
seaminesses13310757__seami__nesses_
seasicknesses1873077__seasicknesses_
secretivenesses2055687secretivenesses_
seductivenesses21145477seductivenesses_
seedinesses1259207__seedi__nesses_
seemlinesses1445227_seemli__nesses_
selectnesses1446117select___nesses_
selfishnesses1844047__selfishnesses_
sensitivenesses1775357sensitivenesses_
serenenesses12117117seren___enesses_
serriednesses1454277__serriednesses_
servilenesses1646307__servilenesses_
sexinesses1739217__se_xi__nesses_
sheepishnesses2153017_sheepishnesses_
shiftinesses18105247_shifti__nesses_
shininesses1448307_shin_i__nesses_
shrillnesses1543507__s_hrillnesses_
silentnesses1275447silent___nesses_
sinfulnesses1546137__sin_fulnesses_
sketchinesses2251887_ske_tchinesses_
skinninesses1643477_skinni__nesses_
skittishnesses2052397_skittishnesses_
slanginesses1346967_slangi__nesses_
slatinesses11311637__slati__nesses_
sleazinesses2145377_sleazi__nesses_
sleepinesses1445677_sleepi__nesses_
slendernesses1453137_slen_dernesses_
slinkinesses1645817_slinki__nesses_
sluttishnesses1652687_sluttishnesses_
smuttinesses14135087_smutti__nesses_
sneakinesses1645907_sneaki__nesses_
snidenesses1248657__s_n_idenesses_
snootinesses1265807_snooti__nesses_
snottinesses1255847_snotti__nesses_
songfulnesses1754677__songfulnesses_
sootinesses11410057__sooti__nesses_
sottishnesses1544457__sottishnesses_
specialness1554057_spe_cialne_s_s_
speedinesses1545597_speedi__nesses_
spininesses1358457_spin_i__nesses_
spiritualnesses1782137spiritualnesses_
splendidnesses1871717splendi_dnesses_
sponginesses1544777_spongi__nesses_
sportfulnesses1964177_sportfulnesses_
sportinesses1447877_sporti__nesses_
sportivenesses1956287_sportivenesses_
spottinesses1445687_spotti__nesses_
spunkinesses1844387_spunki__nesses_
staidnesses1237197__s__taidnesses_
stainlesses1144177__s__tainlesses_
stalenesses11311107__s__t_alenesses_
steadinesses1346907_steadi__nesses_
steaminesses1446227_steami__nesses_
steelinesses1246727_steeli__nesses_
sterlingnesses1553147_sterlingnesses_
stiffnesses1743597__s__tiffnesses_
stinginesses1375967_stingi__nesses_
stoninesses1138257_ston_i__nesses_
stuntednesses1453937_stunt_ednesses_
subtilenesses1585067__subtilenesses_
sultanesses1145567__sult_a_nesses_
sunninesses11148387__sunni__nesses_
sveltenesses1545237_svelt__enesses_
swankinesses1944787_swanki__nesses_
sweepingnesses2052067_sweepingnesses_
sweetnesses1445727_sweet___nesses_
swinishnesses1843657_swin_ishnesses_
tastinesses111110787tas__ti__nesses_
testinesses111210327__testi__nesses_
trendinesses1346327_trendi__nesses_
uncertainnesses1781357uncertainnesses_
unselfishnesses2061517unselfishnesses_
unsettlednesses16102207unsettlednesses_
untidinesses1345917___untidinesses_
usefulnesses1545827_use__fulnesses_
usualnesses1144697_us___ualnesses_
venialness1344607__ven_ialne_s_s_
versatilenesses1853647vers_atilenesses_
vitalnesses1456277___vit_alnesses_
wistfulnesses1955547wis__tfulnesses_
yeastinesses1545567yeas__ti__nesses_
zestfulnesses2555007__zestfulnesses_

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.393454684.5
2DLD Change Limit950242518.48311201.7
3Display Results2512510.2201140.9
 (SQL Overall)1786912519.09619645.0
 
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.