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

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

345 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
joyless1722651(None) 
jobless16237561jobless
toyless10268711toyless
bowless123310312bowless
coxless1637742coxless
coyness1277322coyness
doyleys14384922doyleys
flyless1335002flyless
fogless1138192fogless
godless938402godless
hoyles12315012hoyle_s
jagless1537102jagless
jawless1745652jawless
joles125230832jo_le_s
joules134116822joule_s
joylessly2242492joylessly
juryless1832982juryless
keyless1436162keyless
rayless10239002rayless
rodless8310072rodless
sonless72612612sonless
toeless72612392toeless
topless92511122topless
vowless13246602vowless
wayless13308242wayless
ageless8310343ageless
aidless83612073aidless
aimless93610813aimless
airless73712043airless
armless9369943armless
artless73712513artless
ashless10318453ashless
aweless1038723aweless
awless939263_awless
awnless1035923awnless
barless94317003barless
bedless1039703bedless
bibless11439173bibless
bless75917813__bless
blotless10347153blotless
bodiless1135913bodiless
bogles95020833bogle_s
boilers93417063boilers
boles75448603bo_le_s
boltless10338283boltless
bondless1148813bondless
boneless10310213boneless
boonless10328353boonless
bootless103410983bootless
boules84925973boule_s
bowlegs13366823bowlegs
bowlers123715783bowlers
boylas113011723boyl_as
braless92910563braless
browless1346653browless
budless1038873budless
capless114312763capless
carless95118493carless
chyles144813283chyle_s
coalers94419353coalers
coalless1038193coalless
coatless1039693coatless
cobles104622883coble_s
codeless112010113codeless
coilers93619903coilers
coles76055063co_le_s
coleus86818273co_leus
collets93517903collets
confess12399903confess
cookless14258633cookless
coolers93522493coolers
coolest9318643coolest
coolness1037743coolness
cordless11299963cordless
coreless103013833coreless
costless10310003costless
coulees9315513coulees
coyest11316053coy_est
cropless1237793cropless
dewless1137473dewless
doglegs1034783doglegs
doles67843753do_le_s
doolees83711613doolees
doorless936713doorless
downless1236363downless
doyens104810223doy_ens
doyley13487283doyle_y
doylies114512573doylies
dryness11114783dryness
earless74316073earless
eggless935663eggless
egoless836983egoless
endless839833endless
eyeless1058053eyeless
fatless103212203fatless
feeless103511103feeless
feyness1334923feyness
finless102810783finless
foamless13195843foamless
foleys123810463fo_leys
folles93820473folle_s
foodless12338383foodless
footless113710803footless
fordless12289003fordless
forkless15267433forkless
formless13248083formless
foulest10313313foulest
foulness11236653foulness
fowlers133411203fowlers
foyers125413133foy_ers
furless103210143furless
gapless10349993gapless
gasless8319013gasless
gayness1136843gayness
goalless935723goalless
goblets103210183goblets
goddess1035263goddess
goglets9379783goglets
golems939323go_lems
gormless11235443gormless
gumless10228273gumless
gunless8299633gunless
gutless82610713gutless
hapless123311333hapless
hatless103813443hatless
hipless12399923hipless
hitless103211193hitless
holeless1189363holeless
holes84748653ho_le_s
hollers103818233hollers
homeless131110143homeless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279263hoopless
hopeless13118303hopeless
hornless1137363hornless
hostess103210243hostess
hotness1038613hotness
howlers133312353howlers
howlets13329223howlets
hoydens14347403hoydens
hoyle11314413hoyle__
hueless1058823hueless
iceless9219963iceless
inkless11348713inkless
innless7288293innless
ireless72312243ireless
jailers144114043jailers
jaygees1854513jaygees
jayvees2052923jayvees
jess116022033j___ess
jobbers182911133jobbers
jockeys23365953jockeys
joes116635893jo__e_s
joeys15518043jo__eys
joggers164110693joggers
jogglers17356883jogglers
joggles164410413joggle_s
joiners144211573joiners
jointless1634323jointless
jokers175511193jo_kers
jokes165423333jo_ke_s
jokiest18379193jokiest
jokiness19227393jokiness
jole117233823jo_le__
jolliers15357433jolliers
jollies143516273jollies
jolliest152910363jolliest
jolliness1636213jolliness
jolters143711993jolters
jolts125018883jo_l_ts
jones125028183jo_ne_s
joneses1438963jo_neses
joshers174111593joshers
joshes165114853joshe_s
joss115925593jo___ss
josses135117683josse_s
jostlers15357683jostlers
jostles143411143jostle_s
jotters143413803jotters
joule124918203joule__
jowled174210803jowle_d
jowliest18247623jowliest
jowliness1934853jowliness
jowls156214523jowl__s
joyed164811833joy_e_d
joyfulness2343203joyfulness
joyous16276763joy_ous
joypops2162603joypops
joys146624663joy___s
juleps1535623j_uleps
kayles134712003kayle_s
kinless113310273kinless
knotless1264573knotless
lawless1037033lawless
legless838013legless
less45635103___less
lidless8309273lidless
lipless9259553lipless
loamless10235213loamless
loess55714703lo__ess
loftless1135903loftless
lollers72713793lollers
lordless9277483lordless
lossless835473lossless
loveless1168573loveless
lowness1037813lowness
loyalest11146723loyalest
manless93012933manless
matless93014043matless
moilers93615203moilers
moles74747923mo_le_s
molest85022743mo_lest
molests93311563mo_lests
moneyless1444653moneyless
mooleys1236863mooleys
moonless10278043moonless
motleys1235683motleys
moveless1367753moveless
napless93110283napless
netless739863netless
nobles83319723noble_s
noblesse1044543noblesse
noblest93613563noblest
normless10235923normless
noseless839513noseless
noteless839403noteless
nounless837253nounless
nowness1037033nowness
oarless73913373oarless
obsess845943_obsess
odorless934173odorless
odyles10348563odyle_s
oglers74313183_oglers
ogles65223183_ogle_s
ogress7529503_ogress
oilers64721193_oilers
oleos55419683_o_leos
oles46453473_o_le_s
oodles73517183oodle_s
orbless937493orbless
orles55326213_orle_s
owlets93110393_owlets
oyers87620883_oy_ers
oyes74940133_oy_e_s
pegless1038053pegless
phyleses1645183phyleses
phylesis1645313phylesis
playless1334863playless
plotless10256793plotless
poetess938933poetess
poetless1038723poetless
poleis86018353po_leis
poleless1089873poleless
polers84225643po_lers
poles75351003po_le_s
pollees93215333pollees
pollens93713303pollens
pollers93420023pollers
poolers94217423poolers
popeless1288473popeless
portless10310643portless
possess9419123possess
ribless93410343ribless
rimless9369363rimless
roadless937703roadless
robles85321693roble_s
rockless14297293rockless
roles56747983ro_le_s
rollers73117473rollers
roofless11316733roofless
rootless83910443rootless
runless72810423runless
sapless93313443sapless
sexless1467243sexless
shoeless1137803shoeless
shyness1344993shyness
sinless73014213sinless
slyness1035263slyness
smogless1134053smogless
snowless1145633snowless
soapless10278073soapless
sockless14267793sockless
socles8418453socle_s
sodaless936113sodaless
soilless8279033soilless
soleless8910033soleless
soles55547923so_le_s
soleus64615613so_leus
songless9218823songless
soulless8218763soulless
soupless10268463soupless
spotless1037043spotless
stylers10359353stylers
styles94418653style_s
stylets10369213stylets
sumless92611123sumless
sunless73013693sunless
taxless1436913taxless
thowless1434613thowless
tieless72512563tieless
tipless92610063tipless
toadless936313toadless
toilers74116263toilers
toiles63923513toile_s
toilets74112913toilets
toles55147133to_le_s
tollers73217463tollers
tombless1236783tombless
toneless8610393toneless
tonlets73212503tonlets
toolers74416503toolers
toolless836343toolless
townless1135653townless
toyers95516333toy_ers
tugless837383tugless
unless62413073_unless
useless7188423useless
voiles94616443voile_s
voles86234043vo_le_s
volleys13316643volleys
voteless1137493voteless
votress1035483votress
warless104015103warless
webless1237003webless
wigless11359673wigless
winless103212283winless
witless103310983witless
woeness1020211543woeness
woodless12278453woodless
woolens10398843woolens
woolers104214023woolers
wordless12258843wordless
workless15276803workless
wryness13113983wryness
wyles114615323_wyle_s
xylems1833203_xylems
ylems1039263__ylems
yodlers11298923yodlers
yodles103714333yodle_s
yokeless1535303yokeless
yowlers13328923yowlers
zipless18276303zipless
zoneless1737823zoneless

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273457.04619021.7
3Display Results3453450.1402464.3
 (SQL Overall)1786913457.59223536.7
 
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.