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

(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
colorlessnesses1665091colorlessnesses_
colorlessness1553903colorlessne_s_s_
bloodlessnesses1764324bloodlessnesses_
bootlessnesses1556454bo_otlessnesses_
cheerlessnesses1954544cheerlessnesses_
cloudlessnesses1764864cloudlessnesses_
colorfastnesses2061304colorfastnesses_
foodlessnesses1755764fo_odlessnesses_
footlessnesses1656564fo_otlessnesses_
humorlessnesses1954184humorlessnesses_
plotlessnesses1556094_plotlessnesses_
powerlessnesses1954494powerlessnesses_
rootlessnesses1346594ro_otlessnesses_
airlessnesses12117995__airlessnesses_
boundlessnesses1774925boundlessnesses_
carelessnesses1547725c_arelessnesses_
ceaselessnesses1596165ceaselessnesses_
childlessnesses20104945childlessnesses_
classlessnesses054835classlessnesses_
colorfulnesses1993835color_fulnesses_
dolorousnesses1555785dolor_ousnesses_
doubtlessnesses1764925doubtlessnesses_
fearlessnesses1666745_fearlessnesses_
flawlessnesses1975455_flawlessnesses_
formlessnesses1856125fo_rmlessnesses_
godlessnesses1446585__godlessnesses_
hairlessnesses16126635_hairlessnesses_
helplessnesses1855805hel_plessnesses_
homelessnesses18137475ho_melessnesses_
hopelessnesses18147015ho_pelessnesses_
hornlessnesses1656275ho_rnlessnesses_
houselessnesses1665675houselessnesses_
joblessnesses2155985__joblessnesses_
joylessnesses2255645__joylessnesses_
lawlessnesses1546385__lawlessnesses_
lovelessnesses1646995lo_velessnesses_
movelessnesses1846745mo_velessnesses_
planlessnesses1576305_planlessnesses_
pointlessnesses1655445pointlessnesses_
selflessnesses15115995sel_flessnesses_
soullessnesses1296495so_ullessnesses_
spotlessnesses1456275_spotlessnesses_
tonelessnesses13137645to_nelessnesses_
toplessnesses1446575__toplessnesses_
valuelessnesses1764795valuelessnesses_
voicelessnesses1955315voicelessnesses_
waterlessnesses1754725waterlessnesses_
wordlessnesses1775875wo_rdlessnesses_
worklessnesses20125485wo_rklessnesses_
worthlessnesses2054555worthlessnesses_
agelessnesses1387626__agelessnesses_
aimlessnesses1487466__aimlessnesses_
artlessnesses1247666__artlessnesses_
blamelessnesses1865716blamelessnesses_
bloodlessness1653496bloodlessne_s_s_
boorishnesses1864316bo_or_ishnesses_
bootlessness1445446bo_otlessne_s_s_
brainlessnesses1665026brainlessnesses_
callousnesses1556466cal__lousnesses_
canorousnesses16127066canor_ousnesses_
cheerlessness1853706cheerlessne_s_s_
churlishnesses2252546c_hurlishnesses_
cloddishnesses2152626c_loddishnesses_
closenesses1347846c_lo___senesses_
clothespresses219896c_lothespresses_
cloudlessness1653836cloudlessne_s_s_
clownishnesses2262276c_lownishnesses_
coarsenesses1447246co_ar__senesses_
colonialnesses1653056colo_nialnesses_
colorfastness1861256colorfastne_s_s_
coltishnesses1845226col__tishnesses_
completenesses2053996co_mpletenesses_
complexnesses26112726co_mple_xnesses_
concretenesses1854166concr_etenesses_
congruousnesses1884636congruousnesses_
coolnesses1237196co_o_l___nesses_
corporealnesses1961886corpor_ealnesses_
correctnesses1754216c__orrectnesses_
courteousnesses1784136co_urteousnesses_
crassnesses1246656c___r_assnesses_
crossnesses1247126c___r_ossnesses_
dauntlessnesses1554816dauntlessnesses_
deathlessnesses1885176deathlessnesses_
dollishnesses1744376dol__lishnesses_
dreamlessnesses17104536dreamlessnesses_
endlessnesses1356766__endlessnesses_
facelessnesses1847326_facelessnesses_
faithlessnesses2074976faithlessnesses_
faultlessnesses1754936faultlessnesses_
fecklessnesses2255496_fecklessnesses_
fencelessnesses1995356fencelessnesses_
foodlessness1644736fo_odlessne_s_s_
foolishnesses1944466fo_o_lishnesses_
footlessness1545606fo_otlessne_s_s_
fruitlessnesses1754896fruitlessnesses_
gloriousnesses1556916_gloriousnesses_
gracelessnesses1755906gracelessnesses_
guilelessnesses15195316guilelessnesses_
guiltlessnesses15174926guiltlessnesses_
gutlessnesses1346946__gutlessnesses_
haplessnesses1747256__haplessnesses_
harmlessnesses1876416_harmlessnesses_
headlessnesses17137066_headlessnesses_
heartlessnesses1765776heartlessnesses_
heedlessnesses17136226_heedlessnesses_
humorlessness1853166humorlessne_s_s_
landlessnesses1456686_landlessnesses_
lifelessnesses1646656_lifelessnesses_
limitlessnesses1654286limitlessnesses_
listlessnesses1266936_listlessnesses_
mercilessnesses18104536mercilessnesses_
mindlessnesses1686016_mindlessnesses_
namelessnesses1577056_namelessnesses_
needlessnesses14115696_needlessnesses_
nervelessnesses1754986nervelessnesses_
odorousnesses1456736_odor_ousnesses_
painlessnesses1546746_painlessnesses_
pathlessnesses1855956_pathlessnesses_
pitilessnesses1575756_pitilessnesses_
plotlessness1445076_plotlessne_s_s_
powerlessness1853196powerlessne_s_s_
raylessnesses1546506__raylessnesses_
recklessnesses1955846_recklessnesses_
restlessnesses1257236_restlessnesses_
rootlessness1245606ro_otlessne_s_s_
ruthlessnesses1665386_ruthlessnesses_
saplessnesses1347276__saplessnesses_
seamlessnesses1446976_seamlessnesses_
senselessnesses055706senselessnesses_
sexlessnesses1846746__sexlessnesses_
shamelessnesses18186516shamelessnesses_
shapelessnesses18156296shapelessnesses_
shiftlessnesses1954996shiftlessnesses_
sightlessnesses1755036sightlessnesses_
sinlessnesses1157986__sinlessnesses_
skillessnesses1655616_skillessnesses_
sleeplessnesses1554686sleeplessnesses_
sonorousnesses1356516sonor_ousnesses_
spinelessnesses1555496spinelessnesses_
statelessnesses1355866statelessnesses_
stylelessnesses1674716stylelessnesses_
tactlessnesses1546556_tactlessnesses_
tastelessnesses1355276tastelessnesses_
thanklessnesses2154806thanklessnesses_
timelessnesses1547026_timelessnesses_
tirelessnesses1357016_tirelessnesses_
uselessnesses1147316__uselessnesses_
volublenesses1854566voluble__nesses_
winglessnesses1765466_winglessnesses_
witlessnesses1547236__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.0931921408.6
2DLD Change Limit658741505.06313010.9
3Display Results1501500.1231219.5
 (SQL Overall)1786911505.27933849.4
 
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.