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 “harmlessness” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
harmlessness174505(None) 
aimlessness1345672_aimlessness
artlessness1146432_artlessness
carelessness1446542carelessness
formlessness1744712formlessness
hairlessness1545302hairlessness
haplessness1645662ha_plessness
harmlessnesses1876412harmlessnesses
heartlessness1665172heartlessness
hornlessness1545162hornlessness
agelessness1246073_agelessness
airlessness1146253_airlessness
facelessness1786053facelessness
fearlessness1545763fear_lessness
headlessness16105963headlessness
heedlessness1685023heedlessness
helplessness1754473helplessness
homelessness1746103homelessness
hopelessness1745753hopelessness
landlessness1345713landlessness
lawlessness1444893la_wlessness
namelessness1445613namelessness
painlessness1445443painlessness
pathlessness1754903pathlessness
raylessness1445113ra_ylessness
saplessness1245983sa_plessness
seamlessness1355903seamlessness
shamelessness1754963shamelessness
shapelessness1754963shapelessness
tactlessness1445413tactlessness
thanklessness2053833thanklessness
tirelessness1245933tirelessness
wordlessness1644713wordlessness
worklessness1954103worklessness
aimlessnesses1487464_aimlessnesses
artlessnesses1247664_artlessnesses
blamelessness1754544blamelessness
bootlessness1445454bootlessness
brainlessness1554184brainlessness
carelessnesses1547724carelessnesses
ceaselessness1455114ceaselessness
changelessness2062774changelessness
cheerlessness1853704cheerlessness
childlessness1963874childlessness
classlessness1353734classlessness
dauntlessness1453774dauntlessness
deathlessness1754324deathlessness
dreamlessness1673814dreamlessness
earnestness1152814ear_nestness
endlessness1245484_endlessness
faithlessness1953974faithlessness
fathomlessness2261554fathomlessness
faultlessness1653944faultlessness
fecklessness2154484fecklessness
flawlessness1854124flawlessness
foodlessness1644744foodlessness
footlessness1545614footlessness
formlessnesses1856124formlessnesses
godlessness1355434_godlessness
gracelessness1664764gracelessness
gutlessness1246014_gutlessness
hairlessnesses16126634hairlessnesses
haleness11312624ha__le__ness
haplessnesses1747254ha_plessnesses
hardnesses141810544hardness_e_s
harmfulness1984284harm_fulness
harmless1337404harml____ess
harmlessly1842784harmless__ly
harnesses121812074har_ness_e_s
harshness1545964har___shness
heartlessnesses1765774heartlessnesses
hornlessnesses1656274hornlessnesses
houselessness15104924houselessness
humorlessness1853164humorlessness
joblessness2044814_joblessness
joylessness2144294_joylessness
lifelessness1545294lifelessness
listlessness1145824listlessness
lovelessness1545734lovelessness
mercilessness1753464mercilessness
mindlessness1554854mindlessness
movelessness1745304movelessness
needlessness1374684needlessness
nervelessness1653724nervelessness
pitilessness1474524pitilessness
planlessness1444994planlessness
plotlessness1445084plotlessness
recklessness1854654recklessness
regardlessness1662124regardlessness
restlessness1146514restlessness
rootlessness1245614rootlessness
ruthlessness1554314ruthlessness
selflessness1444594selflessness
sexlessness1745314_sexlessness
shiftlessness1854004shiftlessness
sinlessness1046724_sinlessness
skillessness1554234skillessness
soullessness1145544soullessness
spotlessness1345324spotlessness
statelessness1255144statelessness
tastelessness1254194tastelessness
timelessness1445784timelessness
tonelessness1246244tonelessness
toplessness1345404_toplessness
uselessness1075994_uselessness
valuelessness1653454valuelessness
warmnesses15167354warmness_e_s
waterlessness1653854waterlessness
winglessness1654324winglessness
witlessness1446264_witlessness
worthlessness1953654worthlessness

Search took 8 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 Filter1786911247900.390458182.1
2DLD Change Limit1247901117.19017356.1
3Display Results1111110.0601850.0
 (SQL Overall)1786911117.64023388.9
 
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.