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

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

87 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
regretfulnesses196327(None) 
regretfulness1753872regretfulne_s_s
forgetfulnesses2262983forgetfulnesses
fretfulnesses1945903__fretfulnesses
regardfulnesses2072523regardfulnesses
resentfulnesses1883743resentfulnesses
restfulnesses1646623re__stfulnesses
rightfulnesses2174463rig_htfulnesses
artfulnesses1546644__ar_tfulnesses
carefulnesses1845694_care_fulnesses
deceitfulnesses2173044deceitfulnesses
eventfulnesses2054274_eventfulnesses
fearfulnesses1945314fear__fulnesses
frightfulnesses2562904frig_htfulnesses
gleefulnesses1764254__gleefulnesses
gratefulnesses18135414__gratefulnesses
heedfulnesses20124104he__edfulnesses
hurtfulnesses1954854_hur_tfulnesses
mercifulnesses2154274me_rcifulnesses
needfulnesses17134094ne__edfulnesses
peacefulnesses2154704peace_fulnesses
reposefulnesses2062574reposefulnesses
ruefulnesses1545934r__ue_fulnesses
sportfulnesses1964174spor_tfulnesses
tearfulnesses1645534tear__fulnesses
vengefulnesses2153654venge_fulnesses
wearifulnesses2054654wear_ifulnesses
zestfulnesses2555004ze__stfulnesses
balefulnesses1844855_bale_fulnesses
beautifulnesses2083455beautifulnesses
boastfulnesses1954035_boastfulnesses
cheerfulnesses2253385_cheerfulnesses
dolefulnesses1774845_dole_fulnesses
doubtfulnesses2053705_doubtfulnesses
dreadfulnesses19193795dre__adfulnesses
dreamfulnesses20183695dre__amfulnesses
effortfulnesses20112185effortfulnesses
egregiousnesses1764265_egregiousnesses
fatefulnesses1945995_fate_fulnesses
fitfulnesses1866025___fitfulnesses
forcefulnesses2254175_forcefulnesses
forgetfulness2053745forgetfulne_s_s
fretfulness1776225__fretfulne_s_s
fruitfulnesses2094635_fruitfulnesses
gainfulnesses17124615__gainfulnesses
gracefulnesses20154915__gracefulnesses
guilefulnesses1853585guile_fulnesses
harmfulnesses2164305_har_mfulnesses
hatefulnesses1945805_hate_fulnesses
healthfulnesses2492905healthfulnesses
helpfulnesses2153545he__lpfulnesses
hopefulnesses2184595_hope_fulnesses
lustfulnesses1655155__lustfulnesses
masterfulnesses2053295masterfulnesses
mirthfulnesses2253645_mirthfulnesses
mournfulnesses1963425mour_nfulnesses
neglectfulness2082085neglectfulne_s_s
prayerfulnesses2362405prayerfulnesses
pridefulnesses2053895pride_fulnesses
regalnesses1246195reg____alnesses
regardfulness1862895regardfulne_s_s
repletenesses1554495replet__enesses
resentfulness1664795resentfulne_s_s
respectfulness2163275respectfulne_s_s
restfulness1447235re__stfulne_s_s
righteousnesses1963395righteousnesses
rightfulness1994895rig_htfulne_s_s
ruthfulnesses1954945r__uthfulnesses
scornfulnesses1953205scor_nfulnesses
secretivenesses2055685secretivenesses
shamefulnesses2253685shame_fulnesses
sorrowfulnesses2161965sorrowfulnesses
spitefulnesses1954415spite_fulnesses
tactfulnesses1855265__tactfulnesses
tastefulnesses1754605taste_fulnesses
tristfulnesses1774335_tristfulnesses
trustfulnesses1764315_trustfulnesses
truthfulnesses2054115__truthfulnesses
tunefulnesses1655135_tune_fulnesses
usefulnesses1545825__use_fulnesses
voicefulnesses2253575voice_fulnesses
wakefulnesses2354295_wake_fulnesses
wastefulnesses2054525waste_fulnesses
wistfulnesses1955545__wistfulnesses
woefulnesses1845345__woe_fulnesses
wonderfulnesses2262675wonderfulnesses
wrathfulnesses2354375__wrathfulnesses

Search took 4 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 Filter178691658740.330541487.9
2DLD Change Limit65874873.56318488.4
3Display Results87870.0761144.7
 (SQL Overall)178691873.96945021.7
 
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.