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

107 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
purposelessness186114(None) 
purposefulness2161604purpose_fulness
purposeless1551474purposel____ess
purposelessly206894purposeless__ly
purposiveness2053594purposive__ness
uselessness1075994_u___selessness
carelessness1446545car___elessness
ceaselessness1455115__ceaselessness
defenselessness1861425defenselessness
futurelessness1761955fu_turelessness
gracelessness1664765_gr_acelessness
guilelessness1453925gu__ilelessness
homelessness1746105___homelessness
hopelessness1745755___hopelessness
houselessness15104925__houselessness
humorlessness1853165hu_mo_rlessness
lovelessness1545735___lovelessness
movelessness1745305___movelessness
nervelessness1653725ner__velessness
plotlessness1445085p__lo_tlessness
powerlessness1853195___powerlessness
purposivenesses2263655purposiveness_e_s
remorselessness1661545remorselessness
restlessness1146515__r_estlessness
rootlessness1245615__r_ootlessness
senselessness1154735__senselessness
shapelessness1754965shap__elessness
spinelessness1454405__spinelessness
spotlessness1345325__spo_tlessness
stresslessness061775str_esslessness
tirelessness1245935tir___elessness
tonelessness1246245___tonelessness
agelessness1246086____agelessness
airlessness1146266air____lessness
artlessness1146446_ar___tlessness
blamelessness1754546__blamelessness
bloodlessness1653506__bloodlessness
bootlessness1445456___bootlessness
bottomlessness1891406botto_mlessness
brainlessness1554196_br_ainlessness
breathlessness1952796_breathlessness
changelessness2062776_changelessness
classlessness1353736__classlessness
cloudlessness1653846__cloudlessness
colorlessness1553906_colo_rlessness
dreamlessness1673816_dr_eamlessness
effortlessness2061896_effortlessness
exhaustlessness2461086exhaustlessness
facelessness1786056___facelessness
fathomlessness2261556fatho_mlessness
fencelessness1854076__fencelessness
foodlessness1644746___foodlessness
footlessness1545616___footlessness
formlessness1744716___formlessness
friendlessness1852206_friendlessness
fruitlessness1654196_fr_uitlessness
godlessness1355436___go_dlessness
groundlessness16102596_groundlessness
guiltlessness1453776gu__iltlessness
gutlessness1246016gu____tlessness
haplessness1645666_hap___lessness
harmlessness1745056har___mlessness
helplessness1754476help___lessness
hornlessness1545166___hornlessness
joblessness2044816___jo_blessness
joylessness2144296___jo_ylessness
lifelessness1545296___lifelessness
listlessness1145826___listlessness
mercilessness1753466mer__cilessness
morosenesses1446866mor_oseness_e_s
motionlessness16122156motio_nlessness
namelessness1445616___namelessness
operosenesses1575326oper_oseness_e_s
painlessness1445456___painlessness
pathlessness1754906___pathlessness
pitilessness1474526___pitilessness
planlessness1444996___planlessness
pointlessness1554616p__ointlessness
prepossesses1552916prepos_sess_e_s
pronenesses1379266p_r_oneness_e_s
prophetesses1952446p_rophetess_e_s
prosinesses13310866p_r_osiness_e_s
prosperousness1862796p_r_osperousness
purenesses12810746pur___eness_e_s
pursinesses1338766pur__siness_e_s
raylessness1445116__r__aylessness
recklessness1854656__r_ecklessness
resistlessness1282606_resistlessness
ruthlessness1554316__r_uthlessness
saplessness1245986_sap___lessness
sexlessness1745316_____sexlessness
shamelessness1754966__shamelessness
soullessness1145546___soullessness
spiritlessness1582566spir__itlessness
statelessness1255146__statelessness
stylelessness1553416__stylelessness
tastelessness1254196__tastelessness
thriftlessness2062256thr_iftlessness
timelessness1445786___timelessness
toplessness1345406___to_plessness
uselessnesses1147316_u___selessnesses
valuelessness1653456__valuelessness
verbosenesses1853306verboseness_e_s
voicelessness1854066__voicelessness
wordlessness1644716___wordlessness
worklessness1954106___worklessness
worthlessness1953656wor__thlessness

Search took 10 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.390458182.1
2DLD Change Limit950241078.51611158.3
3Display Results1071070.0931150.5
 (SQL Overall)1786911078.99919856.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.