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

225 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
herbless133666(None) 
verbless1336031verbless
barbless12318712barbless
fernless1136062fernless
garbless11388252garbless
harmless1337402harmless
headless12289862headless
heartless1236392heartless
heatless113011462heatless
heedless12278812heedless
heelless11257652heelless
heirless1146052heirless
helmless1334272helmless
helpless1335062helpless
herbiest1339992herbiest
hornless1137362hornless
hurtless11307782hurtless
orbless937492_orbless
prebless1236822prebless
termless1036232termless
webless1237002we_bless
airless73712043air_less
armless9369943_armless
artless73712513_artless
barkless14318023barkless
barless94317003bar_less
beakless14297383beakless
beamless12327003beamless
beardless1234913beardless
beatless103311593beatless
bedless1039703be_dless
beefless1335493beefless
beltless10297713beltless
berryless1442293berryless
bibless11439173_bibless
bless75917813___bless
braless92910563_braless
burblers12399263burblers
burbles114916803burble_s
careless102813633careless
carless95118493car_less
charmless1633583charmless
chartless1435703chartless
checkless2044233checkless
cheekless1873883cheekless
cheerless1495293cheerless
cordless11299963cordless
coreless103013833coreless
crewless1335413crewless
cureless10319703cureless
debtless1135653debtless
deedless10318253deedless
derbies103016053derbie_s
dewless1137473de_wless
earless74316073_earless
eeriness8311873eeriness
eggless935663_eggless
egoless836983_egoless
emblems1335043_emblems
endless839833_endless
eyeless1058053_eyeless
fearless1137873fearless
feckless17225783feckless
feeblest1336913feeblest
feeless103511103fe_eless
feetless1137383feetless
ferules103112723ferule_s
fireless112810593fireless
fordless12289003fordless
forkless15267433forkless
formless13248083formless
fretless1138063fretless
furless103210143fur_less
garblers113810283garblers
garbles104016923garble_s
gearless937373gearless
gormless11235443gormless
hairless1157413hairless
haltless11308443haltless
handless123512063handless
hapless123311333h_apless
harborless1542663harborless
hardness122411083hardness
harness102413933har_ness
harslets1137833harslets
hatless103813443h_atless
healers104319463he_alers
heathless1535593heathless
hebes105521673he_b_e_s
hecklers17357123hecklers
heckles163711383heckle_s
heddles123311623heddle_s
heelers103815623he_elers
heiress1036813he_iress
hellers103619833he_llers
henleys1334843he_nleys
heralds1137713heral_ds
herbages1437093herbages
herbalism1647583herbalism
herbalisms1746283herbalisms
herbalist1449813herbalist
herbalists1546193herbalists
herbals122710613herb_als
herbed123513453herb_e_d
herbier1239593herbie_r
herblike1735883herblike
herbs105520503herb___s
hercules1337633hercule_s
herculeses15113013herculeses
herders113914123her_ders
heredes11313133herede_s
heres86245903her__e_s
heresy125011233her__esy
herls85226433her_l__s
heroes94923823her_oe_s
herpes115517323her_pe_s
herries104025073herrie_s
hertzes1938303hertze_s
hideless12278713hideless
hiltless11297123hiltless
hipless12399923h_ipless
hirples12149643hirple_s
hirsles101510073hirsle_s
hitless103211193h_itless
hiveless14227933hiveless
hobblers15308513hobblers
hobbles143313783hobble_s
holeless1189363holeless
homeless131110143homeless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279263hoopless
hopeless13118303hopeless
horseless1237223horseless
hueless1058823h_ueless
humblers15379803humblers
humbles143215803humble_s
humblest15288283humblest
humpless15226333humpless
hurdlers12337493hurdlers
hurdles113613373hurdle_s
hurlers103714323hur_lers
hurleys13407333hur_leys
hurtles103913753hurtle_s
hymnless1632803hymnless
ireless72312243_ireless
jobless16237563_jobless
juryless1832983juryless
keelless12236193keelless
kermess13396223ker_mess
keyless1436163ke_yless
leadless9248793leadless
leafless11246573leafless
leakless12246983leakless
legless838013le_gless
lensless835583lensless
limbless12246313limbless
lordless9277483lordless
marblers12319233marblers
marbles114516653marble_s
mealless10288363mealless
meatless103410863meatless
merciless1344473merciless
meritless1144593meritless
merles85322763mer_le_s
neckless14236433neckless
needless9308333needless
nerveless1243933nerveless
netless739863ne_tless
newsless1134533newsless
normless10235923normless
oarless73913373oar_less
outbless1037963outbless
peakless14236683peakless
pebbles1337573pebble_s
peerless1037513peerless
pegless1038053pe_gless
peltless10267373peltless
periblems1543483periblems
pertness10310093pertness
portless10310643portless
reckless14257973reckless
reinless8139433reinless
restless82713163restless
ribless93410343_ribless
seamless10238723seamless
seatless83213003seatless
seedless9319513seedless
selfless1135013selfless
sexless1467243se_xless
sheetless1235823sheetless
sherbets1335213sherb_ets
shirtless12266413shirtless
shoreless1236633shoreless
tearless848713tearless
tentless8229843tentless
textless15245793textless
thewless1433923the_wless
thornless1243633thornless
thumbless1643433thumbless
tireless82510263tireless
tombless1236783tombless
trebles9311443treble_s
treeless839283treeless
turfless1135533turfless
veinless11136263veinless
ventless11249053ventless
verbiles1338923verbile_s
vestless11258843vestless
warblers13319103warblers
warbles123215563warble_s
wardless12249303wardless
warless104015103war_less
wartless11279923wartless
weariless1234763weariless
weedless12287963weedless
weldless12285813weldless
wheatless1534003wheatless
wheelless1543763wheelless
whelpless1742053whelpless
wireless11249633wireless
wordless12258843wordless
workless15276803workless
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.403443402.0
2DLD Change Limit1461622258.17317883.5
3Display Results2252250.0932419.4
 (SQL Overall)1786912258.66920612.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.