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

137 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
fencelessnesses1995351fencelessnesses_
facelessnesses1847323f_acelessnesses_
fecklessnesses2255493fe_cklessnesses_
fencelessness1854073fencelessne_s_s_
senselessnesses055703senselessnesses_
ceaselessnesses1596164ceaselessnesses_
endlessnesses1356764_en_dlessnesses_
fearlessnesses1666744fe_arlessnesses_
gracelessnesses1755904gracelessnesses_
mercilessnesses18104534mercilessnesses_
nervelessnesses1754984nervelessnesses_
recklessnesses1955844re_cklessnesses_
tonelessnesses13137654ton_elessnesses_
voicelessnesses1955314voicelessnesses_
agelessnesses1387625__agelessnesses_
blamelessnesses1865715blamelessnesses_
carelessnesses1547725_carelessnesses_
deathlessnesses1885175deathlessnesses_
facelessness1786055f_acelessne_s_s_
faithlessnesses2074975faithlessnesses_
faultlessnesses1754935faultlessnesses_
fecklessness2154485fe_cklessne_s_s_
flawlessnesses1975455f_lawlessnesses_
foodlessnesses1755765f_oodlessnesses_
footlessnesses1656565f_ootlessnesses_
formlessnesses1856125f_ormlessnesses_
fruitlessnesses1754895fruitlessnesses_
guilelessnesses15195315guilelessnesses_
headlessnesses17137065he_adlessnesses_
heartlessnesses1765775heartlessnesses_
heedlessnesses17136225he_edlessnesses_
helplessnesses1855805he_lplessnesses_
homelessnesses18137475_homelessnesses_
hopelessnesses18147015_hopelessnesses_
houselessnesses1665675houselessnesses_
landlessnesses1456685lan_dlessnesses_
lifelessnesses1646655_lifelessnesses_
lovelessnesses1646995_lovelessnesses_
mindlessnesses1686015min_dlessnesses_
movelessnesses1846745_movelessnesses_
namelessnesses1577055_namelessnesses_
needlessnesses14115695ne_edlessnesses_
restlessnesses1257235re_stlessnesses_
seamlessnesses1446975se_amlessnesses_
selflessnesses15115995se_lflessnesses_
senselessness1154735senselessne_s_s_
sexlessnesses1846745se__xlessnesses_
shamelessnesses18186515shamelessnesses_
shapelessnesses18156295shapelessnesses_
sinlessnesses1157985sin__lessnesses_
spinelessnesses1555495spinelessnesses_
statelessnesses1355865statelessnesses_
stylelessnesses1674715stylelessnesses_
tactlessnesses1546555_tactlessnesses_
tastelessnesses1355275tastelessnesses_
timelessnesses1547025_timelessnesses_
tirelessnesses1357015_tirelessnesses_
uselessnesses1147315__uselessnesses_
valuelessnesses1764795valuelessnesses_
winglessnesses1765465win_glessnesses_
aimlessnesses1487466__aimlessnesses_
airlessnesses12117996__airlessnesses_
artlessnesses1247666__artlessnesses_
bloodlessnesses1764326bloodlessnesses_
bootlessnesses1556456_bootlessnesses_
boundlessnesses1774926boundlessnesses_
brainlessnesses1665026brainlessnesses_
ceaselessness1455116ceaselessne_s_s_
centerednesses1753846centere_dnesses_
cheerlessnesses1954546cheerlessnesses_
childlessnesses20104946childlessnesses_
classlessnesses054836classlessnesses_
cloudlessnesses1764876cloudlessnesses_
colorlessnesses1665096colorlessnesses_
dauntlessnesses1554816dauntlessnesses_
defenselessness1861426defenselessne_s_s_
doubtlessnesses1764936doubtlessnesses_
dreamlessnesses17104536dreamlessnesses_
endlessness1245486_en_dlessne_s_s_
facilenesses1756726f_acile__nesses_
fearlessness1545766fe_arlessne_s_s_
feeblenesses1745546fe_eble__nesses_
feelingnesses1753516fe__elingnesses_
femalenesses1746866fe_male__nesses_
fertilenesses1648036fertile__nesses_
feverishnesses2382886fe_verishnesses_
ficklenesses2144156f_ickle__nesses_
generousnesses1556946gen_erousnesses_
genteelnesses1453536gente_e_lnesses_
gentlenesses1366016gen_tle__nesses_
godlessnesses1446586__godlessnesses_
gracelessness1664766gracelessne_s_s_
guiltlessnesses15174926guiltlessnesses_
gutlessnesses1346946__gutlessnesses_
hairlessnesses16126636_hairlessnesses_
haplessnesses1747256__haplessnesses_
harmlessnesses1876416_harmlessnesses_
hornlessnesses1656276_hornlessnesses_
humorlessnesses1954186humorlessnesses_
joblessnesses2155996__joblessnesses_
joylessnesses2255646__joylessnesses_
lawlessnesses1546386__lawlessnesses_
limitlessnesses1654286limitlessnesses_
listlessnesses1266936_listlessnesses_
mercilessness1753466mercilessne_s_s_
nervelessness1653726nervelessne_s_s_
painlessnesses1546746_painlessnesses_
pathlessnesses1855956_pathlessnesses_
pendulousnesses1854246pendulousnesses_
pitilessnesses1575756_pitilessnesses_
planlessnesses1576306_planlessnesses_
plotlessnesses1556096_plotlessnesses_
pointlessnesses1655446pointlessnesses_
powerlessnesses1954496powerlessnesses_
raylessnesses1546506__raylessnesses_
recklessness1854656re_cklessne_s_s_
rootlessnesses1346606_rootlessnesses_
ruthlessnesses1665386_ruthlessnesses_
saplessnesses1347276__saplessnesses_
shiftlessnesses1954996shiftlessnesses_
sightlessnesses1755036sightlessnesses_
sincerenesses1554736sincere__nesses_
skillessnesses1655616_skillessnesses_
sleeplessnesses1554686sleeplessnesses_
soullessnesses1296506_soullessnesses_
spotlessnesses1456276_spotlessnesses_
tenablenesses1546656tenable__nesses_
thanklessnesses2154806thanklessnesses_
tonelessness1246246ton_elessne_s_s_
toplessnesses1446586__toplessnesses_
uncleannesses1553046_unc_leannesses_
voicelessness1854066voicelessne_s_s_
waterlessnesses1754726waterlessnesses_
witlessnesses1547236__witlessnesses_
wordlessnesses1775876_wordlessnesses_
worklessnesses20125486_worklessnesses_
worthlessnesses2054556worthlessnesses_

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.326548131.9
2DLD Change Limit658741375.18612702.3
3Display Results1371370.1101245.5
 (SQL Overall)1786911375.62231784.2
 
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.