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

343 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
headless1228986(None) 
heatless113011461heatless
heedless12278811heedless
leadless9248791leadless
beadles103414732beadle_s
beakless14297382beakless
beamless12327002beamless
beardless1234912beardless
beatless103311592beatless
bedless1039702be_dless
breadless1235942breadless
chadless1436402chadless
deadness1039232deadness
deedless10318252deedless
earless74316072_earless
endless839832_endless
fearless1137872fearless
gearless937372gearless
handless123512062handless
hapless123311332h_apless
hatless103813442h_atless
headdress1443752headdress
headers113819392head_ers
headiest123015552headiest
headiness132510362headiness
headrest122910202headrest
headrests13245022headrests
headsets1236052headsets
healers104319462hea_lers
heartless1236392heartless
heathless1535592heathless
heddles123311622heddle_s
heelless11257652heelless
heirless1146052heirless
helmless1334272helmless
helpless1335062helpless
herbless1336662herbless
hoodless12289732hoodless
leafless11246572leafless
leakless12246982leakless
mealless10288362mealless
meatless103410862meatless
needless9308332needless
peakless14236682peakless
roadless937702roadless
seamless10238722seamless
seatless83213002seatless
seedless9319512seedless
tearless848712tearless
threadless1442472threadless
toadless936312toadless
treadless1036002treadless
weedless12287962weedless
weldless12285812weldless
wheatless1534002wheatless
aidless83612073_aidless
awless939263__awless
badness1039573_badness
barless94317003_barless
beaders104120183bead_ers
beadiest113815533beadiest
beadiness12249233beadiness
beadle93314683beadle__
beagles103212123beagle_s
beefless1335493beefless
beltless10297713beltless
bladeless1234303bladeless
bondless1148813bondless
braless92910563bra_less
brandless1236123brandless
budless1038873_budless
capless114312763_capless
carless95118493_carless
ceaseless1135733ceaseless
cheapness1643743cheapness
checkless2044233checkless
cheekless1873883cheekless
cheerless1495293cheerless
childless1543813childless
clawless1334123clawless
coalless1038193coalless
coatless1039693coatless
cordless11299963cordless
cradlers11309203cradlers
cradles103114133cradle_s
deadens93410693dead_ens
deadest93014883dead_est
deadliest1138183deadliest
deadliness12115893deadliness
deafness1236213deafness
dealers84118613dea_lers
dearness939973dearness
deathless1335223deathless
debtless1135653debtless
decayless1542863decayless
dewless1137473de_wless
dreamless1243513dreamless
eagles73819163_eagle_s
eaglets84111663_eaglets
eggless935663_eggless
egoless836983_egoless
eldress835003_eldress
eyeless1058053_eyeless
fadeless12258323_fadeless
fatless103212203_fatless
feastless1235043feastless
feckless17225783feckless
feeless103511103fe_eless
feetless1137383feetless
fernless1136063fernless
flagless1235403flagless
flapless1335343flapless
flawless1434503flawless
foamless13195843foamless
foodless12338383foodless
fordless12289003fordless
gapless10349993_gapless
gasless8319013_gasless
gladness1036153gladness
glandless1134163glandless
goalless935723goalless
godless938403_godless
gradeless11236703gradeless
greedless1144893greedless
haddest122711993h_addest
hades96035113h_ad_e_s
hadjees18356383h_adjees
hadjes175210403h_adje_s
hailers104017263h_ailers
hairless1157413hairless
halers94926913h_a_lers
hales85449843h_a_le_s
halest94823273h_a_lest
hallels103310133h_allels
haltless11308443haltless
hamlets123211403h_amlets
handlers124014143handlers
handles114020653handle_s
haoles94919803h_aole_s
hardness122411083hardness
harmless1337403harmless
harness102413933h_arness
haslets102510863h_aslets
haulers104012443h_aulers
headed114020473head_e_d
headend12398363head_end
headends13326723headends
header104422543head_e_r
headfish1845443headfish
headfuls1544313headfuls
headgear1343373headgear
headgears1443153headgears
headier113212953headie_r
headings133510493headings
headlamp1642853headlamp
headlamps1742473headlamps
headland1345613headland
headlands1444903headlands
headline12129613headline
headliners14144333headliners
headlines13119013headlines
headlock1844813headlock
headlocks1944463headlocks
headlong1334123headlong
headmen13259513headme_n
headmost1445493headmost
headpins1436103headpins
heads95127113head___s
headset11312603headse_t
headways1845003headways
healed105121443hea_le_d
healer94221803hea_le_r
heals85733453hea_l__s
healths13478753hea_lths
heapers123616673hea_pers
hearers104319783hea_rers
hearkens15336693hearkens
hearses104414533hearse_s
heartens113010153heartens
heaters104225223hea_ters
heathens143210153heathens
heathers143914733heathers
heaumes1237423heaume_s
heavens13439303hea_vens
heavers133717193hea_vers
heaves124120303hea_ve_s
heavies132713873heavie_s
heaviest143210443heaviest
heaviness15207063heaviness
hecklers17357123hecklers
heckles163711383heckle_s
heddle114211163heddle__
heders104119763he_d_ers
hedgers124310263he_dgers
hedges115016263he_dge_s
heeders114213743heed_ers
heedlessly1742773heedlessly
heelers103815623he_elers
heiress1036813he_iress
hellers103619833he_llers
henleys1334843he_nleys
herders113914123herd_ers
hexades18378703hexad_e_s
heydeys1732863heyd_eys
hideless12278713hideless
hiltless11297123hiltless
hipless12399923h_ipless
hitless103211193h_itless
hiveless14227933hiveless
holeless1189363holeless
homeless131110133homeless
hondles113614523hondle_s
hoofless14258013hoofless
hookless151238363hookless
hoopless13279263hoopless
hopeless13118303hopeless
hornless1137363hornless
huddlers13337633huddlers
huddles123712573huddle_s
hueless1058823h_ueless
humpless15226333humpless
hurdlers12337493hurdlers
hurdles113613373hurdle_s
hurtless11307783hurtless
hymnless1632803hymnless
idealess935653idea_less
idealless1042953idealless
jagless1537103_jagless
jawless1745653_jawless
keelless12236193keelless
keyless1436163ke_yless
kindless13289243kindless
ladlers84613573_ladlers
ladles74619543_ladle_s
landless94011173landless
lawless1037033_lawless
leadens83610983lead_ens
leaderless1143433leaderless
leaders83819603lead_ers
leadiest93314983leadiest
leaflets11244813leaflets
leanness837373leanness
legless838013le_gless
lensless835583lensless
lewdness1254173lewdness
lidless8309273_lidless
loamless10235213loamless
lordless9277483lordless
madness10310073_madness
manless93012933_manless
matless93014043_matless
meanness1037183meanness
measles92412753measle_s
meddlers12318203meddlers
meddles113213253meddle_s
medleys13115333me_dleys
mindless11319443mindless
napless93110283_napless
nearness838313nearness
neatness839153neatness
neckless14236433neckless
needlers9287423needlers
needles83211563needle_s
netless739863ne_tless
newsless1134533newsless
oarless73913373_oarless
padles95221123_padle_s
pearlers1039033pearlers
pedalers11239393pedalers
peddlers12298533peddlers
peddles112913703peddle_s
pedlers103013273pe_dlers
peerless1037513peerless
pegless1038053pe_gless
peltless10267373peltless
planless1036813planless
playless1334863playless
pleatless1134613pleatless
rayless10239003_rayless
readdress1143823readdress
readers83823773read_ers
readies83324713readie_s
readiest93719043readiest
readiness102611853readiness
reales64934123rea_le_s
realest73322433rea_lest
realness8410443realness
reassess836513reassess
reckless14257973reckless
reddles93315773reddle_s
redlegs936823re_dlegs
redness82012443re_dness
redress82511873re_dress
regardless1252893regardless
reinless8139433reinless
restless82713163restless
rindless92510193rindless
rodless8310073_rodless
sadness8310613_sadness
sandless93212343sandless
sapless93313443_sapless
scarless10189053scarless
sealers74323553sea_lers
selfless1135013selfless
sexless1467243se_xless
shadeless1335733shadeless
shearlegs1342493shearlegs
sheetless1235823sheetless
snapless10287463snapless
soapless10278073soapless
sodaless936113sodaless
spanless10247363spanless
starless81610843starless
taxless1436913_taxless
teazles16308923teazle_s
tentless8229843tentless
termless1036233termless
textless15245793textless
thawless1434083thawless
thewless1433923the_wless
tramless1037503tramless
treadlers1045893treadlers
treadles939703treadle_s
vealers103214293vea_lers
veinless11136263veinless
ventless11249053ventless
verbless1336033verbless
vestless11258843vestless
wardless12249303wardless
warless104015103_warless
wayless13308243_wayless
weakness1535353weakness
weariless1234763weariless
webless1237003we_bless
wheedlers1643193wheedlers
wheedles1534643wheedle_s
wheelless1543763wheelless
whelpless1742053whelpless
windless123310863windless
woodless12278453woodless
wordless12258843wordless
yeastless1234053yeastless
zestless17247433zestless

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 Filter1786911461620.440406115.9
2DLD Change Limit1461623437.45319611.2
3Display Results3433430.1402450.0
 (SQL Overall)1786913438.03322244.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.