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

112 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
painfulness164508(None) 
gainfulness1544611gainfulness
manfulness1545642ma_nfulness
painfullest1653172painfullest
painfulnesses18115132painfulnesses
sinfulness1345832_sinfulness
artfulness1346383_artfulness
awfulness1544413_a_wfulness
balefulness1645013balefulness
bashfulness1954213bashfulness
carefulness1645943carefulness
faithfulness2154213faithfulness
fatefulness1746003fatefulness
fitfulness1645713_fitfulness
gainfulnesses17124603gainfulnesses
harmfulness1984273harmfulness
hatefulness1745953hatefulness
lawfulness1643853la_wfulness
mindfulness1754053_mindfulness
painfuller1552203painfulle_r
painless10108343pain__l_ess
peacefulness1954983peacefulness
pitifulness1665463pitifulness
playfulness1953613playfulness
pridefulness1854313pridefulness
pushfulness1954123pushfulness
tactfulness1645203tactfulness
wakefulness2154583wakefulness
blissfulness1752634blissfulness
boastfulness1754394boastfulness
daintiness1145964dain_tiness
disdainfulness1991554disdainfulness
dolefulness1544874dolefulness
dutifulness1555064dutifulness
eventfulness1854634eventfulness
faintness1235834fain__tness
fancifulness2053754fancifulness
fearfulness1745214fearfulness
fretfulness1776204fretfulness
fruitfulness1854864fruitfulness
fulness10248964____fulness
gainless9117404gain__l_ess
gleefulness1554064gleefulness
gracefulness1855224gracefulness
gratefulness1655714gratefulness
guilefulness1653724guilefulness
heedfulness18104074heedfulness
heinousness1455584heinousness
helpfulness1953484helpfulness
hopefulness1954874hopefulness
hurtfulness1754994hurtfulness
joyfulness2343204_joyfulness
lustfulness1445294lustfulness
manfulnesses1745834ma_nfulnesses
manifoldness1851544manifoldness
meaningfulness2061344meaningfulness
mournfulness1753334mournfulness
needfulness1593994needfulness
ominousness1356084ominousness
pailfuls1343844pailful___s
painful1246404painful____
painfully1744184painful__ly
painkillers1761774painkillers
painlessness1445434painlessness
painterliness1572434painterliness
paneless102611764pa_n_el_ess
panfuls1237174pa_nful___s
paunchiness1842344paunchiness
pinkness1436514p_in__kness
pinnules1036464p_innul_e_s
piousness1147624p_i_ousness
plainness1155184plain___ness
plentifulness1893284plentifulness
pointedness1445094pointedness
pointless1135694poin_tl_ess
prayerfulness2162684prayerfulness
princeliness1653014princeliness
printless1137514prin_tl_ess
raininess949274rain__iness
rainless8129704rain__l_ess
restfulness1447214restfulness
ruefulness1346084_ruefulness
ruinousness1156364ruinousness
ruthfulness1754964ruthfulness
saintliness1144154saintliness
scornfulness1753214scornfulness
shamefulness2074144shamefulness
sinfulnesses1546124_sinfulnesses
skillfulness1952434skillfulness
songfulness1554574songfulness
soulfulness1444464soulfulness
spitefulness1754594spitefulness
sportfulness1754764sportfulness
taintless935734tain_tl_ess
tastefulness1554834tastefulness
tearfulness1445474tearfulness
thankfulness2253384thankfulness
tristfulness1564964tristfulness
tunefulness1455224tunefulness
usefulness1345704_usefulness
vainness1136064vain___ness
voicefulness2053644voicefulness
wastefulness1854814wastefulness
watchfulness2353074watchfulness
wearifulness1854794wearifulness
willfulness1753504willfulness
wishfulness2054324wishfulness
wistfulness1745254wistfulness
woefulness1645264_woefulness
wrathfulness2154494wrathfulness
wrongfulness1953244wrongfulness
zestfulness2345294zestfulness

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.1701051123.5
2DLD Change Limit1488191129.03316475.0
3Display Results1121120.0601866.7
 (SQL Overall)1786911129.26319290.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.