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

150 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
colorlessnesses166509(None) 
colorlessness1553902colorlessne_s_s
bloodlessnesses1764323bloodlessnesses
bootlessnesses1556453bo_otlessnesses
cheerlessnesses1954543cheerlessnesses
cloudlessnesses1764873cloudlessnesses
colorfastnesses2061303colorfastnesses
foodlessnesses1755763fo_odlessnesses
footlessnesses1656563fo_otlessnesses
humorlessnesses1954183humorlessnesses
plotlessnesses1556093_plotlessnesses
powerlessnesses1954493powerlessnesses
rootlessnesses1346603ro_otlessnesses
airlessnesses12117994__airlessnesses
boundlessnesses1774924boundlessnesses
carelessnesses1547724c_arelessnesses
ceaselessnesses1596164ceaselessnesses
childlessnesses20104944childlessnesses
classlessnesses054834classlessnesses
colorfulnesses1993834color_fulnesses
dolorousnesses1555784dolor_ousnesses
doubtlessnesses1764934doubtlessnesses
fearlessnesses1666744_fearlessnesses
flawlessnesses1975454_flawlessnesses
formlessnesses1856124fo_rmlessnesses
godlessnesses1446584__godlessnesses
hairlessnesses16126634_hairlessnesses
helplessnesses1855804hel_plessnesses
homelessnesses18137474ho_melessnesses
hopelessnesses18147014ho_pelessnesses
hornlessnesses1656274ho_rnlessnesses
houselessnesses1665674houselessnesses
joblessnesses2155994__joblessnesses
joylessnesses2255644__joylessnesses
lawlessnesses1546384__lawlessnesses
lovelessnesses1646994lo_velessnesses
movelessnesses1846744mo_velessnesses
planlessnesses1576304_planlessnesses
pointlessnesses1655444pointlessnesses
selflessnesses15115994sel_flessnesses
soullessnesses1296504so_ullessnesses
spotlessnesses1456274_spotlessnesses
tonelessnesses13137654to_nelessnesses
toplessnesses1446584__toplessnesses
valuelessnesses1764794valuelessnesses
voicelessnesses1955314voicelessnesses
waterlessnesses1754724waterlessnesses
wordlessnesses1775874wo_rdlessnesses
worklessnesses20125484wo_rklessnesses
worthlessnesses2054554worthlessnesses
agelessnesses1387625__agelessnesses
aimlessnesses1487465__aimlessnesses
artlessnesses1247665__artlessnesses
blamelessnesses1865715blamelessnesses
bloodlessness1653505bloodlessne_s_s
boorishnesses1864315bo_or_ishnesses
bootlessness1445455bo_otlessne_s_s
brainlessnesses1665025brainlessnesses
callousnesses1556465cal__lousnesses
canorousnesses16127065canor_ousnesses
cheerlessness1853705cheerlessne_s_s
churlishnesses2252545c_hurlishnesses
cloddishnesses2152625c_loddishnesses
closenesses1347845c_lo___senesses
clothespresses219895c_lothespresses
cloudlessness1653845cloudlessne_s_s
clownishnesses2262275c_lownishnesses
coarsenesses1447245co_ar__senesses
colonialnesses1653055colo_nialnesses
colorfastness1861255colorfastne_s_s
coltishnesses1845225col__tishnesses
completenesses2053995co_mpletenesses
complexnesses26112725co_mple_xnesses
concretenesses1854165concr_etenesses
congruousnesses1884635congruousnesses
coolnesses1237195co_o_l___nesses
corporealnesses1961885corpor_ealnesses
correctnesses1754215c__orrectnesses
courteousnesses1784135co_urteousnesses
crassnesses1246655c___r_assnesses
crossnesses1247125c___r_ossnesses
dauntlessnesses1554815dauntlessnesses
deathlessnesses1885175deathlessnesses
dollishnesses1744375dol__lishnesses
dreamlessnesses17104535dreamlessnesses
endlessnesses1356765__endlessnesses
facelessnesses1847325_facelessnesses
faithlessnesses2074975faithlessnesses
faultlessnesses1754935faultlessnesses
fecklessnesses2255495_fecklessnesses
fencelessnesses1995355fencelessnesses
foodlessness1644745fo_odlessne_s_s
foolishnesses1944465fo_o_lishnesses
footlessness1545615fo_otlessne_s_s
fruitlessnesses1754895fruitlessnesses
gloriousnesses1556915_gloriousnesses
gracelessnesses1755905gracelessnesses
guilelessnesses15195315guilelessnesses
guiltlessnesses15174925guiltlessnesses
gutlessnesses1346945__gutlessnesses
haplessnesses1747255__haplessnesses
harmlessnesses1876415_harmlessnesses
headlessnesses17137065_headlessnesses
heartlessnesses1765775heartlessnesses
heedlessnesses17136225_heedlessnesses
humorlessness1853165humorlessne_s_s
landlessnesses1456685_landlessnesses
lifelessnesses1646655_lifelessnesses
limitlessnesses1654285limitlessnesses
listlessnesses1266935_listlessnesses
mercilessnesses18104535mercilessnesses
mindlessnesses1686015_mindlessnesses
namelessnesses1577055_namelessnesses
needlessnesses14115695_needlessnesses
nervelessnesses1754985nervelessnesses
odorousnesses1456735_odor_ousnesses
painlessnesses1546745_painlessnesses
pathlessnesses1855955_pathlessnesses
pitilessnesses1575755_pitilessnesses
plotlessness1445085_plotlessne_s_s
powerlessness1853195powerlessne_s_s
raylessnesses1546505__raylessnesses
recklessnesses1955845_recklessnesses
restlessnesses1257235_restlessnesses
rootlessness1245615ro_otlessne_s_s
ruthlessnesses1665385_ruthlessnesses
saplessnesses1347275__saplessnesses
seamlessnesses1446975_seamlessnesses
senselessnesses055705senselessnesses
sexlessnesses1846745__sexlessnesses
shamelessnesses18186515shamelessnesses
shapelessnesses18156295shapelessnesses
shiftlessnesses1954995shiftlessnesses
sightlessnesses1755035sightlessnesses
sinlessnesses1157985__sinlessnesses
skillessnesses1655615_skillessnesses
sleeplessnesses1554685sleeplessnesses
sonorousnesses1356515sonor_ousnesses
spinelessnesses1555495spinelessnesses
statelessnesses1355865statelessnesses
stylelessnesses1674715stylelessnesses
tactlessnesses1546555_tactlessnesses
tastelessnesses1355275tastelessnesses
thanklessnesses2154805thanklessnesses
timelessnesses1547025_timelessnesses
tirelessnesses1357015_tirelessnesses
uselessnesses1147315__uselessnesses
volublenesses1854565voluble__nesses
winglessnesses1765465_winglessnesses
witlessnesses1547235__witlessnesses

Search took 6 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.313570897.8
2DLD Change Limit658741504.61014289.4
3Display Results1501500.236635.6
 (SQL Overall)1786911505.15934636.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.