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

144 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
faithlessnesses2074971faithlessnesses_
faithlessness1953973faithlessne_s_s_
pathlessnesses1855953pa_thlessnesses_
aimlessnesses1487464_ai_mlessnesses_
airlessnesses12118004_ai_rlessnesses_
artlessnesses1247674_art_lessnesses_
deathlessnesses1885174deathlessnesses_
facelessnesses1847324fa_celessnesses_
faultlessnesses1754934faultlessnesses_
footlessnesses1656564foot_lessnesses_
fruitlessnesses1754894fruit_lessnesses_
hairlessnesses16126634hai_rlessnesses_
painlessnesses1546744pai_nlessnesses_
pitilessnesses1575754_pitilessnesses_
ruthlessnesses1665384_ruthlessnesses_
tactlessnesses1546554tact_lessnesses_
tastelessnesses1355274tastelessnesses_
witlessnesses1547234_wit_lessnesses_
worthlessnesses2054554worthlessnesses_
agelessnesses1387635_a_gelessnesses_
bootlessnesses1556455boot_lessnesses_
brainlessnesses1665025brai_nlessnesses_
carelessnesses1547725ca_relessnesses_
childlessnesses20104945childlessnesses_
dauntlessnesses1554815dauntlessnesses_
faithfulnesses2354405faith_fulnesses_
fearlessnesses1666745f_earlessnesses_
fecklessnesses2255495f_ecklessnesses_
fencelessnesses1995355fencelessnesses_
flawlessnesses1975455f_lawlessnesses_
foodlessnesses1755765f_oodlessnesses_
formlessnesses1856125f_ormlessnesses_
guilelessnesses15195315guilelessnesses_
guiltlessnesses15174925guiltlessnesses_
gutlessnesses1346945_gut_lessnesses_
haplessnesses1747255ha__plessnesses_
harmlessnesses1876415ha_rmlessnesses_
heartlessnesses1765775heart_lessnesses_
landlessnesses1456685la_ndlessnesses_
lawlessnesses1546385la__wlessnesses_
lifelessnesses1646655_lifelessnesses_
limitlessnesses1654285limit_lessnesses_
listlessnesses1266935_listlessnesses_
mindlessnesses1686015_mindlessnesses_
namelessnesses1577055na_melessnesses_
pathlessness1754905pa_thlessne_s_s_
plotlessnesses1556095plot_lessnesses_
pointlessnesses1655445pointlessnesses_
raylessnesses1546505ra__ylessnesses_
restlessnesses1257235rest_lessnesses_
rootlessnesses1346605root_lessnesses_
saplessnesses1347275sa__plessnesses_
shiftlessnesses1954995shiftlessnesses_
sightlessnesses1755035_sightlessnesses_
sinlessnesses1157985_si_nlessnesses_
skillessnesses1655615ski_llessnesses_
spinelessnesses1555495spinelessnesses_
spotlessnesses1456275spot_lessnesses_
statelessnesses1355865statelessnesses_
timelessnesses1547025_timelessnesses_
tirelessnesses1357015_tirelessnesses_
valuelessnesses1764795valuelessnesses_
voicelessnesses1955315voicelessnesses_
waterlessnesses1754725waterlessnesses_
winglessnesses1765465_winglessnesses_
aimlessness1345676_ai_mlessne_s_s_
airlessness1146266_ai_rlessne_s_s_
artlessness1146446_art_lessne_s_s_
blamelessnesses1865716blamelessnesses_
bloodlessnesses1764326bloodlessnesses_
boundlessnesses1774926boundlessnesses_
brittlenesses1584236brittle__nesses_
ceaselessnesses1596166ceaselessnesses_
cheerlessnesses1954546cheerlessnesses_
classlessnesses054836classlessnesses_
cloudlessnesses1764876cloudlessnesses_
colorlessnesses1665096colorlessnesses_
deathlessness1754326deathlessne_s_s_
doubtlessnesses1764936doubtlessnesses_
dreamlessnesses17104536dreamlessnesses_
earthlinesses1643916earthl__inesses_
endlessnesses1356766__endlessnesses_
fabulousnesses1954706fa_bulousnesses_
facelessness1786056fa_celessne_s_s_
facilenesses1756726fa_cile__nesses_
factiousnesses1977526fact_iousnesses_
faintishnesses2053306fai_ntishnesses_
falsenesses1446746fa___l_senesses_
fatalnesses1456286fa_tal___nesses_
fatherlinesses2052616fa_therlinesses_
fathomlessness2261556fa_thomlessne_s_s_
fatuousnesses1686866fa_t_uousnesses_
faultlessness1653946faultlessne_s_s_
fertilenesses1648036fertile__nesses_
ficklenesses2144156f_ickle__nesses_
footlessness1545616foot_lessne_s_s_
frivolousnesses2162846frivolousnesses_
fruitlessness1654196fruit_lessne_s_s_
futilenesses1547216f_utile__nesses_
godlessnesses1446586__godlessnesses_
gracelessnesses1755906gracelessnesses_
hairlessness1545306hai_rlessne_s_s_
headlessnesses17137066_headlessnesses_
heedlessnesses17136226_heedlessnesses_
helplessnesses1855806_helplessnesses_
homelessnesses18137476_homelessnesses_
hopelessnesses18147016_hopelessnesses_
hornlessnesses1656276_hornlessnesses_
houselessnesses1665676houselessnesses_
humorlessnesses1954186humorlessnesses_
joblessnesses2155996__joblessnesses_
joylessnesses2255646__joylessnesses_
lithenesses1447316_lith_e__nesses_
littlenesses1246096_little__nesses_
lovelessnesses1646996_lovelessnesses_
mercilessnesses18104536mercilessnesses_
movelessnesses1846746_movelessnesses_
needlessnesses14115696_needlessnesses_
nervelessnesses1754986nervelessnesses_
painlessness1445446pai_nlessne_s_s_
pitilessness1474526_pitilessne_s_s_
planlessnesses1576306_planlessnesses_
powerlessnesses1954496powerlessnesses_
recklessnesses1955846_recklessnesses_
ruthlessness1554316_ruthlessne_s_s_
seamlessnesses1446976_seamlessnesses_
selflessnesses15115996_selflessnesses_
senselessnesses055706senselessnesses_
sexlessnesses1846746__sexlessnesses_
shamelessnesses18186516shamelessnesses_
shapelessnesses18156296shapelessnesses_
sleeplessnesses1554686sleeplessnesses_
soullessnesses1296506_soullessnesses_
stylelessnesses1674716stylelessnesses_
tactlessness1445416tact_lessne_s_s_
tastelessness1254196tastelessne_s_s_
thanklessnesses2154806thanklessnesses_
tonelessnesses13137656_tonelessnesses_
toplessnesses1446586__toplessnesses_
uselessnesses1147316__uselessnesses_
witlessness1446266_wit_lessne_s_s_
wordlessnesses1775876_wordlessnesses_
worklessnesses20125486_worklessnesses_
worthlessness1953656worthlessne_s_s_

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 Filter178691658740.373479064.3
2DLD Change Limit658741446.8609602.6
3Display Results1441440.1261142.9
 (SQL Overall)1786911447.35924282.0
 
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.