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

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

124 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
aimlessness134567(None) 
airlessness1146261airlessness
agelessness1246082agelessness
aimlessnesses1487462aimlessnesses
artlessness1146442artlessness
hairlessness1545302hairlessness
harmlessness1745052harmlessness
painlessness1445452painlessness
sinlessness1046722sinlessness
timelessness1445782timelessness
witlessness1446262witlessness
airlessnesses12118003airlessnesses
brainlessness1554193brainlessness
carelessness1446543carelessness
endlessness1245483endlessness
facelessness1786053facelessness
faithlessness1953973faithlessness
formlessness1744713formlessness
godlessness1355433godlessness
gutlessness1246013gutlessness
haplessness1645663haplessness
homelessness1746103homelessness
joblessness2044813joblessness
joylessness2144293joylessness
landlessness1345713landlessness
lawlessness1444893lawlessness
lifelessness1545293lifelessness
limitlessness1553343limitlessness
listlessness1145823listlessness
mindlessness1554853mindlessness
namelessness1445613namelessness
pathlessness1754903pathlessness
pitilessness1474523pitilessness
raylessness1445113raylessness
saplessness1245983saplessness
seamlessness1355903seamlessness
sexlessness1745313sexlessness
skillessness1554233skillessness
tactlessness1445413tactlessness
tirelessness1245933tirelessness
toplessness1345403toplessness
uselessness1075993uselessness
winglessness1654323winglessness
agelessnesses1387634agelessnesses
agileness1046514agile__ness
aimless93610814aiml____ess
aimlessly1443284aimless__ly
alertness946054a__lertness
ampleness1345304ample__ness
artlessnesses1247674artlessnesses
blamelessness1754544blamelessness
bootlessness1445454bootlessness
ceaselessness1455114ceaselessness
childlessness1963874childlessness
classlessness1353734classlessness
dauntlessness1453774dauntlessness
deathlessness1754324deathlessness
dimnesses1238214dimness_e_s
dreamlessness1673814dreamlessness
fathomlessness2261554fathomlessness
faultlessness1653944faultlessness
fearlessness1545764fearlessness
fecklessness2154484fecklessness
flawlessness1854124flawlessness
foodlessness1644744foodlessness
footlessness1545614footlessness
fruitlessness1654194fruitlessness
girlishness1573664girlishness
gracelessness1664764gracelessness
guilelessness1453924guilelessness
guiltlessness1453774guiltlessness
hairlessnesses16126634hairlessnesses
harmlessnesses1876414harmlessnesses
headlessness16105964headlessness
heartlessness1665174heartlessness
heedlessness1685024heedlessness
helplessness1754474helplessness
hopelessness1745754hopelessness
hornlessness1545164hornlessness
humorlessness1853164humorlessness
idleness936844_idle__ness
idlesses936004_idless_e_s
immenseness1553134_immenseness
impishness1744124_impishness
limberness1443274limbe_rness
lovelessness1545734lovelessness
messiness11248224__m_essiness
movelessness1745304movelessness
needlessness1374684needlessness
nimbleness1445594nimble__ness
painlessnesses1546744painlessnesses
planlessness1444994planlessness
plotlessness1445084plotlessness
pointlessness1554614pointlessness
recklessness1854654recklessness
remissness1244214rem_issness
restlessness1146514restlessness
rootlessness1245614rootlessness
ruthlessness1554314ruthlessness
selflessness1444594selflessness
shamelessness1754964shamelessness
shapelessness1754964shapelessness
shiftlessness1854004shiftlessness
sightlessness1654154sightlessness
silentness1044574si_lentness
simpleness1445174simple__ness
sinlessnesses1157984sinlessnesses
soullessness1145544soullessness
spinelessness1454404spinelessness
spotlessness1345324spotlessness
statelessness1255144statelessness
tastelessness1254194tastelessness
thanklessness2053834thanklessness
timelessnesses1547024timelessnesses
timeliness1245304tim_eliness
tonelessness1246244tonelessness
valuelessness1653454valuelessness
vileness1139984vi_le__ness
voicelessness1854064voicelessness
waterlessness1653854waterlessness
wimpishness2143214wimpishness
witlessnesses1547234witlessnesses
wordlessness1644714wordlessness
worklessness1954104worklessness

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 Filter1786911488190.423422437.4
2DLD Change Limit1488191248.29617938.6
3Display Results1241240.0631968.3
 (SQL Overall)1786911248.78220347.4
 
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.