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

419 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
jobless1623756(None) 
joyless17226511joyless
bibless11439172bibless
bless75917812__bless
bowless123310312bowless
cobles104622882coble_s
coxless1637742coxless
fogless1138192fogless
goblets103210182goblets
godless938402godless
jagless1537102jagless
jawless1745652jawless
jobbers182911132jobbers
joles125230832jo_le_s
joules134116822joule_s
nobles83319722noble_s
noblesse1044542noblesse
noblest93613562noblest
obsess845942_obsess
orbless937492orbless
ribless93410342ribless
robles85321692roble_s
rodless8310072rodless
sonless72612612sonless
toeless72612392toeless
tombless1236782tombless
topless92511122topless
toyless10268712toyless
vowless13246602vowless
webless1237002webless
abbess10509773_abbess
ables75935543_able_s
ablest84721833_ablest
ageless8310343ageless
aidless83612073aidless
aimless93610813aimless
airless73712043airless
amblers115213563amblers
ambles105121863amble_s
armless9369943armless
artless73712513artless
ashless10318453ashless
aweless1038723aweless
awless939263_awless
awnless1035923awnless
barbless12318713barbless
barless94317003barless
bedless1039703bedless
bibles104617643bible_s
blebs96416153__blebs
blest76431723__blest
blets75324943__blets
bliss75616913__bliss
blotless10347153blotless
bobbers103614283bobbers
bobbles104514913bobble_s
bobsleds13304383bobsleds
bodiless1135913bodiless
bogles95020833bogle_s
boilers93417063boilers
boles75448603bo_le_s
boltless10338283boltless
bomblets1436023bomblets
bondless1148813bondless
boneless10310213boneless
boonless10328353boonless
bootless103410983bootless
boules84925973boule_s
bowlegs13366823bowlegs
bowlers123715783bowlers
braless92910563braless
browless1346653browless
budless1038873budless
cablers114416713cablers
cables104527553cable_s
cablets114216343cablets
capless114312763capless
carless95118493carless
coalers94419353coalers
coalless1038193coalless
coatless1039693coatless
cobbers134114753cobbers
cobblers14359593cobblers
cobbles133814823cobble_s
coble94823173coble__
cobwebs1631933cobwebs
codeless112010113codeless
coilers93619903coilers
coles76055063co_le_s
coleus86818273co_leus
collets93517903collets
confess12399903confess
cookless14258633cookless
coolers93522493coolers
coolest9318643coolest
coolness1037743coolness
cordless11299963cordless
coreless103013833coreless
costless10310003costless
coulees9315513coulees
coyness1277323coyness
cropless1237793cropless
debtless1135653debtless
dewless1137473dewless
dobbers123513253dobbers
dobies94422093dobie_s
doblas93812293dobl_as
doblons1037043doblons
doglegs1034783doglegs
doles67843753do_le_s
doolees83711613doolees
doorless936713doorless
doublers11288503doublers
doubles103113353double_s
doublets11257363doublets
doubtless1243313doubtless
downless1236363downless
doyleys14384923doyleys
earless74316073earless
eggless935663eggless
egoless836983egoless
emblems1335043emblems
endless839833endless
eyeless1058053eyeless
fablers124812613fablers
fables114921673fable_s
fatless103212203fatless
feeless103511103feeless
finless102810783finless
flyless1335003flyless
foamless13195843foamless
foibles1238853foible_s
foleys123810463fo_leys
folles93820473folle_s
foodless12338383foodless
footless113710803footless
fordless12289003fordless
forkless15267433forkless
formless13248083formless
foulest10313313foulest
foulness11236653foulness
fowlers133411203fowlers
furless103210143furless
gables94222333gable_s
gapless10349993gapless
garbless11388253garbless
gasless8319013gasless
giblets103210423giblets
goalless935723goalless
gobbets12327643gobbets
gobblers13308343gobblers
gobbles123512583gobble_s
gobies95418063gobie_s
goblet93219483goble_t
goblins1039243goblins
goboes95914443goboe_s
goddess1035263goddess
goglets9379783goglets
golems939323go_lems
gormless11235443gormless
gumless10228273gumless
gunless8299633gunless
gutless82610713gutless
hapless123311333hapless
hatless103813443hatless
herbless1336663herbless
hipless12399923hipless
hitless103211193hitless
hobbers143512343hobbers
hobblers15308513hobblers
hobbles143313783hobble_s
hoboes114717443hoboe_s
holeless1189363holeless
holes84748653ho_le_s
hollers103818233hollers
homeless131110133homeless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279263hoopless
hopeless13118303hopeless
hornless1137363hornless
hostess103210243hostess
hotness1038613hotness
howlers133312353howlers
howlets13329223howlets
hoyles12315013hoyle_s
hueless1058823hueless
iceless9219963iceless
inkless11348713inkless
innless7288293innless
ireless72312243ireless
jabbers183610583jabbers
jailers144114043jailers
jebels15418913jeb_els
jess116022033j___ess
jibbers18449703jibbers
jibers155912883jib_ers
jibes145520323jib_e_s
jobbed184212133jobbe_d
jobber173813353jobbe_r
jobbery21366013jobbery
jobs136529433job___s
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
joylessly2242493joylessly
jubes145420743jub_e_s
jubilees17244423jubilees
jubiles16289373jubile_s
juleps1535623j_uleps
jumblers19358323jumblers
jumbles183013323jumble_s
juryless1832983juryless
keyless1436163keyless
kinless113310273kinless
knotless1264573knotless
lawless1037033lawless
legless838013legless
less45635103___less
lidless8309273lidless
limbless12246313limbless
lipless9259553lipless
loamless10235213loamless
lobbers113713943lobbers
lobes75331003lob_e_s
lobules92510813lobule_s
loess55714703lo__ess
loftless1135903loftless
lollers72713793lollers
lordless9277483lordless
lossless835473lossless
loveless1168573loveless
lowness1037813lowness
manless93012933manless
matless93014043matless
mobbers133610923mobbers
mobiles112813123mobile_s
mobled113213183moble_d
moilers93615203moilers
moles74747923mo_le_s
molest85022743mo_lest
molests93311563mo_lests
mooleys1236863mooleys
moonless10278043moonless
motleys1235683motleys
moveless1367753moveless
napless93110283napless
netless739863netless
nobblers12318563nobblers
nobbles114014523nobble_s
noble74420993noble__
nobleness1147523nobleness
nobler83713453noble_r
noblesses1146003noblesses
nombles113212343nomble_s
normless10235923normless
noseless839513noseless
noteless839403noteless
nounless837253nounless
nowness1037033nowness
oarless73913373oarless
obelus8348403_obelus
obes66036833_ob_e_s
obese75212423_ob_ese
obeys107010643_ob_eys
objets15125323_objets
oblast8613663_oblast
oblasts947303_oblasts
oboes75717713_oboe_s
oboles83815833_obole_s
obtest81213013_obtest
obtests9136233_obtests
odorless934173odorless
oglers74313183_oglers
ogles65223183_ogle_s
ogress7529503_ogress
oilers64721193_oilers
oleos55419683_o_leos
oles46453473_o_le_s
oodles73517183oodle_s
orles55326213_orle_s
outbless1037963outbless
owlets93110393_owlets
pegless1038053pegless
plotless10256793plotless
poetess938933poetess
poetless1038723poetless
poleis86018353po_leis
poleless1089873poleless
polers84225643po_lers
poles75351003po_le_s
pollees93215333pollees
pollens93713303pollens
pollers93420023pollers
poolers94217423poolers
popeless1288473popeless
portless10310643portless
possess9419123possess
prebless1236823prebless
problems1434343problems
rayless10239003rayless
riblets93412553riblets
rimless9369363rimless
roadless937703roadless
robbers112814163robbers
robes75133303rob_e_s
roble75223023roble__
rockless14297293rockless
roles56747983ro_le_s
rollers73117473rollers
roofless11316733roofless
rootless83910443rootless
roubles93413513rouble_s
rubles83921703ruble_s
runless72810423runless
sables85026693sable_s
sapless93313443sapless
sexless1467243sexless
shoeless1137803shoeless
sinless73014213sinless
smogless1134053smogless
snowless1145633snowless
soapless10278073soapless
sobbers114114263sobbers
sobers85218863sob_ers
sockless14267793sockless
socles8418453socle_s
sodaless936113sodaless
soilless8279033soilless
soleless8910033soleless
soles55547923so_le_s
soleus64615613so_leus
songless9218823songless
soulless8218763soulless
soupless10268463soupless
spotless1037043spotless
sublets92616703sublets
sumless92611123sumless
sunless73013693sunless
tables84524893table_s
tablets94714383tablets
taxless1436913taxless
thowless1434613thowless
tieless72512563tieless
tipless92610063tipless
toadless936313toadless
tobies84521023tobie_s
toilers74116263toilers
toiles63923513toile_s
toilets74112913toilets
toles55147133to_le_s
tollers73217463tollers
toneless8610393toneless
tonlets73212503tonlets
toolers74416503toolers
toolless836343toolless
townless1135653townless
tubeless1037023tubeless
tugless837383tugless
umbles103817493umble_s
unblest9411813unblest
unless62413073_unless
useless7188423useless
verbless1336033verbless
voiles94616443voile_s
voles86234043vo_le_s
volleys13316643volleys
voteless1137493voteless
votress1035483votress
warless104015103warless
wayless13308243wayless
wigless11359673wigless
winless103212283winless
witless103310983witless
wobblers15327883wobblers
wobbles143412433wobble_s
woeness1020211543woeness
woodless12278453woodless
woolens10398843woolens
woolers104214023woolers
wordless12258843wordless
workless15276803workless
yodlers11298923yodlers
yodles103714333yodle_s
yokeless1535303yokeless
yowlers13328923yowlers
zipless18276303zipless
zoneless1737823zoneless

Search took 7 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.423422437.4
2DLD Change Limit1340274195.78023188.1
3Display Results4194190.1562685.9
 (SQL Overall)1786914196.35928100.5
 
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.