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

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

128 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
purposelessness1861141purposelessness_
purposefulness2161605purpose_fulness_
purposeless1551475purposel____ess_
purposelessly206895purposele_s__sly
purposiveness2053595purposive__ness_
uselessness1075995_u___selessness_
carelessness1446546car___elessness_
ceaselessness1455116__ceaselessness_
defenselessness1861426defenselessness_
futurelessness1761956fu_turelessness_
gracelessness1664766_gr_acelessness_
guilelessness1453926gu__ilelessness_
homelessness1746106___homelessness_
hopelessness1745756___hopelessness_
houselessness15104926__houselessness_
humorlessness1853166hu_mo_rlessness_
lovelessness1545736___lovelessness_
movelessness1745306___movelessness_
nervelessness1653726ner__velessness_
plotlessness1445086p__lo_tlessness_
powerlessness1853196___powerlessness_
purposivenesses2263656purposive__nesses
remorselessness1661546remorselessness_
restlessness1146516__r_estlessness_
rootlessness1245616__r_ootlessness_
senselessness1154736__senselessness_
shapelessness1754966shap__elessness_
spinelessness1454406__spinelessness_
spotlessness1345326__spo_tlessness_
stresslessness061776str_esslessness_
tirelessness1245936tir___elessness_
tonelessness1246246___tonelessness_
uselessnesses1147316_u___selessnesses
agelessness1246087____agelessness_
airlessness1146267air____lessness_
artlessness1146447_ar___tlessness_
blamelessness1754547__blamelessness_
bloodlessness1653507__bloodlessness_
bootlessness1445457___bootlessness_
bottomlessness1891407botto_mlessness_
brainlessness1554187_br_ainlessness_
breathlessness1952797_breathlessness_
carelessnesses1547727car___elessnesses
ceaselessnesses1596167__ceaselessnesses
changelessness2062777_changelessness_
classlessness1353737__classlessness_
cloudlessness1653847__cloudlessness_
colorlessness1553907_colo_rlessness_
dreamlessness1673817_dr_eamlessness_
effortlessness2061897_effortlessness_
exhaustlessness2461087exhaustlessness_
facelessness1786057___facelessness_
fathomlessness2261557fatho_mlessness_
fencelessness1854077__fencelessness_
foodlessness1644747___foodlessness_
footlessness1545617___footlessness_
formlessness1744717___formlessness_
friendlessness1852207_friendlessness_
fruitlessness1654197_fr_uitlessness_
godlessness1355437___go_dlessness_
gracelessnesses1755907_gr_acelessnesses
groundlessness16102597_groundlessness_
guilelessnesses15195317gu__ilelessnesses
guiltlessness1453777gu__iltlessness_
gutlessness1246017gu____tlessness_
haplessness1645667_hap___lessness_
harmlessness1745057har___mlessness_
helplessness1754477help___lessness_
homelessnesses18137477___homelessnesses
hopelessnesses18147017___hopelessnesses
hornlessness1545167___hornlessness_
houselessnesses1665677__houselessnesses
humorlessnesses1954187hu_mo_rlessnesses
joblessness2044817___jo_blessness_
joylessness2144297___jo_ylessness_
lifelessness1545297___lifelessness_
listlessness1145827___listlessness_
lovelessnesses1646997___lovelessnesses
mercilessness1753467mer__cilessness_
morosenesses1446867mor_oseness_e_s_
motionlessness16122157motio_nlessness_
movelessnesses1846747___movelessnesses
namelessness1445617___namelessness_
nervelessnesses1754987ner__velessnesses
operosenesses1575327oper_oseness_e_s_
painlessness1445447___painlessness_
pathlessness1754907___pathlessness_
pitilessness1474527___pitilessness_
planlessness1444997___planlessness_
plotlessnesses1556097p__lo_tlessnesses
pointlessness1554617p__ointlessness_
powerlessnesses1954497___powerlessnesses
prepossesses1552917prepos_sess_e_s_
pronenesses1379267p_r_oneness_e_s_
prophetesses1952447p_rophetess_e_s_
prosinesses13310867p_r_osiness_e_s_
prosperousness1862797p_r_osperousness_
purenesses12810747pur___eness_e_s_
pursinesses1338757pur__siness_e_s_
raylessness1445117__r__aylessness_
recklessness1854657__r_ecklessness_
resistlessness1282607_resistlessness_
restlessnesses1257237__r_estlessnesses
rootlessnesses1346607__r_ootlessnesses
ruthlessness1554317__r_uthlessness_
saplessness1245987_sap___lessness_
senselessnesses055707__senselessnesses
sexlessness1745317_____sexlessness_
shamelessness1754967__shamelessness_
shapelessnesses18156297shap__elessnesses
soullessness1145547___soullessness_
spinelessnesses1555497__spinelessnesses
spiritlessness1582567spir__itlessness_
spotlessnesses1456277__spo_tlessnesses
statelessness1255147__statelessness_
stylelessness1553417__stylelessness_
tastelessness1254197__tastelessness_
thriftlessness2062257thr_iftlessness_
timelessness1445787___timelessness_
tirelessnesses1357017tir___elessnesses
tonelessnesses13137657___tonelessnesses
toplessness1345407___to_plessness_
valuelessness1653457__valuelessness_
verbosenesses1853307verboseness_e_s_
voicelessness1854067__voicelessness_
wordlessness1644717___wordlessness_
worklessness1954107___worklessness_
worthlessness1953657wor__thlessness_

Search took 9 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.360496363.9
2DLD Change Limit950241288.22011560.1
3Display Results1281280.1101163.6
 (SQL Overall)1786911288.69020562.8
 
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.