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

134 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
sleeplessnesses155468(None) 
sleeplessness1453552sleeplessne_s_s
cheerlessnesses1954543cheerlessnesses
heedlessnesses17136223_heedlessnesses
helplessnesses1855803_helplessnesses
needlessnesses14115693_needlessnesses
saplessnesses1347273s__aplessnesses
seamlessnesses1446973s_eamlessnesses
selflessnesses15115993s_elflessnesses
sexlessnesses1846743s__exlessnesses
shapelessnesses18156293shapelessnesses
agelessnesses1387624_age_lessnesses
blamelessnesses1865714blamelessnesses
bloodlessnesses1764324bloodlessnesses
carelessnesses1547724care_lessnesses
classlessnesses054834classlessnesses
cloudlessnesses1764874cloudlessnesses
dreamlessnesses17104534dreamlessnesses
endlessnesses1356764__endlessnesses
facelessnesses1847324face_lessnesses
fearlessnesses1666744_fearlessnesses
fecklessnesses2255494_fecklessnesses
flawlessnesses1975454fl_awlessnesses
haplessnesses1747254__haplessnesses
headlessnesses17137064_headlessnesses
homelessnesses18137474home_lessnesses
hopelessnesses18147014hope_lessnesses
landlessnesses1456684_landlessnesses
lawlessnesses1546384_l_awlessnesses
lifelessnesses1646654_lifelessnesses
listlessnesses1266934_listlessnesses
lovelessnesses1646994_lovelessnesses
movelessnesses1846744move_lessnesses
namelessnesses1577054name_lessnesses
planlessnesses1576304pl_anlessnesses
plotlessnesses1556094pl_otlessnesses
powerlessnesses1954494powerlessnesses
recklessnesses1955844_recklessnesses
restlessnesses1257234_restlessnesses
senselessnesses055704senselessnesses
shamelessnesses18186514shamelessnesses
sheepishnesses2153014sheep_ishnesses
shiftlessnesses1954994shiftlessnesses
sightlessnesses1755034sightlessnesses
sinlessnesses1157984s__inlessnesses
skillessnesses1655614s_killessnesses
sleepinesses1445674sleep___inesses
soullessnesses1296504s_oullessnesses
spinelessnesses1555494spinelessnesses
spotlessnesses1456274s_potlessnesses
statelessnesses1355864statelessnesses
stylelessnesses1674714stylelessnesses
timelessnesses1547024time_lessnesses
tirelessnesses1357014tire_lessnesses
tonelessnesses13137654tone_lessnesses
toplessnesses1446584__toplessnesses
uselessnesses1147314_use_lessnesses
valuelessnesses1764794value_lessnesses
waterlessnesses1754724waterlessnesses
aimlessnesses1487465__aimlessnesses
airlessnesses12117995__airlessnesses
artlessnesses1247665__artlessnesses
bootlessnesses1556455_bootlessnesses
boundlessnesses1774925boundlessnesses
brainlessnesses1665025brainlessnesses
ceaselessnesses1596165ceaselessnesses
cheerlessness1853705cheerlessne_s_s
childlessnesses20104945childlessnesses
colorlessnesses1665095colorlessnesses
dauntlessnesses1554815dauntlessnesses
deathlessnesses1885175deathlessnesses
doubtlessnesses1764935doubtlessnesses
faithlessnesses2074975faithlessnesses
faultlessnesses1754935faultlessnesses
feeblenesses1745545_feeble__nesses
fencelessnesses1995355fencelessnesses
foodlessnesses1755765_foodlessnesses
footlessnesses1656565_footlessnesses
formlessnesses1856125_formlessnesses
fruitlessnesses1754895fruitlessnesses
godlessnesses1446585__godlessnesses
gracelessnesses1755905gracelessnesses
guilelessnesses15195315guilelessnesses
guiltlessnesses15174925guiltlessnesses
gutlessnesses1346945__gutlessnesses
hairlessnesses16126635_hairlessnesses
harmlessnesses1876415_harmlessnesses
heartlessnesses1765775heartlessnesses
heedlessness1685025_heedlessne_s_s
helplessness1754475_helplessne_s_s
hornlessnesses1656275_hornlessnesses
houselessnesses1665675houselessnesses
humorlessnesses1954185humorlessnesses
joblessnesses2155995__joblessnesses
joylessnesses2255645__joylessnesses
limitlessnesses1654285limitlessnesses
mercilessnesses18104535mercilessnesses
mindlessnesses1686015_mindlessnesses
needlessness1374685_needlessne_s_s
nervelessnesses1754985nervelessnesses
painlessnesses1546745_painlessnesses
pathlessnesses1855955_pathlessnesses
pitilessnesses1575755_pitilessnesses
pointlessnesses1655445pointlessnesses
raylessnesses1546505__raylessnesses
repletenesses1554495__repletenesses
rootlessnesses1346605_rootlessnesses
ruthlessnesses1665385_ruthlessnesses
saplessness1245985s__aplessne_s_s
seamlessness1355905s_eamlessne_s_s
sedulousnesses1455575s_edulousnesses
seemlinesses1445225s_eeml__inesses
selectnesses1446115s__e_lectnesses
selflessness1444595s_elflessne_s_s
sexlessness1745315s__exlessne_s_s
shapelessness1754965shapelessne_s_s
simplenesses1645625s_imple__nesses
sleeknesses1545275sl_e__e_knesses
slendernesses1453135sl_ende_rnesses
slipperinesses1851855sl_ipperinesses
speechlessness2081605speechlessne_s_s
steelinesses1246725stee_l__inesses
steepnesses1345925steep____nesses
supplenesses1643985s_upple__nesses
sweepingnesses2052065sweep_ingnesses
tactlessnesses1546555_tactlessnesses
tastelessnesses1355275tastelessnesses
thanklessnesses2154805thanklessnesses
voicelessnesses1955315voicelessnesses
winglessnesses1765465_winglessnesses
witlessnesses1547235__witlessnesses
wordlessnesses1775875_wordlessnesses
worklessnesses20125485_worklessnesses
worthlessnesses2054555worthlessnesses

Search took 5 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.313570897.8
2DLD Change Limit658741343.93616736.3
3Display Results1341340.0931440.9
 (SQL Overall)1786911344.34241154.1
 
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.