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
fencelessnesses1995341fencelessnesses_
facelessnesses1847313f_acelessnesses_
fecklessnesses2255483fe_cklessnesses_
fencelessness1854073fencelessne_s_s_
senselessnesses055693senselessnesses_
ceaselessnesses1596154ceaselessnesses_
endlessnesses1356754_en_dlessnesses_
fearlessnesses1666724fe_arlessnesses_
gracelessnesses1755894gracelessnesses_
mercilessnesses18104524mercilessnesses_
nervelessnesses1754954nervelessnesses_
recklessnesses1955834re_cklessnesses_
tonelessnesses13137634ton_elessnesses_
voicelessnesses1955304voicelessnesses_
agelessnesses1387615__agelessnesses_
blamelessnesses1865705blamelessnesses_
carelessnesses1547715_carelessnesses_
deathlessnesses1885165deathlessnesses_
facelessness1786055f_acelessne_s_s_
faithlessnesses2074965faithlessnesses_
faultlessnesses1754925faultlessnesses_
fecklessness2154485fe_cklessne_s_s_
flawlessnesses1975445f_lawlessnesses_
foodlessnesses1755755f_oodlessnesses_
footlessnesses1656555f_ootlessnesses_
formlessnesses1856105f_ormlessnesses_
fruitlessnesses1754865fruitlessnesses_
guilelessnesses15195305guilelessnesses_
headlessnesses17137055he_adlessnesses_
heartlessnesses1765765heartlessnesses_
heedlessnesses17136215he_edlessnesses_
helplessnesses1855795he_lplessnesses_
homelessnesses18137465_homelessnesses_
hopelessnesses18147005_hopelessnesses_
houselessnesses1665655houselessnesses_
landlessnesses1456675lan_dlessnesses_
lifelessnesses1646645_lifelessnesses_
lovelessnesses1646985_lovelessnesses_
mindlessnesses1686005min_dlessnesses_
movelessnesses1846735_movelessnesses_
namelessnesses1577045_namelessnesses_
needlessnesses14115685ne_edlessnesses_
restlessnesses1257215re_stlessnesses_
seamlessnesses1446965se_amlessnesses_
selflessnesses15115985se_lflessnesses_
senselessness1154735senselessne_s_s_
sexlessnesses1846735se__xlessnesses_
shamelessnesses18186505shamelessnesses_
shapelessnesses18156285shapelessnesses_
sinlessnesses1157965sin__lessnesses_
spinelessnesses1555485spinelessnesses_
statelessnesses1355855statelessnesses_
stylelessnesses1674705stylelessnesses_
tactlessnesses1546545_tactlessnesses_
tastelessnesses1355265tastelessnesses_
timelessnesses1547015_timelessnesses_
tirelessnesses1357005_tirelessnesses_
uselessnesses1147295__uselessnesses_
valuelessnesses1764785valuelessnesses_
winglessnesses1765455win_glessnesses_
aimlessnesses1487456__aimlessnesses_
airlessnesses12117986__airlessnesses_
artlessnesses1247656__artlessnesses_
bloodlessnesses1764316bloodlessnesses_
bootlessnesses1556436_bootlessnesses_
boundlessnesses1774906boundlessnesses_
brainlessnesses1665006brainlessnesses_
ceaselessness1455116ceaselessne_s_s_
centerednesses1753816centere_dnesses_
cheerlessnesses1954536cheerlessnesses_
childlessnesses20104936childlessnesses_
classlessnesses054826classlessnesses_
cloudlessnesses1764856cloudlessnesses_
colorlessnesses1665086colorlessnesses_
dauntlessnesses1554806dauntlessnesses_
defenselessness1861426defenselessne_s_s_
doubtlessnesses1764916doubtlessnesses_
dreamlessnesses17104526dreamlessnesses_
endlessness1245486_en_dlessne_s_s_
facilenesses1756706f_acile__nesses_
fearlessness1545756fe_arlessne_s_s_
feeblenesses1745526fe_eble__nesses_
feelingnesses1753516fe__elingnesses_
femalenesses1746846fe_male__nesses_
fertilenesses1648006fertile__nesses_
feverishnesses2382866fe_verishnesses_
ficklenesses2144136f_ickle__nesses_
generousnesses1556926gen_erousnesses_
genteelnesses1453526gente_e_lnesses_
gentlenesses1366006gen_tle__nesses_
godlessnesses1446576__godlessnesses_
gracelessness1664756gracelessne_s_s_
guiltlessnesses15174916guiltlessnesses_
gutlessnesses1346926__gutlessnesses_
hairlessnesses16126626_hairlessnesses_
haplessnesses1747246__haplessnesses_
harmlessnesses1876406_harmlessnesses_
hornlessnesses1656266_hornlessnesses_
humorlessnesses1954176humorlessnesses_
joblessnesses2155976__joblessnesses_
joylessnesses2255636__joylessnesses_
lawlessnesses1546376__lawlessnesses_
limitlessnesses1654276limitlessnesses_
listlessnesses1266916_listlessnesses_
mercilessness1753466mercilessne_s_s_
nervelessness1653726nervelessne_s_s_
painlessnesses1546726_painlessnesses_
pathlessnesses1855946_pathlessnesses_
pendulousnesses1854236pendulousnesses_
pitilessnesses1575736_pitilessnesses_
planlessnesses1576296_planlessnesses_
plotlessnesses1556086_plotlessnesses_
pointlessnesses1655436pointlessnesses_
powerlessnesses1954476powerlessnesses_
raylessnesses1546496__raylessnesses_
recklessness1854646re_cklessne_s_s_
rootlessnesses1346586_rootlessnesses_
ruthlessnesses1665366_ruthlessnesses_
saplessnesses1347266__saplessnesses_
shiftlessnesses1954986shiftlessnesses_
sightlessnesses1755026sightlessnesses_
sincerenesses1554726sincere__nesses_
skillessnesses1655606_skillessnesses_
sleeplessnesses1554676sleeplessnesses_
soullessnesses1296486_soullessnesses_
spotlessnesses1456266_spotlessnesses_
tenablenesses1546626tenable__nesses_
thanklessnesses2154796thanklessnesses_
tonelessness1246226ton_elessne_s_s_
toplessnesses1446566__toplessnesses_
uncleannesses1553036_unc_leannesses_
voicelessness1854066voicelessne_s_s_
waterlessnesses1754716waterlessnesses_
witlessnesses1547226__witlessnesses_
wordlessnesses1775866_wordlessnesses_
worklessnesses20125476_worklessnesses_
worthlessnesses2054546worthlessnesses_

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 Limit658741375.22012619.5
3Display Results1371370.1101245.5
 (SQL Overall)1786911375.42332950.6
 
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.