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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 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
shamelessness175496(None) 
shapelessness1754961shapelessness
blamelessness1754542blamelessness
homelessness1746102_homelessness
namelessness1445612_namelessness
seamlessness1355902seam_lessness
shamelessnesses18186512shamelessnesses
statelessness1255142statelessness
agelessness1246073__agelessness
carelessness1446543_carelessness
ceaselessness1455113ceaselessness
changelessness2062773changelessness
facelessness1786053_facelessness
gracelessness1664763gracelessness
hairlessness1545303_hairlessness
haplessness1645663_ha_plessness
harmlessness1745053_harmlessness
hopelessness1745753_hopelessness
saplessness1245983s_a_plessness
senselessness1154733senselessness
shapelessnesses18156293shapelessnesses
shiftlessness1854003shiftlessness
spinelessness1454403spinelessness
stylelessness1553413stylelessness
thanklessness2053833thanklessness
timelessness1445783_timelessness
aimlessness1345674__aimlessness
airlessness1146254__airlessness
artlessness1146434__artlessness
blamelessnesses1865714blamelessnesses
brainlessness1554184brainlessness
cheerlessness1853704cheerlessness
childlessness1963874childlessness
classlessness1353734classlessness
deathlessness1754324deathlessness
dreamlessness1673814dream_lessness
fearlessness1545764fea_rlessness
fencelessness1854074fencelessness
flawlessness1854124fla_wlessness
formlessness1744714form_lessness
guilelessness1453924guilelessness
headlessness16105964_headlessness
heartlessness1665174heartlessness
heedlessness1685024_heedlessness
helplessness1754474_helplessness
homelessnesses18137474_homelessnesses
hornlessness1545164_hornlessness
houselessness15104924houselessness
humorlessness1853164_humorlessness
landlessness1345714_landlessness
lawlessness1444894_la_wlessness
lifelessness1545294_lifelessness
lovelessness1545734_lovelessness
movelessness1745304_movelessness
namelessnesses1577054_namelessnesses
nervelessness1653724nervelessness
painlessness1445444_painlessness
pathlessness1754904_pathlessness
planlessness1444994pla_nlessness
raylessness1445114_ra_ylessness
samenesses12410854s_ameness_e_s
seamlessnesses1446974seam_lessnesses
selflessness1444594s_elflessness
sexlessness1745314s__exlessness
shamefulness2074154shame_fulness
shameless1435924shamel____ess
shamelessly1962414shameless__ly
shapeliness1663164shapel__iness
sightlessness1654154sightlessness
sinlessness1046724s__inlessness
skillessness1554234s_killessness
sleeplessness1453554sleeplessness
soullessness1145544s_oullessness
spotlessness1345324s_potlessness
statelessnesses1355864statelessnesses
tactlessness1445414_tactlessness
tastelessness1254194tastelessness
tirelessness1245934_tirelessness
tonelessness1246244_tonelessness
uselessness1075994__uselessness
valuelessness1653454valuelessness
voicelessness1854064voicelessness
waterlessness1653854_waterlessness

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 Filter178691950240.703254183.5
2DLD Change Limit95024835.86016215.7
3Display Results83830.0461804.3
 (SQL Overall)178691836.60927037.5
 
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.