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

140 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
dreamlessnesses17104531dreamlessnesses_
dreamlessness1673813dreamlessne_s_s_
seamlessnesses1446973_seamlessnesses_
deathlessnesses1885174d_eathlessnesses_
fearlessnesses1666744_fearlessnesses_
headlessnesses17137064_headlessnesses_
raylessnesses1546504_r_aylessnesses_
recklessnesses1955844_recklessnesses_
restlessnesses1257234_restlessnesses_
agelessnesses1387635age__lessnesses_
aimlessnesses1487465__aimlessnesses_
artlessnesses1247675ar__tlessnesses_
blamelessnesses1865715_blamelessnesses_
brainlessnesses1665025brainlessnesses_
carelessnesses1547725care__lessnesses_
ceaselessnesses1596165_ceaselessnesses_
cheerlessnesses1954545cheerlessnesses_
dauntlessnesses1554815dauntlessnesses_
doubtlessnesses1764935doubtlessnesses_
dreamfulnesses20183695dream_fulnesses_
dreaminesses1545715dream___inesses_
endlessnesses1356765__endlessnesses_
fecklessnesses2255495_fecklessnesses_
flawlessnesses1975455_flawlessnesses_
formlessnesses1856125_formlessnesses_
fruitlessnesses1754895fruitlessnesses_
gracelessnesses1755905gracelessnesses_
haplessnesses1747255__haplessnesses_
harmlessnesses1876415_harmlessnesses_
heartlessnesses1765775_heartlessnesses_
heedlessnesses17136225_heedlessnesses_
helplessnesses1855805_helplessnesses_
lawlessnesses1546385__lawlessnesses_
mercilessnesses18104535mercilessnesses_
namelessnesses1577055__namelessnesses_
needlessnesses14115695_needlessnesses_
nervelessnesses1754985nervelessnesses_
planlessnesses1576305_planlessnesses_
remissnesses1344955_re_m_issnesses_
rootlessnesses1346605_rootlessnesses_
ruthlessnesses1665385_ruthlessnesses_
saplessnesses1347275__saplessnesses_
seamlessness1355905_seamlessne_s_s_
selflessnesses15115995_selflessnesses_
sexlessnesses1846745_se_xlessnesses_
shamelessnesses18186515_shamelessnesses_
sleeplessnesses1554685sleeplessnesses_
tirelessnesses1357015tire__lessnesses_
uselessnesses1147315use__lessnesses_
airlessnesses12118006__airlessnesses_
bloodlessnesses1764326bloodlessnesses_
bootlessnesses1556456_bootlessnesses_
boundlessnesses1774926boundlessnesses_
breathlessness1952796breathlessne_s_s_
childlessnesses20104946childlessnesses_
classlessnesses054836classlessnesses_
cloudlessnesses1764876cloudlessnesses_
colorlessnesses1665096colorlessnesses_
crassnesses1246656cr_a___ssnesses_
creaminesses1646136cream___inesses_
credulousnesses1853626credulousnesses_
deadlinesses1446226d_eadl__inesses_
deathlessness1754326d_eathlessne_s_s_
detailednesses1653206detaile_dnesses_
devilishnesses2152696d_evilishnesses_
dreadfulnesses19193796drea_dfulnesses_
drearinesses1347446drea___rinesses_
dressinesses1245536dre___ssinesses_
durablenesses16156586durable__nesses_
earnestnesses1353666__earnestnesses_
facelessnesses1847326_facelessnesses_
faithlessnesses2074976faithlessnesses_
faultlessnesses1754936faultlessnesses_
fearlessness1545766_fearlessne_s_s_
femalenesses1746866_female__nesses_
fencelessnesses1995356fencelessnesses_
foodlessnesses1755766_foodlessnesses_
footlessnesses1656566_footlessnesses_
freakishnesses2452656frea_kishnesses_
godlessnesses1446586__godlessnesses_
greasinesses1347066grea___sinesses_
guilelessnesses15195316guilelessnesses_
guiltlessnesses15174926guiltlessnesses_
gutlessnesses1346946__gutlessnesses_
hairlessnesses16126636_hairlessnesses_
headlessness16105966_headlessne_s_s_
homelessnesses18137476_homelessnesses_
hopelessnesses18147016_hopelessnesses_
hornlessnesses1656276_hornlessnesses_
houselessnesses1665676houselessnesses_
humorlessnesses1954186humorlessnesses_
jealousnesses2056326_jea_lousnesses_
joblessnesses2155996__joblessnesses_
joylessnesses2255646__joylessnesses_
landlessnesses1456686_landlessnesses_
lifelessnesses1646656_lifelessnesses_
limitlessnesses1654286limitlessnesses_
listlessnesses1266936_listlessnesses_
lovelessnesses1646996_lovelessnesses_
mindlessnesses1686016_mindlessnesses_
movelessnesses1846746_movelessnesses_
painlessnesses1546746_painlessnesses_
pathlessnesses1855956_pathlessnesses_
pitilessnesses1575756_pitilessnesses_
plotlessnesses1556096_plotlessnesses_
pointlessnesses1655446pointlessnesses_
powerlessnesses1954496powerlessnesses_
raylessness1445116_r_aylessne_s_s_
realnesses10310856_rea_l___nesses_
reassesses945066_rea___ss_esses_
recklessness1854656_recklessne_s_s_
repletenesses1554496_re_pletenesses_
restlessness1146516_restlessne_s_s_
senselessnesses055706senselessnesses_
shapelessnesses18156296shapelessnesses_
shiftlessnesses1954996shiftlessnesses_
sightlessnesses1755036sightlessnesses_
sinlessnesses1157986__sinlessnesses_
skillessnesses1655616_skillessnesses_
soullessnesses1296506_soullessnesses_
spinelessnesses1555496spinelessnesses_
spotlessnesses1456276_spotlessnesses_
statelessnesses1355866statelessnesses_
stylelessnesses1674716stylelessnesses_
tactlessnesses1546556_tactlessnesses_
tastelessnesses1355276tastelessnesses_
thanklessnesses2154806thanklessnesses_
timelessnesses1547026_timelessnesses_
tonelessnesses13137656_tonelessnesses_
toplessnesses1446586__toplessnesses_
tremulousnesses1763386tremulousnesses_
valuelessnesses1764796valuelessnesses_
voicelessnesses1955316voicelessnesses_
waterlessnesses1754726waterlessnesses_
winglessnesses1765466_winglessnesses_
witlessnesses1547236__witlessnesses_
wordlessnesses1775876_wordlessnesses_
worklessnesses20125486_worklessnesses_
worthlessnesses2054556worthlessnesses_
zealousnesses2256266_zea_lousnesses_

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.310576422.6
2DLD Change Limit658741404.72013956.4
3Display Results1401400.1101272.7
 (SQL Overall)1786911405.14034764.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.