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

174 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
sightlessness165415(None) 
sightlessnesses1755032sightlessnesses
weightlessness2162422weightlessness
gutlessness1246013__gutlessness
limitlessness1553343limitlessness
listlessness1145823li_stlessness
shiftlessness1854003shiftlessness
sightliness1574563sightl__iness
sinlessness1046723si__nlessness
spiritlessness1582563spiritlessness
spotlessness1345323s_potlessness
witlessness1446263wi__tlessness
agelessness1246084_ag_elessness
aimlessness1345674ai__mlessness
airlessness1146264ai__rlessness
artlessness1146444__artlessness
bootlessness1445454_bootlessness
dauntlessness1453774dauntlessness
deathlessness1754324deathlessness
doubtlessness1654074doubtlessness
faithlessness1953974faith_lessness
faultlessness1653944faultlessness
footlessness1545614_footlessness
fruitlessness1654194fruitlessness
godlessness1355434__godlessness
guiltlessness1453774guiltlessness
heartlessness1665174heartlessness
lifelessness1545294li_felessness
lightfastness2061314lightfastness
lightnesses1546144lightness_e_s
mindlessness1554854mi_ndlessness
pathlessness1754904path_lessness
pitilessness1474524pi_tilessness
plotlessness1445084_plotlessness
pointlessness1554614pointlessness
resistlessness1282604resi_stlessness
restlessness1146514_restlessness
righteousness1763924righteousness
rightnesses1546234rightness_e_s
rootlessness1245614_rootlessness
ruthlessness1554314ruth_lessness
saplessness1245984s__aplessness
seamlessness1355904s_eamlessness
selflessness1444594s_elflessness
senselessness1154734senselessness
sexlessness1745314s__exlessness
shamelessness1754964shamelessness
shapelessness1754964shapelessness
sightless1385924sightl____ess
sightlessly1852614sightless__ly
sightlines1465754sightl__ine_s
sightlinesses1743864sightliness_e_s
skillessness1554234s_killessness
sleeplessness1453554sleeplessness
slightnesses1654624slightness_e_s
soullessness1145544s_oullessness
spinelessness1454404spinelessness
statelessness1255144statelessness
stylelessness1553414stylelessness
tactlessness1445414_tactlessness
thoughtlessness2271334thoughtlessness
tightnesses1565584tightness_e_s
timelessness1445784ti_melessness
tirelessness1245934ti_relessness
winglessness1654324wi_nglessness
worthlessness1953654worthlessness
affectlessness2271915affectlessness
blamelessness1754545blamelessness
bloodlessness1653505bloodlessness
boundlessness1654045boundlessness
brainlessness1554195brainlessness
breathlessness1952795breathlessness
brightnesses1844185brightness_e_s
carelessness1446545_carelessness
ceaselessness1455115ceaselessness
cheerlessness1853705cheerlessness
childlessness1963875childlessness
classlessness1353735classlessness
cloudlessness1653845cloudlessness
colorlessness1553905colorlessness
dreamlessness1673815dreamlessness
effortlessness2061895effortlessness
endlessness1245485__endlessness
facelessness1786055_facelessness
fathomlessness2261555fathomlessness
fearlessness1545765_fearlessness
fecklessness2154485_fecklessness
fencelessness1854075fencelessness
flawlessness1854125_flawlessness
foodlessness1644745_foodlessness
formlessness1744715_formlessness
friendlessness1852205friendlessness
gracelessness1664765gracelessness
guilelessness1453925guilelessness
gutlessnesses1346945__gutlessnesses
hairlessness1545305_hairlessness
haplessness1645665__haplessness
harmlessness1745055_harmlessness
headlessness16105965_headlessness
heedlessness1685025_heedlessness
helplessness1754475_helplessness
highnesses1746085high_ness_e_s
homelessness1746105_homelessness
hopelessness1745755_hopelessness
hornlessness1545165_hornlessness
houselessness15104925houselessness
humorlessness1853165humorlessness
joblessness2044815__joblessness
joylessness2144295__joylessness
knightliness2052735knightl__iness
landlessness1345715_landlessness
lawlessness1444895__lawlessness
lighteners1444985light_e__ners
lightless1386075lightl____ess
lightness13107435light____ness
lightsomeness1982015lightsomeness
limitlessnesses1654285limitlessnesses
listlessnesses1266935li_stlessnesses
littleness1045025li_ttle__ness
lovelessness1545735_lovelessness
mercilessness1753465mercilessness
mightiness1645095might___iness
mightinesses1844385mightiness_e_s
motherlessness1952235motherlessness
movelessness1745305_movelessness
namelessness1445615_namelessness
needlessness1374685_needlessness
nervelessness1653725nervelessness
nighnesses1446465nigh_ness_e_s
nightdresses1752205nightdress_e_s
nightless1386075nightl____ess
objectlessness2561545objectlessness
painlessness1445455_painlessness
planlessness1444995_planlessness
powerlessness1853195powerlessness
raylessness1445115__raylessness
recklessness1854655_recklessness
regardlessness1662125regardlessness
relentlessness1452615relentlessness
rightfulness1994895right_fulness
rightness13117355right____ness
shiftlessnesses1954995shiftlessnesses
sighless1276555sigh_l____ess
sightliest1445115sightl___iest
sightline1345685sightl__ine__
sightseers1452545sight___seers
sightsees1344545sight___s_ees
silentness1044575si___lentness
simpleness1445175si_mple__ness
singleness1145745si_ngle__ness
sinlessnesses1157985si__nlessnesses
sizableness2265595sizable__ness
slightness1454805slight____ness
speechlessness2081605speechlessness
spotlessnesses1456275s_potlessnesses
sprightliness1962095sprightl__iness
stressless942765s___tressless
stresslessness061775stresslessness
subtleness1245445s_ubtle__ness
tastelessness1254195tastelessness
thanklessness2053835thanklessness
thriftlessness2062255thriftlessness
tighteners1444045tight_e__ners
tightness1386605tight____ness
tonelessness1246245_tonelessness
toplessness1345405__toplessness
unsightliness1762515unsightl__iness
uselessness1075995__uselessness
valuelessness1653455valuelessness
voicelessness1854065voicelessness
waterlessness1653855waterlessness
witlessnesses1547235wi__tlessnesses
wordlessness1644715_wordlessness
worklessness1954105_worklessness

Search took 10 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 Filter1786911247900.390458182.1
2DLD Change Limit1247901749.39313285.4
3Display Results1741740.1101581.8
 (SQL Overall)1786911749.89318062.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.