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

91 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
forgetfulnesses226298(None) 
forcefulnesses2254172force_fulnesses
forgetfulness2053742forgetfulne_s_s
fretfulnesses1945902f_r_etfulnesses
frightfulnesses2562903frightfulnesses
fruitfulnesses2094633f_ruitfulnesses
regretfulnesses1963273regretfulnesses
artfulnesses1546644_ar__tfulnesses
boastfulnesses1954034bo_astfulnesses
carefulnesses1845694car_e_fulnesses
dolefulnesses1774844do_le_fulnesses
doubtfulnesses2053704do_ubtfulnesses
effortfulnesses20112184effor__tfulnesses
fatefulnesses1945994f_ate_fulnesses
fitfulnesses1866024f___itfulnesses
forcefulness2054454force_fulne_s_s
fretfulness1776224f_r_etfulne_s_s
gorgeousnesses1655094gorge_ousnesses
gratefulnesses18135414_gratefulnesses
hopefulnesses2184594ho_pe_fulnesses
hurtfulnesses1954854hur__tfulnesses
restfulnesses1646624__restfulnesses
rightfulnesses2174464_rightfulnesses
ruefulnesses1545934__rue_fulnesses
songfulnesses1754674song__fulnesses
sorrowfulnesses2161964sorrowfulnesses
sportfulnesses1964174spor__tfulnesses
tristfulnesses1774334_tristfulnesses
trustfulnesses1764314_trustfulnesses
vengefulnesses2153654venge_fulnesses
voicefulnesses2253574voice_fulnesses
woefulnesses1845344wo__e_fulnesses
wonderfulnesses2262674wonderfulnesses
balefulnesses1844855_bale_fulnesses
bountifulnesses2073195bountifulnesses
changefulnesses2462235change_fulnesses
cheerfulnesses2253385_cheerfulnesses
colorfulnesses1993835co_lorfulnesses
covetousnesses1955225co_vetousnesses
deceitfulnesses2173045deceitfulnesses
dreadfulnesses19193795_dreadfulnesses
dreamfulnesses20183695_dreamfulnesses
eventfulnesses2054275_eventfulnesses
faithfulnesses2354405f_aithfulnesses
fancifulnesses2254005f_ancifulnesses
fearfulnesses1945315f__earfulnesses
fidgetinesses1851885fidget__inesses
foreignnesses1752755for_e_ignnesses
forevernesses1952875for_e_vernesses
forgivenesses2045845forg__ivenesses
forgivingnesses2371545forgivingnesses
formalnesses1744485for___malnesses
foulnesses1337935fo_____ulnesses
frightfulness2363205frightfulne_s_s
fruitfulness1854885f_ruitfulne_s_s
gleefulnesses1764255__gleefulnesses
gracefulnesses20154915_gracefulnesses
guilefulnesses1853585guile_fulnesses
harmfulnesses2164305har__mfulnesses
hatefulnesses1945805_hate_fulnesses
heedfulnesses20124105__heedfulnesses
joyfulnesses2553505jo___yfulnesses
lustfulnesses1655155__lustfulnesses
masterfulnesses2053295masterfulnesses
mercifulnesses2154275mer_cifulnesses
mirthfulnesses2253635mir_thfulnesses
mournfulnesses1963425mo_urnfulnesses
needfulnesses17134095__needfulnesses
peacefulnesses2154705peace_fulnesses
prayerfulnesses2362405prayerfulnesses
pridefulnesses2053895_pridefulnesses
regretfulness1753875regretfulne_s_s
resentfulnesses1883745resentfulnesses
ruthfulnesses1954945__ruthfulnesses
scornfulnesses1953205scor__nfulnesses
shamefulnesses2253685shame_fulnesses
soulfulnesses1654555so__ulfulnesses
spitefulnesses1954415spite_fulnesses
tactfulnesses1855265__tactfulnesses
tastefulnesses1754605taste_fulnesses
togethernesses1861215to_gethernesses
truthfulnesses2054115_truthfulnesses
tunefulnesses1655135_tune_fulnesses
usefulnesses1545825__use_fulnesses
wakefulnesses2354295_wake_fulnesses
wastefulnesses2054525waste_fulnesses
wistfulnesses1955545__wistfulnesses
wrathfulnesses2354375_wrathfulnesses
wrongfulnesses2153175_wrongfulnesses
youthfulnesses2353735yo_uthfulnesses
zestfulnesses2555005__zestfulnesses

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.0931921408.6
2DLD Change Limit65874913.70317789.4
3Display Results91910.0801137.5
 (SQL Overall)178691913.87646101.9
 
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.