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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

168 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
colorfulnesses199383(None) 
colorfulness1753822colorfulne_s_s
cheerfulnesses2253383cheerfulnesses
colonialnesses1653053colonialnesses
colorfastnesses2061303colorfastnesses
dolefulnesses1774843dol_efulnesses
dolorousnesses1555783dolorousnesses
balefulnesses1844854bal_efulnesses
boastfulnesses1954034boastfulnesses
canorousnesses16127064canorousnesses
carefulnesses1845694c_arefulnesses
colorlessnesses1665094colorlessnesses
coolnesses1237194co_o___lnesses
corporealnesses1961884corporealnesses
doubtfulnesses2053704doubtfulnesses
effortfulnesses20112184effortfulnesses
fearfulnesses1945314_fearfulnesses
forcefulnesses2254174forcefulnesses
gleefulnesses1764254_gleefulnesses
helpfulnesses2153544hel_pfulnesses
hopefulnesses2184594ho_pefulnesses
joyfulnesses2553504__joyfulnesses
lawfulnesses1844144__lawfulnesses
mournfulnesses1963424mournfulnesses
odorousnesses1456734_odorousnesses
playfulnesses2153644_playfulnesses
scornfulnesses1953204sco_rnfulnesses
slothfulnesses2053464slothfulnesses
songfulnesses1754674so_ngfulnesses
sonorousnesses1356514sonorousnesses
sorrowfulnesses2161964sorrowfulnesses
soulfulnesses1654554so_ulfulnesses
sportfulnesses1964174_sportfulnesses
tearfulnesses1645534_tearfulnesses
unlawfulnesses2052984unlawfulnesses
voicefulnesses2253574voicefulnesses
willfulnesses1953884wil_lfulnesses
woefulnesses1845344__woefulnesses
wonderfulnesses2262674wonderfulnesses
youthfulnesses2353734youthfulnesses
aloofnesses1443415_aloof__nesses
amorousnesses1547815_amorousnesses
artfulnesses1546645__artfulnesses
awfulnesses1744945___awfulnesses
bashfulnesses2154185_bashfulnesses
blissfulnesses1852835blissfulnesses
boorishnesses1864315bo_orishnesses
bountifulnesses2073195bountifulnesses
callousnesses1556465cal_lousnesses
changefulnesses2462235changefulnesses
cheerfulness2053585cheerfulne_s_s
clamorousnesses19103995clamorousnesses
closenesses1347845c_lo__senesses
cloudinesses1545125c_lo_udinesses
coarsenesses1447245co_ar_senesses
coldnesses1338425col____dnesses
colonialness1453465colonialne_s_s
colorfastness1861255colorfastne_s_s
colorless1145685color__l_e_s_s
colorlessly1652225color__l_essly
colorlessness1553905color__l_essness
coltishnesses1845225col_tishnesses
comfinesses1846915c__omf_inesses
concretenesses1854165concretenesses
congruousnesses1884635congruousnesses
contrarinesses1674245contrarinesses
contritenesses1655495contritenesses
copiousnesses1747805co_piousnesses
cordialnesses1654575co_rdialnesses
cordlesses1346305c__or_dl_esses
corkinesses1749215c__or_kinesses
corninesses13410595c__or_ninesses
correctnesses1754215co_rrectnesses
corruptnesses1752845co_rruptnesses
courtlinesses1544465co_urtlinesses
covertnesses1746335cover__tnesses
covetousnesses1955225covetousnesses
cowardlinesses2052515cowardlinesses
cruelnesses1346255c___ruelnesses
cumbrousnesses2054855cumbrousnesses
decorousnesses1756565decorousnesses
dolefulness1544885dol_efulne_s_s
dolorousness1355355dolorousne_s_s
dreadfulnesses19193795dreadfulnesses
dreamfulnesses20183695dreamfulnesses
dutifulnesses1755115_dutifulnesses
eventfulnesses2054275eventfulnesses
faithfulnesses2354405faithfulnesses
fancifulnesses2254005fancifulnesses
fatefulnesses1945995_fatefulnesses
fitfulnesses1866025__fitfulnesses
floridnesses1654135_flor_idnesses
forgetfulnesses2262985forgetfulnesses
forlornnesses1652575forlor__nnesses
formalnesses1744485__formalnesses
foulnesses1337935__fo__ulnesses
fretfulnesses1945905_fretfulnesses
fruitfulnesses2094635fruitfulnesses
fulnesses1239055_____fulnesses
gainfulnesses17124615_gainfulnesses
gloriousnesses1556915_gloriousnesses
goofinesses1535965go_o_f_inesses
gracefulnesses20154915gracefulnesses
gratefulnesses18135415gratefulnesses
guilefulnesses1853585guilefulnesses
harmfulnesses2164305_harmfulnesses
hatefulnesses1945805_hatefulnesses
healthfulnesses2492905healthfulnesses
heedfulnesses20124105_heedfulnesses
honorablenesses2064205honorablenesses
humorousnesses1955445humorousnesses
hurtfulnesses1954855_hurtfulnesses
joyousnesses2244665joyo__usnesses
localnesses1345855__lo_calnesses
loftinesses1437925__lo_ftinesses
lordlinesses1345175__lordlinesses
lornnesses1037825__lor__nnesses
loudnesses1138435__lo__udnesses
lustfulnesses1655155_lustfulnesses
manfulnesses1745835__manfulnesses
masterfulnesses2053295masterfulnesses
mercifulnesses2154275mercifulnesses
mindfulnesses1954435_mindfulnesses
mirthfulnesses2253645mirthfulnesses
needfulnesses17134095_needfulnesses
onerousnesses1348975_onerousnesses
painfulnesses18115145_painfulnesses
peacefulnesses2154705peacefulnesses
pitifulnesses1855575_pitifulnesses
poornesses1236805po_or___nesses
porousnesses1469285__porousnesses
prayerfulnesses2362405prayerfulnesses
pridefulnesses2053895pridefulnesses
pushfulnesses2153945_pushfulnesses
regardfulnesses2072525regardfulnesses
reposefulnesses2062575reposefulnesses
restfulnesses1646625_restfulnesses
rightfulnesses2174465rightfulnesses
rigorousnesses1565855rigorousnesses
ruefulnesses1545935__ruefulnesses
ruthfulnesses1954945_ruthfulnesses
shamefulnesses2253685shamefulnesses
sinfulnesses1546135__sinfulnesses
skillfulnesses2152655skillfulnesses
spitefulnesses1954415spitefulnesses
tactfulnesses1855265_tactfulnesses
tastefulnesses1754605tastefulnesses
thankfulnesses2453095thankfulnesses
timorousnesses1655695timorousnesses
toploftinesses1951275toplo_ftinesses
tristfulnesses1774335tristfulnesses
trustfulnesses1764315trustfulnesses
truthfulnesses2054115truthfulnesses
tunefulnesses1655135_tunefulnesses
usefulnesses1545825__usefulnesses
vaporousnesses1956005vaporousnesses
vengefulnesses2153655vengefulnesses
vigorousnesses1865525vigorousnesses
wakefulnesses2354295_wakefulnesses
wastefulnesses2054525wastefulnesses
watchfulnesses2552985watchfulnesses
wearifulnesses2054655wearifulnesses
wishfulnesses2254285_wishfulnesses
wistfulnesses1955545_wistfulnesses
wondrousnesses1855845wondrousnesses
wrathfulnesses2354375wrathfulnesses
wrongfulnesses2153175wrongfulnesses
zestfulnesses2555005_zestfulnesses

Search took 7 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.356501941.0
2DLD Change Limit950241685.58017029.4
3Display Results1681680.1231365.9
 (SQL Overall)1786911686.05929491.8
 
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.