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

144 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
ceaselessnesses1596151ceaselessnesses_
carelessnesses1547713c_arelessnesses_
ceaselessness1455113ceaselessne_s_s_
classlessnesses054823classlessnesses_
senselessnesses055693senselessnesses_
agelessnesses1387614__agelessnesses_
blamelessnesses1865704blamelessnesses_
deathlessnesses1885164deathlessnesses_
facelessnesses1847314_facelessnesses_
fearlessnesses1666724fea_rlessnesses_
fencelessnesses1995344fencelessnesses_
gracelessnesses1755894gracelessnesses_
headlessnesses17137054hea_dlessnesses_
heartlessnesses1765764heartlessnesses_
houselessnesses1665654houselessnesses_
namelessnesses1577044_namelessnesses_
nervelessnesses1754954nervelessnesses_
restlessnesses1257214re_stlessnesses_
seamlessnesses1446964sea_mlessnesses_
shamelessnesses18186504shamelessnesses_
shapelessnesses18156284shapelessnesses_
statelessnesses1355854statelessnesses_
tastelessnesses1355264_tastelessnesses_
uselessnesses1147294__uselessnesses_
aimlessnesses1487455__aimlessnesses_
airlessnesses12117985__airlessnesses_
artlessnesses1247655__artlessnesses_
brainlessnesses1665005brainlessnesses_
carelessness1446545c_arelessne_s_s_
cheerlessnesses1954535cheerlessnesses_
childlessnesses20104935childlessnesses_
classlessness1353735classlessne_s_s_
cloudlessnesses1764855cloudlessnesses_
colorlessnesses1665085colorlessnesses_
dreamlessnesses17104525drea_mlessnesses_
endlessnesses1356755_e_ndlessnesses_
fecklessnesses2255485fe_cklessnesses_
flawlessnesses1975445fla_wlessnesses_
guilelessnesses15195305guilelessnesses_
hairlessnesses16126625_hairlessnesses_
haplessnesses1747245_ha_plessnesses_
harmlessnesses1876405_harmlessnesses_
heedlessnesses17136215he_edlessnesses_
helplessnesses1855795he_lplessnesses_
homelessnesses18137465_homelessnesses_
hopelessnesses18147005_hopelessnesses_
landlessnesses1456675_landlessnesses_
lawlessnesses1546375_la_wlessnesses_
lifelessnesses1646645_lifelessnesses_
listlessnesses1266915_listlessnesses_
lovelessnesses1646985_lovelessnesses_
mercilessnesses18104525mercilessnesses_
movelessnesses1846735_movelessnesses_
needlessnesses14115685ne_edlessnesses_
painlessnesses1546725_painlessnesses_
pathlessnesses1855945_pathlessnesses_
planlessnesses1576295pla_nlessnesses_
raylessnesses1546495_ra_ylessnesses_
recklessnesses1955835re_cklessnesses_
saplessnesses1347265_sa_plessnesses_
selflessnesses15115985se_lflessnesses_
senselessness1154735senselessne_s_s_
sexlessnesses1846735se__xlessnesses_
spinelessnesses1555485spinelessnesses_
stylelessnesses1674705stylelessnesses_
tactlessnesses1546545_tactlessnesses_
thanklessnesses2154795thanklessnesses_
timelessnesses1547015_timelessnesses_
tirelessnesses1357005_tirelessnesses_
tonelessnesses13137635_tonelessnesses_
valuelessnesses1764785valuelessnesses_
voicelessnesses1955305voicelessnesses_
waterlessnesses1754715_waterlessnesses_
agelessness1246076__agelessne_s_s_
beastlinesses1563426beastl__inesses_
blamelessness1754536blamelessne_s_s_
bloodlessnesses1764316bloodlessnesses_
bootlessnesses1556436_bootlessnesses_
boundlessnesses1774906boundlessnesses_
callousnesses1556446c_a_llousnesses_
centerednesses1753816centere_dnesses_
changelessness2062776changelessne_s_s_
chastenesses1746306chas_te__nesses_
cheesinesses1765376c__he_esinesses_
classinesses1366116clas___sinesses_
crassnesses1246656cra____ssnesses_
dauntlessnesses1554806dauntlessnesses_
deathlessness1754326deathlessne_s_s_
doubtlessnesses1764916doubtlessnesses_
earnestnesses1353646_ea_rnestnesses_
facelessness1786056_facelessne_s_s_
faithlessnesses2074966faithlessnesses_
faultlessnesses1754926faultlessnesses_
fearlessness1545756fea_rlessne_s_s_
fencelessness1854076fencelessne_s_s_
foodlessnesses1755756_foodlessnesses_
footlessnesses1656556_footlessnesses_
formlessnesses1856106_formlessnesses_
fruitlessnesses1754866fruitlessnesses_
gaseousnesses1356696_gase_ousnesses_
godlessnesses1446576__godlessnesses_
gracelessness1664756gracelessne_s_s_
guiltlessnesses15174916guiltlessnesses_
gutlessnesses1346926__gutlessnesses_
headlessness16105956hea_dlessne_s_s_
heartlessness1665166heartlessne_s_s_
hornlessnesses1656266_hornlessnesses_
houselessness15104906houselessne_s_s_
humorlessnesses1954176humorlessnesses_
jealousnesses2056306jea__lousnesses_
joblessnesses2155976__joblessnesses_
joylessnesses2255636__joylessnesses_
limitlessnesses1654276limitlessnesses_
mindlessnesses1686006_mindlessnesses_
namelessness1445616_namelessne_s_s_
nervelessness1653726nervelessne_s_s_
pitilessnesses1575736_pitilessnesses_
plotlessnesses1556086_plotlessnesses_
pointlessnesses1655436pointlessnesses_
powerlessnesses1954476powerlessnesses_
restlessness1146496re_stlessne_s_s_
rootlessnesses1346586_rootlessnesses_
ruthlessnesses1665366_ruthlessnesses_
seamlessness1355896sea_mlessne_s_s_
selectnesses1446106___selectnesses_
shamelessness1754966shamelessne_s_s_
shapelessness1754966shapelessne_s_s_
shiftlessnesses1954986shiftlessnesses_
sightlessnesses1755026sightlessnesses_
sinlessnesses1157966__sinlessnesses_
skillessnesses1655606_skillessnesses_
sleeplessnesses1554676sleeplessnesses_
soullessnesses1296486_soullessnesses_
spotlessnesses1456266_spotlessnesses_
statelessness1255146statelessne_s_s_
tastelessness1254186_tastelessne_s_s_
toplessnesses1446566__toplessnesses_
uselessness1075986__uselessne_s_s_
winglessnesses1765456_winglessnesses_
witlessnesses1547226__witlessnesses_
wordlessnesses1775866_wordlessnesses_
worklessnesses20125476_worklessnesses_
worthlessnesses2054546worthlessnesses_
zealousnesses2256246zea__lousnesses_

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.0931921408.6
2DLD Change Limit658741446.6109965.8
3Display Results1441440.1261142.9
 (SQL Overall)1786911446.82926166.5
 
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.