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

147 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
senselessnesses05569(None) 
ceaselessnesses1596152ceaselessnesses
fencelessnesses1995342fencelessnesses
senselessness1154732senselessne_s_s
endlessnesses1356753_en_dlessnesses
houselessnesses1665653houselessnesses
nervelessnesses1754953nervelessnesses
restlessnesses1257213re_stlessnesses
seamlessnesses1446963se_amlessnesses
selflessnesses15115983se_lflessnesses
sexlessnesses1846733se__xlessnesses
shamelessnesses18186503shamelessnesses
shapelessnesses18156283shapelessnesses
sinlessnesses1157963sin__lessnesses
spinelessnesses1555483spinelessnesses
statelessnesses1355853statelessnesses
stylelessnesses1674703stylelessnesses
tonelessnesses13137633ton_elessnesses
uselessnesses1147293__uselessnesses
agelessnesses1387614__agelessnesses
blamelessnesses1865704blamelessnesses
carelessnesses1547714_carelessnesses
ceaselessness1455114ceaselessne_s_s
classlessnesses054824classlessnesses
deathlessnesses1885164deathlessnesses
facelessnesses1847314_facelessnesses
fearlessnesses1666724fe_arlessnesses
fecklessnesses2255484fe_cklessnesses
fencelessness1854074fencelessne_s_s
gracelessnesses1755894gracelessnesses
guilelessnesses15195304guilelessnesses
headlessnesses17137054he_adlessnesses
heartlessnesses1765764heartlessnesses
heedlessnesses17136214he_edlessnesses
helplessnesses1855794he_lplessnesses
homelessnesses18137464_homelessnesses
hopelessnesses18147004_hopelessnesses
landlessnesses1456674lan_dlessnesses
lifelessnesses1646644_lifelessnesses
listlessnesses1266914_listlessnesses
lovelessnesses1646984_lovelessnesses
mercilessnesses18104524mercilessnesses
mindlessnesses1686004min_dlessnesses
movelessnesses1846734_movelessnesses
namelessnesses1577044_namelessnesses
needlessnesses14115684ne_edlessnesses
recklessnesses1955834re_cklessnesses
saplessnesses1347264s__aplessnesses
sensiblenesses1555224sensible__nesses
sensuousnesses12115584sens_uousnesses
shiftlessnesses1954984shiftlessnesses
sightlessnesses1755024sightlessnesses
skillessnesses1655604s_killessnesses
sleeplessnesses1554674sleeplessnesses
soullessnesses1296484s_oullessnesses
spotlessnesses1456264s_potlessnesses
tastelessnesses1355264tastelessnesses
timelessnesses1547014_timelessnesses
tirelessnesses1357004_tirelessnesses
valuelessnesses1764784valuelessnesses
voicelessnesses1955304voicelessnesses
winglessnesses1765454win_glessnesses
aimlessnesses1487455__aimlessnesses
airlessnesses12117985__airlessnesses
artlessnesses1247655__artlessnesses
bloodlessnesses1764315bloodlessnesses
bootlessnesses1556435_bootlessnesses
boundlessnesses1774905boundlessnesses
brainlessnesses1665005brainlessnesses
centerednesses1753815centere_dnesses
cheerlessnesses1954535cheerlessnesses
childlessnesses20104935childlessnesses
cloudlessnesses1764855cloudlessnesses
colorlessnesses1665085colorlessnesses
dauntlessnesses1554805dauntlessnesses
defenselessness1861425defenselessne_s_s
densenesses1247355dens__e__nesses
doubtlessnesses1764915doubtlessnesses
dreamlessnesses17104525dreamlessnesses
endlessness1245485_en_dlessne_s_s
faithlessnesses2074965faithlessnesses
faultlessnesses1754925faultlessnesses
flawlessnesses1975445_flawlessnesses
foodlessnesses1755755_foodlessnesses
footlessnesses1656555_footlessnesses
formlessnesses1856105_formlessnesses
fruitlessnesses1754865fruitlessnesses
generousnesses1556925gen_erousnesses
genteelnesses1453525gente_e_lnesses
gentlenesses1366005gen_tle__nesses
godlessnesses1446575__godlessnesses
guiltlessnesses15174915guiltlessnesses
gutlessnesses1346925__gutlessnesses
hairlessnesses16126625_hairlessnesses
haplessnesses1747245__haplessnesses
harmlessnesses1876405_harmlessnesses
hornlessnesses1656265_hornlessnesses
houselessness15104905houselessne_s_s
humorlessnesses1954175humorlessnesses
joblessnesses2155975__joblessnesses
joylessnesses2255635__joylessnesses
lawlessnesses1546375__lawlessnesses
limitlessnesses1654275limitlessnesses
nervelessness1653725nervelessne_s_s
painlessnesses1546725_painlessnesses
pathlessnesses1855945_pathlessnesses
pendulousnesses1854235pendulousnesses
pensivenesses1848955pensive__nesses
pitilessnesses1575735_pitilessnesses
planlessnesses1576295_planlessnesses
plotlessnesses1556085_plotlessnesses
pointlessnesses1655435pointlessnesses
powerlessnesses1954475powerlessnesses
raylessnesses1546495__raylessnesses
restlessness1146495re_stlessne_s_s
rootlessnesses1346585_rootlessnesses
ruthlessnesses1665365_ruthlessnesses
seamlessness1355895se_amlessne_s_s
sedulousnesses1455545se_dulousnesses
selectnesses1446105___selectnesses
selflessness1444595se_lflessne_s_s
sensitivenesses1775305sensitivenesses
serenenesses12117095se_rene__nesses
servilenesses1646265servile__nesses
severenesses1545585se_vere__nesses
sexlessness1745315se__xlessne_s_s
shamelessness1754965shamelessne_s_s
shapelessness1754965shapelessne_s_s
sincerenesses1554725sincere__nesses
singlenesses1346095sin_gle__nesses
sinlessness1046715sin__lessne_s_s
spinelessness1454405spinelessne_s_s
statelessness1255145statelessne_s_s
stylelessness1553415stylelessne_s_s
tactlessnesses1546545_tactlessnesses
tenablenesses1546625tenable__nesses
tensenesses1147595tens__e__nesses
thanklessnesses2154795thanklessnesses
tonelessness1246225ton_elessne_s_s
toplessnesses1446565__toplessnesses
unselfishnesses2061515_unselfishnesses
uselessness1075985__uselessne_s_s
waterlessnesses1754715waterlessnesses
witlessnesses1547225__witlessnesses
wordlessnesses1775865_wordlessnesses
worklessnesses20125475_worklessnesses
worthlessnesses2054545worthlessnesses

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 Filter178691658740.1101624463.6
2DLD Change Limit658741476.06310864.9
3Display Results1471470.1101336.4
 (SQL Overall)1786911476.28328440.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.