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

119 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
carefulness164595(None) 
artfulness1346402_artfulness
balefulness1645012balefulness
carefullest1653212carefullest
carefulnesses1845692carefulnesses
fatefulness1746012fatefulness
harmfulness1984282harmfulness
hatefulness1745962hatefulness
wakefulness2154582wakefulness
awfulness1544413_a_wfulness
bashfulness1954223bashfulness
carefuller1542713carefulle_r
careless102813633care__l_ess
changefulness2262553changefulness
cheerfulness2053583cheerfulness
dolefulness1544883dolefulness
fearfulness1745223fear_fulness
forcefulness2054453forcefulness
fretfulness1776223_fretfulness
gainfulness1544613gainfulness
gleefulness1554063gleefulness
gracefulness1855243gracefulness
gratefulness1655743gratefulness
hopefulness1954873hopefulness
hurtfulness1755013hurtfulness
lawfulness1643853la_wfulness
manfulness1545643ma_nfulness
painfulness1645083painfulness
peacefulness1954983peacefulness
ruefulness1346103_ruefulness
scornfulness1753223scornfulness
shamefulness2074153shamefulness
tactfulness1645223tactfulness
tastefulness1554853tastefulness
tearfulness1445483tear_fulness
tunefulness1455243tunefulness
usefulness1345723_usefulness
wastefulness1854833wastefulness
wearifulness1854803wearifulness
woefulness1645263_woefulness
artfulnesses1546644_artfulnesses
balefulnesses1844854balefulnesses
bareness10912814bare___ness
boastfulness1754414boastfulness
cagefuls1484344cageful___s
cageyness1543484cage__yness
callousness1345824callousness
carbonless1444084carbonl_ess
careeners1138544care__eners
careful1249114careful____
carefully1745084careful__ly
carelessness1446544carelessness
carfuls1249134car_ful___s
carless95118494car___l_ess
casualness1243224ca_sualness
colorfulness1753824colorfulness
cordialness1444774cordialness
coreless103013834core__l_ess
craftiness1545754c_raftiness
creakiness1645964c_reakiness
creaminess1446204c_reaminess
creepiness1444884c_reepiness
crestless1146784c_restl_ess
crewless1335414c_re_wl_ess
cruelness1145054c_r_uelness
cureless10319704cure__l_ess
curiousness1348984curiousness
dreadfulness1763884_dreadfulness
dreamfulness1853594_dreamfulness
dutifulness1555084dutifulness
faithfulness2154224faithfulness
fancifulness2053754fancifulness
fatefulnesses1945994fatefulnesses
fitfulness1645734_fitfulness
forgetfulness2053744forgetfulness
fulness10248964____fulness
gaseousness1246054gaseousness
guilefulness1653724guilefulness
harmfulnesses2164304harmfulnesses
hatefulnesses1945804hatefulnesses
heedfulness18104074heedfulness
helpfulness1953484helpfulness
joyfulness2343204_joyfulness
lustfulness1445314lustfulness
masterfulness1853514masterfulness
mercifulness1964414mercifulness
mindfulness1754064mindfulness
mirthfulness2053744mirthfulness
mournfulness1753344mournfulness
needfulness1593994needfulness
parentless1244454parentl_ess
pitifulness1665484pitifulness
playfulness1953614playfulness
prayerfulness2162684prayerfulness
pridefulness1854324pridefulness
pushfulness1954144pushfulness
rareness81112854rare___ness
realness8410444__re_alness
regalness1045474__regalness
regardfulness1862894regardfulness
regretfulness1753874regretfulness
restfulness1447234restfulness
ruthfulness1754984ruthfulness
sinfulness1345844_sinfulness
songfulness1554584songfulness
soulfulness1444484soulfulness
spitefulness1754604spitefulness
sportfulness1754784sportfulness
thankfulness2253394thankfulness
variousness1448504variousness
vengefulness1953874vengefulness
voicefulness2053644voicefulness
wakefulnesses2354294wakefulnesses
watchfulness2353084watchfulness
willfulness1753514willfulness
wishfulness2054344wishfulness
wistfulness1745274wistfulness
wrathfulness2154514wrathfulness
zestfulness2345314zestfulness

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.486367677.0
2DLD Change Limit1488191198.98316566.7
3Display Results1191190.0631888.9
 (SQL Overall)1786911199.53218746.4
 
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.