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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

69 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
resourcefulness207152(None) 
remorsefulness1962173remo_rsefulness
forcefulness2054454__fo_rcefulness
reposefulness1862814repo__sefulness
resourceful1661054resourceful____
resourcefully2171044resourceful__ly
respectfulness2163274res_pectfulness
despitefulness2062545des_pitefulness
disgracefulness2271675disgracefulness
mercifulness1964415me___rcifulness
mournfulness1753345__mour_nfulness
peacefulness1954985pe___acefulness
regardfulness1862895re_gar_dfulness
regretfulness1753875re__gretfulness
reproachfulness2591165reproachfulness
resentfulness1664795res__entfulness
restfulness1447235res____tfulness
revengefulness2161825re_vengefulness
ruefulness1346105r___u__efulness
sorrowfulness1962225__sorrowfulness
soulfulness1444485__sou__lfulness
sourceless1273015__source__l_ess
voicefulness2053645__vo_icefulness
beautifulness1853456be_au_tifulness
bountifulness1853156__bountifulness
carefulness1645956___car_efulness
colorfulness1753826colo_r__fulness
courteousness1554616__courteousness
distastefulness1971796distastefulness
distrustfulness19132346distrustfulness
dolefulness1544886__do__lefulness
doubtfulness1853686__dou_btfulness
effortfulness18112416_effor_tfulness
fearfulness1745226fe__ar__fulness
forcefulnesses2254176__fo_rcefulnesses
forgetfulness2053746__fo_rgetfulness
gracefulness1855246___gracefulness
guilefulness1653726___guilefulness
hopefulness1954876__ho__pefulness
hurtfulness1755016___hur_tfulness
masterfulness1853516master__fulness
mistrustfulness20141906mistrustfulness
neglectfulness2082086ne_glectfulness
pressureless1452156pressur_e__l_ess
remorseless1371966remo_rse__l_ess
reposefulnesses2062576repo__sefulnesses
reservedness1653496res_erve__dness
resoluteness1253676resolute___ness
resources1146206resourc_____e_s
ruthfulness1754986r___u_thfulness
scornfulness1753226__scor_nfulness
shamefulness2074156__s_hamefulness
songfulness1554586__so__ngfulness
sourceful1452356__sourceful____
spitefulness1754606__s_pitefulness
sportfulness1754786__spor_tfulness
successfulness2081486__s_uccessfulness
suspensefulness19111436suspensefulness
tastefulness1554856tas___tefulness
tearfulness1445486te__ar__fulness
thoughtfulness2481626_thoughtfulness
tunefulness1455246___tu_nefulness
usefulness1345726____u_sefulness
vengefulness1953876ve___ngefulness
wastefulness1854836was___tefulness
wearifulness1854806we__ar_ifulness
woefulness1645266__wo___efulness
youthfulness2153646__you_thfulness
zestfulness2345316zes____tfulness

Search took 8 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.376475242.0
2DLD Change Limit95024697.21613168.5
3Display Results69690.0461500.0
 (SQL Overall)178691697.63823395.0
 
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.