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

94 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
pitilessnesses157575(None) 
pathlessnesses1855952pathlessnesses
pitilessness1474522pitilessne_s_s
witlessnesses1547232wit_lessnesses
aimlessnesses1487463ai_mlessnesses
airlessnesses12117993ai_rlessnesses
artlessnesses1247663art_lessnesses
faithlessnesses2074973faithlessnesses
gutlessnesses1346943gut_lessnesses
lifelessnesses1646653lifelessnesses
limitlessnesses1654283limitlessnesses
listlessnesses1266933listlessnesses
mindlessnesses1686013mindlessnesses
painlessnesses1546743painlessnesses
planlessnesses1576303planlessnesses
plotlessnesses1556093plotlessnesses
pointlessnesses1655443pointlessnesses
ruthlessnesses1665383ruthlessnesses
sinlessnesses1157983si_nlessnesses
spinelessnesses1555493spinelessnesses
spotlessnesses1456273spot_lessnesses
timelessnesses1547023timelessnesses
tirelessnesses1357013tirelessnesses
winglessnesses1765463winglessnesses
agelessnesses1387624_agelessnesses
bootlessnesses1556454bootlessnesses
brainlessnesses1665024brainlessnesses
carelessnesses1547724carelessnesses
childlessnesses20104944childlessnesses
citizenesses2345674citize__nesses
deathlessnesses1885174deathlessnesses
endlessnesses1356764_endlessnesses
facelessnesses1847324facelessnesses
fearlessnesses1666744fearlessnesses
fecklessnesses2255494fecklessnesses
flawlessnesses1975454flawlessnesses
foodlessnesses1755764foodlessnesses
footlessnesses1656564footlessnesses
formlessnesses1856124formlessnesses
fruitlessnesses1754894fruitlessnesses
futilenesses1547214futile__nesses
godlessnesses1446584_godlessnesses
guilelessnesses15195314guilelessnesses
guiltlessnesses15174924guiltlessnesses
hairlessnesses16126634hairlessnesses
haplessnesses1747254_haplessnesses
harmlessnesses1876414harmlessnesses
headlessnesses17137064headlessnesses
heedlessnesses17136224heedlessnesses
helplessnesses1855804helplessnesses
homelessnesses18137474homelessnesses
hopelessnesses18147014hopelessnesses
hornlessnesses1656274hornlessnesses
joblessnesses2155994_joblessnesses
joylessnesses2255644_joylessnesses
landlessnesses1456684landlessnesses
lawlessnesses1546384_lawlessnesses
littlenesses1246094little__nesses
lovelessnesses1646994lovelessnesses
mercilessnesses18104534mercilessnesses
movelessnesses1846744movelessnesses
namelessnesses1577054namelessnesses
needlessnesses14115694needlessnesses
pathlessness1754904pathlessne_s_s
perilousnesses1667264perilousnesses
petitenesses14169364petite__nesses
piteousnesses1557174pit_eousnesses
pitiablenesses1855064pitiablenesses
pitifulnesses1855574piti_fulnesses
powerlessnesses1954494powerlessnesses
raylessnesses1546504_raylessnesses
recklessnesses1955844recklessnesses
restlessnesses1257234restlessnesses
rootlessnesses1346604rootlessnesses
saplessnesses1347274_saplessnesses
seamlessnesses1446974seamlessnesses
selflessnesses15115994selflessnesses
sexlessnesses1846744_sexlessnesses
shiftlessnesses1954994shiftlessnesses
sightlessnesses1755034sightlessnesses
skillessnesses1655614skillessnesses
soullessnesses1296504soullessnesses
statelessnesses1355864statelessnesses
tactlessnesses1546554tactlessnesses
tastelessnesses1355274tastelessnesses
tonelessnesses13137654tonelessnesses
toplessnesses1446584_toplessnesses
uselessnesses1147314_uselessnesses
voicelessnesses1955314voicelessnesses
waterlessnesses1754724waterlessnesses
witlessness1446264wit_lessne_s_s
wordlessnesses1775874wordlessnesses
worklessnesses20125484worklessnesses
worthlessnesses2054554worthlessnesses

Search took 4 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.330541487.9
2DLD Change Limit65874943.53018661.2
3Display Results94940.0631492.1
 (SQL Overall)178691943.92345549.6
 
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.