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

110 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
wistfulness174527(None) 
wishfulness2054341wishfulness
fitfulness1645732fi_tfulness
lustfulness1445312lustfulness
restfulness1447232restfulness
tristfulness1564982tristfulness
wastefulness1854832wastefulness
willfulness1753512willfulness
wistfulnesses1955542wistfulnesses
zestfulness2345312zestfulness
artfulness1346403_artfulness
bashfulness1954223bashfulness
blissfulness1752653blissfulness
boastfulness1754413boastfulness
fretfulness1776223fretfulness
hurtfulness1755013hurtfulness
mindfulness1754063mindfulness
mirthfulness2053743mirthfulness
pitifulness1665483pitifulness
pushfulness1954143pushfulness
rightfulness1994893rightfulness
sinfulness1345843si_nfulness
tactfulness1645223tactfulness
tastefulness1554853tastefulness
trustfulness1565063trustfulness
usefulness1345723_usefulness
wakefulness2154583wakefulness
wishfulnesses2254283wishfulnesses
woefulness1645263w_oefulness
wrathfulness2154513wrathfulness
awfulness1544414__awfulness
balefulness1645014balefulness
carefulness1645954carefulness
dismalness1344044dis_malness
distantness1254334distantness
dolefulness1544884dolefulness
doubtfulness1853684doubtfulness
dutifulness1555084dutifulness
eventfulness1854644eventfulness
faithfulness2154224faithfulness
fatefulness1746014fatefulness
fearfulness1745224fearfulness
fistfuls1454564fistful___s
fitfulnesses1866024fi_tfulnesses
frightfulness2363204frightfulness
fruitfulness1854884fruitfulness
fulness10248964____fulness
gainfulness1544614gainfulness
gleefulness1554064gleefulness
gratefulness1655744gratefulness
guilefulness1653724guilefulness
harmfulness1984284harmfulness
hatefulness1745964hatefulness
heedfulness18104074heedfulness
helpfulness1953484helpfulness
hopefulness1954874hopefulness
joyfulness2343204_joyfulness
kistfuls1553834kistful___s
lawfulness1643854_lawfulness
listless8269264list__l_ess
lustfulnesses1655154lustfulnesses
manfulness1545644_manfulness
masterfulness1853514masterfulness
mistiness111911634mist__iness
mistunes10311134mist_u_ne_s
needfulness1593994needfulness
painfulness1645084painfulness
playfulness1953614playfulness
pridefulness1854324pridefulness
resentfulness1664794resentfulness
restfullest1454134restfullest
restfulnesses1646624restfulnesses
riotousness1156934riotousness
ruefulness1346104_ruefulness
ruthfulness1754984ruthfulness
skillfulness1952444skillfulness
slothfulness1853504slothfulness
songfulness1554584songfulness
soulfulness1444484soulfulness
spitefulness1754604spitefulness
sportfulness1754784sportfulness
stillness936104__stillness
stoutness945864__stoutness
tearfulness1445484tearfulness
tristfulnesses1774334tristfulnesses
truthfulness1864414truthfulness
tunefulness1455244tunefulness
viscousness1655534viscousness
vistaless1254574vist_al_ess
vitalness1245414vi_t_alness
voicefulness2053644voicefulness
waistless1235094waist__l_ess
wastefulnesses2054524wastefulnesses
watchfulness2353084watchfulness
wearifulness1854804wearifulness
wifeless14277484wi__fel_ess
wifeliness1644484wi__feliness
willfulnesses1953884willfulnesses
wintriness1345544wint_riness
wiseness112010754wis___eness
wishless1435994wis__hl_ess
wispiness1435634wis__piness
wistful1365714wistful____
wistfully1844214wistful__ly
witless103310984wi_t__l_ess
witness103010014wi_t___ness
wittiness12197224wi_t_tiness
wrongfulness1953254wrongfulness
youthfulness2153644youthfulness
zestfulnesses2555004zestfulnesses

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.436409841.7
2DLD Change Limit1488191108.55017405.7
3Display Results1101100.0601833.3
 (SQL Overall)1786911109.04619753.6
 
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.