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

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

127 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
fearfulness174522(None) 
tearfulness1445481tearfulness
fearfullest1752852fearfullest
fearfulnesses1945312fearfulnesses
wearifulness1854802wearifulness
artfulness1346403__artfulness
awfulness1544413__awfulness
carefulness1645953_carefulness
cheerfulness2053583cheerfulness
dreadfulness1763883dreadfulness
dreamfulness1853593dreamfulness
fatefulness1746013fatefulness
fearfuller1651803fearfulle_r
fearless1137873fear__l_ess
fitfulness1645733f_itfulness
fretfulness1776223fretfulness
harmfulness1984283_harmfulness
heedfulness18104073heedfulness
helpfulness1953483helpfulness
lawfulness1643853_lawfulness
manfulness1545643_manfulness
needfulness1593993needfulness
peacefulness1954983peacefulness
playfulness1953613playfulness
regardfulness1862893regardfulness
restfulness1447233restfulness
tearfulnesses1645533tearfulnesses
zestfulness2345313zestfulness
balefulness1645014balefulness
bashfulness1954224bashfulness
beardedness1544594beardedness
beardless1234914bear_dl_ess
bearishness1644544bearishness
beautifulness1853454beautifulness
boastfulness1754414boastfulness
colorfulness1753824colorfulness
deafness1236214dea_f__ness
dearness939974dear___ness
dolefulness1544884dolefulness
dutifulness1555084dutifulness
dwarfness1642794dwarf__ness
earfuls1036864_earful___s
earless74316074_ear__l_ess
earliness939694_ear_liness
earthiness1377244_earthiness
earthliness14144144_earthliness
earwitness1342624_earwitness
effortfulness18112414effortfulness
eventfulness1854644eventfulness
factualness1652994f_actualness
faithfulness2154224faithfulness
famousness1544944f_amousness
fancifulness2053754fancifulness
farness102912204f_ar___ness
fatalness1245774f_a_talness
fearful1345594fearful____
fearfully1843894fearful__ly
fearlessness1545764fearlessness
fearsomeness1753064fearsomeness
feastless1235044fea_stl_ess
fellness1135914fe___llness
fernless1136064fe_r_nl_ess
ferrules1136164fe_rrul_e_s
fertileness1447574fe_rtileness
ferules103112724fe_r_ul_e_s
fervidness1743594fe_rvidness
forcefulness2054454forcefulness
formalness1544834f_ormalness
foulness11236654f___oulness
frailness1236544f__railness
fruitfulness1854884fruitfulness
fulness10248964____fulness
gainfulness1544614gainfulness
gearless937374gear__l_ess
gleefulness1554064gleefulness
gracefulness1855244gracefulness
gratefulness1655744gratefulness
hatefulness1745964hatefulness
healthfulness2252904healthfulness
heartiness1338034hear_tiness
heartless1236394hear_tl_ess
hopefulness1954874hopefulness
hurtfulness1755014hurtfulness
jealousness1845324jealousness
joyfulness2343204_joyfulness
leafiness1236484lea_f_iness
leafless11246574lea_f_l_ess
learnedness1243864learnedness
lustfulness1445314lustfulness
mercifulness1964414mercifulness
mindfulness1754064mindfulness
mournfulness1753344mournfulness
nearness838314near___ness
painfulness1645084painfulness
peartness1137774pear__tness
pitifulness1665484pitifulness
prayerfulness2162684prayerfulness
pushfulness1954144pushfulness
realness8410444rea___lness
regretfulness1753874regretfulness
ruefulness1346104_ruefulness
ruthfulness1754984ruthfulness
scornfulness1753224scornfulness
searchless1543374searchl_ess
shamefulness2074154shamefulness
sinfulness1345844_sinfulness
songfulness1554584songfulness
soulfulness1444484soulfulness
sportfulness1754784sportfulness
tactfulness1645224tactfulness
teariness9310634tear__iness
tearless848714tear__l_ess
thankfulness2253394thankfulness
tunefulness1455244tunefulness
unlawfulness1852594unlawfulness
usefulness1345724_usefulness
vengefulness1953874vengefulness
wakefulness2154584wakefulness
wearifulnesses2054654wearifulnesses
weariless1234764wear_il_ess
weariness1238844wear__iness
willfulness1753514willfulness
wishfulness2054344wishfulness
wistfulness1745274wistfulness
woefulness1645264_woefulness
wrathfulness2154514wrathfulness
zealousness2055194zealousness

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 Filter1786911488190.420425454.8
2DLD Change Limit1488191279.31315979.7
3Display Results1271270.0632015.9
 (SQL Overall)1786911279.79618241.2
 
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.