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

135 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
effectualnesses2391811effectualnesses_
effectualness2171933effectualne_s_s_
effectivenesses2665104effectivenesses_
factualnesses1853694__factualnesses_
affectednesses2382605affect_ednesses_
effectualities2262205effectual_ities_
effetenesses1854525effe_t__enesses_
effortfulnesses20112185effortfulnesses_
essentialnesses1462645essentialnesses_
ineffectualness23131305ineffectualne_s_s_
affectlessness2271916affect__l_essness
defectivenesses2496076defectivenesses_
effectiveness2455676effectivene_s_s_
effectuates1952536effectua____tes_
electivenesses1957646e_lectivenesses_
erectnesses1347476e_rect___nesses_
eternalnesses1353696e_te_rnalnesses_
etherealnesses1762316ethe_realnesses_
ethicalnesses1853206ethic__alnesses_
eventfulnesses2054276e_ventfulnesses_
expectednesses2662956expect_ednesses_
factualness1652996__factualne_s_s_
fatalnesses1456286__f_at_alnesses_
fretfulnesses1945906_fre_tfulnesses_
habitualnesses1962216_habitualnesses_
neutralnesses1354356__neutralnesses_
perfectnesses2053356perfect___nesses_
specialnesses1753866_spec_ialnesses_
spiritualnesses1782136spiritualnesses_
abjectnesses2352567abject___nesses_
affectedness2153207affect_edne_s_s_
affectionless2161877affectionle_s_s_
affectless1842137affect__l_e_s_s_
awfulnesses1744947awf___u_lnesses_
balefulnesses1844857bale_fu_lnesses_
carefulnesses1845697care_fu_lnesses_
casualnesses1443787___casualnesses_
cheerfulnesses2253387cheerfu_lnesses_
cruelnesses1346257____cruelnesses_
deceitfulnesses2173047deceitfulnesses_
dejectednesses2553077deject_ednesses_
directednesses1863387direct_ednesses_
directnesses1595287direct___nesses_
dolefulnesses1774847dole_fu_lnesses_
effectual1752767effectual_______
effectuality2382317effectual____ity
effectually2252657effectual_____ly
effectuate1852587effectua____te__
effectuated2051997effectua____te_d
effectuations2151957effectua__tions_
effeteness1643677effe_t__ene_s_s_
effortfulness18112417effortfulne_s_s_
effortlessness2061897effort__l_essness
effusivenesses2355747eff_usivenesses_
electresses1345967e_lect___resses_
equivocalnesses2971217equivocalnesses_
essentialness1363267essentialne_s_s_
everydaynesses246837e_verydaynesses_
exactingnesses2452667e_xactingnesses_
exactnesses2044347e_xact___nesses_
execrablenesses2674207e_xecrablenesses_
expertnesses2144847expert___nesses_
fanaticalnesses2082317_fanaticalnesses_
fancifulnesses2254007_fancifulnesses_
fatefulnesses1945997_fatefu_lnesses_
fearfulnesses1945317__fearfulnesses_
fellnesses1346087__fe___llnesses_
femalenesses1746867__fe__malenesses_
fertilenesses1648037__fertilenesses_
festivenesses1998437__festivenesses_
fetidnesses1546657__fe_t_idnesses_
fictivenesses2157127__fictivenesses_
finicalnesses1853837__finicalnesses_
fitfulnesses1866027__f_itfulnesses_
fleetingnesses1872807_fleetingnesses_
fleetnesses1445487_fleet___nesses_
forcefulnesses2254177_forcefulnesses_
formalnesses1744487__f_ormalnesses_
foulnesses1337937__f__ou_lnesses_
fruitfulnesses2094637_fruitfulnesses_
fullnesses1336217__f___ullnesses_
fulnesses1239057__f___u_lnesses_
genteelnesses1453537__genteelnesses_
gleefulnesses1764257_gleefu_lnesses_
gracefulnesses20154917gracefu_lnesses_
gradualnesses1552887__gradualnesses_
hatefulnesses1945807hate_fu_lnesses_
heedfulnesses20124107_heedfu_lnesses_
hopefulnesses2184597hope_fu_lnesses_
identicalnesses1882427_identicalnesses_
initialnesses1395617__initialnesses_
insecurenesses1662967insec_urenesses_
invectivenesses23106017invectivenesses_
liberalnesses1554267libe__ralnesses_
literalnesses1355247lite__ralnesses_
localnesses1345857__loc__alnesses_
logicalnesses1653197logic__alnesses_
lyricalnesses1853107lyric__alnesses_
materialnesses1653917mate_rialnesses_
naturalnesses1354257___naturalnesses_
needfulnesses17134097_needfu_lnesses_
objectivenesses2994477objectivenesses_
offensivenesses2464577offensivenesses_
officialeses2061147offic_ial_e_ses_
officiousnesses2364297officiousnesses_
palatialnesses1653387_palatialnesses_
peacefulnesses2154707peace_fu_lnesses_
poeticalnesses1853107_poeticalnesses_
practicalnesses2162957_practicalnesses_
radicalnesses16124147radic__alnesses_
realnesses10310857__re___alnesses_
regalnesses1246197__re__galnesses_
regretfulnesses1963277regre_tfulnesses_
resentfulnesses1883747resentfulnesses_
restfulnesses1646627__restfulnesses_
ruefulnesses1545937_rue_fu_lnesses_
securenesses1445677__sec_urenesses_
selectivenesses2056007selectivenesses_
selectnesses1446117select___nesses_
tactfulnesses1855267__tactfulnesses_
tunefulnesses1655137tune_fu_lnesses_
typicalnesses2062547typic__alnesses_
unnaturalnesses1561667_unnaturalnesses_
unusualnesses1353077__unusualnesses_
usefulnesses1545827_use_fu_lnesses_
usualnesses1144697____usualnesses_
vengefulnesses2153657venge_fu_lnesses_
venialnesses1555707__ve_nialnesses_
verticalnesses1953677__verticalnesses_
vitalnesses1456277___vit_alnesses_
vocalnesses1645097__voc__alnesses_
voicefulnesses2253577voicefu_lnesses_
wakefulnesses2354297wake_fu_lnesses_
woefulnesses1845347_woe_fu_lnesses_
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.420425454.8
2DLD Change Limit950241359.26610255.1
3Display Results1351350.0931451.6
 (SQL Overall)1786911359.77918272.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.