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

349 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
barkless1431802(None) 
backless162910631backless
barbless12318711barbless
barless94317001bar_less
armless9369942_armless
artless73712512_artless
bareness10912812bareness
barkeeps1634142barkeeps
barkers134318512bark_ers
barkiest144115152barkiest
barleys125011842bar_leys
baroness101210062baroness
baseless1099562baseless
bathless13127382bathless
beakless14297382beakless
beardless1234912beardless
brakeless1544992brakeless
braless92910562b_raless
careless102813632careless
carless95118492car_less
darkles124011932darkle_s
darkness13247342darkness
earless74316072ear_less
forkless15267432forkless
garbless11388252garbless
harmless1337402harmless
oarless73913372oar_less
rankless12268232rankless
tackless14419482tackless
tankless12267822tankless
wardless12249302wardless
warless104015102war_less
wartless11279922wartless
workless15276802workless
ageless8310343_ageless
aidless83612073_aidless
aimless93610813_aimless
airless73712043_airless
ankles104818383_ankle_s
anklets114310413_anklets
argles75218483_argle_s
arkoses113910833_arkoses
arles56735743_ar_le_s
armlets94610063_armlets
ashless10318453_ashless
auklets11298573_auklets
aweless1038723_aweless
awless939263_a_wless
awnless1035923_awnless
babblers113510353babblers
babbles104416323babble_s
backers153821883back_ers
backlash1945923backlash
backlist16910653backlist
backlists17117413backlists
backlogs1746633backlogs
backrest1639393backrest
backrests1744983backrests
backsets1638853backsets
badgeless1343203badgeless
badness1039573ba_dness
bafflers16356593bafflers
baffles153710683baffle_s
bailees93914383ba_ilees
bailers94221353ba_ilers
baileys12388933ba_ileys
bakers125323453ba_k_ers
bakes117035373ba_k_e_s
baldness1137043baldness
balers85626933ba__lers
bales76250083ba__le_s
balkers134915723balk_ers
balkiest144112453balkiest
balkiness1556903balkiness
ballers94421013ba_llers
ballets93719513ba_llets
bangles103617413bangle_s
bankers133919093bank_ers
barbells12368823barbells
barbels114514433bar_bels
barbers114317503bar_bers
barbes104526233bar_be_s
barbets114915843bar_bets
barbies114519593barbie_s
barbules1238043barbule_s
bardes95026933bar_de_s
bareges105212033barege_s
bares75457133bar__e_s
barest85327693bar__est
barflies1338303barflies
bargees105415873bar_gees
barges94528253bar_ge_s
barghest1447913barghest
barghests1543313barghests
barguest1137163barguest
barguests1243483barguests
barillas10310193barillas
barites94322333barite_s
barked135027313bark_e_d
barkeep1536363bark_eep
barker124822863bark_e_r
barkier133814483barkie_r
barks115735813bark___s
barley115116763bar_le_y
barlows12259973bar_lows
barmiest125212783barmiest
barneys12569563bar_neys
barniest104815053barniest
baronets101410903baronets
barques18259643barque_s
barrels94514363bar_rels
barrens94414323bar_rens
barres84427543bar_re_s
barrets94917103bar_rets
barriers104311883barriers
barters94223033bar_ters
baryes116218503bar_ye_s
barytes124611153baryte_s
baseness10910943baseness
baskets135111833bask_ets
bassness1096743bassness
battlers104110973battlers
battles94517683battle_s
baubles113611863bauble_s
bawlers124412733ba_wlers
beamless12327003beamless
beatless103311593beatless
bedless1039703b_edless
beefless1335493beefless
beltless10297713beltless
berryless1442293berryless
bibless11439173b_ibless
birkies133712433birkie_s
birlers93813003bir_lers
birles84920643bir_le_s
blacklegs1843913blacklegs
blackness1735663blackness
bladeless1234303bladeless
blameless1334733blameless
blankness1544673blankness
bless75917813b___less
blotless10347153blotless
bodiless1135913bodiless
boltless10338283boltless
bondless1148813bondless
boneless10310213boneless
booklets14247123booklets
boonless10328353boonless
bootless103410983bootless
bowless123310313b_owless
bractless1335543bractless
brainless1136403brainless
brakes124923123brak_e_s
brakiest143912243brakiest
brandless1236123brandless
brawlers13408643brawlers
brimless1235273brimless
browless1346653browless
bucklers16349503bucklers
buckles153416093buckle_s
budless1038873b_udless
burblers12399263burblers
burbles114916803burble_s
burgess10409343bur_gess
burgles105615963burgle_s
burkers133716623burk_ers
burkes124421313burk_e_s
burlers94120273bur_lers
burlesk1335463bur_lesk
burlesks1443223bur_lesks
burleys12479673bur_leys
bushless1335813bushless
cacklers163710703cacklers
cackles153717203cackle_s
capless114312763ca_pless
caress85720263car__ess
carles85435083car_le_s
carolers103314173carolers
cashless1336773cashless
charmless1633583charmless
chartless1435703chartless
cookless14258633cookless
cordless11299963cordless
coreless103013833coreless
cureless10319703cureless
dankness13256693dankness
darkens12409873dark_ens
darkest122512623dark_est
darkeys15356533dark_eys
darkies124015753darkie_s
darkle113813943darkle__
darkled13378723darkle_d
darkliest1435163darkliest
dartles84014133dartle_s
dateless9259963dateless
faceless13269173faceless
fadeless12258323fadeless
fameless13259203fameless
fangless1237663fangless
farles96025783far_le_s
farness102912203far_ness
fartleks1533963fartleks
fatless103212203fa_tless
fearless1137873fear_less
feckless17225783feckless
fernless1136063fernless
fireless112810593fireless
fordless12289003fordless
formless13248083formless
furless103210143fur_less
gainless9117403gainless
gapless10349993ga_pless
garblers113810283garblers
garbles104016923garble_s
garglers10418263garglers
gargles94214893gargle_s
gasless8319013ga_sless
gateless9279953gateless
gearless937373gear_less
gormless11235443gormless
hacklers173710303hacklers
hackles162917063hackle_s
hairless1157413hairless
haltless11308443haltless
handless123512063handless
hapless123311333ha_pless
hardness122411083hardness
harkens144112863hark_ens
harness102413933har_ness
harslets1137833harslets
hatless103813443ha_tless
heartless1236393heartless
herbless1336663herbless
hookless151238363hookless
hornless1137363hornless
hurtless11307783hurtless
inkless11348713_inkless
ireless72312243_ireless
jacklegs2233963jacklegs
jagless1537103ja_gless
jawless1745653ja_wless
juryless1832983juryless
laceless10239853laceless
landless94011173landless
lankness12237043lankness
largess8408913lar_gess
larkers113014513lark_ers
larkiest123713323larkiest
larkiness1338113larkiness
lawless1037033la_wless
leakless12246983leakless
lordless9277483lordless
luckless14265893luckless
mackles154415753mackle_s
mailless10248583mailless
maneless102812343maneless
manless93012933ma_nless
marblers12319233marblers
marbles114516653marble_s
markers133516103mark_ers
markets133314033mark_ets
marquess19204953marquess
martlets103310483martlets
massless10277113massless
mastless102610023mastless
mateless102711293mateless
matless93014043ma_tless
milkless1434773milkless
nameless10248373nameless
napless93110283na_pless
nathless11127023nathless
neckless14236433neckless
normless10235923normless
orbless937493_orbless
packness1636933packness
painless10108343painless
paneless102611763paneless
parflesh1643743parflesh
parkers133816873park_ers
parles86334403par_le_s
parleys125212373par_leys
parolees104313983parolees
paroles95025883parole_s
parsleys1335083parsleys
partlets102811513partlets
passless10247223passless
pastless102411203pastless
pathless13138043pathless
peakless14236683peakless
portless10310643portless
rainless8129703rainless
rankles113114543rankle_s
rankness12267943rankness
rareness81112853rareness
rayless10239003ra_yless
reckless14257973reckless
riskless1235763riskless
rockless14297293rockless
sailless82410373sailless
saltless8259343saltless
sandless93212343sandless
sapless93313443sa_pless
sarkiest123615073sarkiest
sashless1136603sashless
scarless10189053scar_less
sockless14267793sockless
sparklers15315643sparklers
sparkles143210493sparkle_s
sparklets15275843sparklets
stackless1555933stackless
stalkless1333723stalkless
starkness1335963starkness
starless81610843star_less
suckless14288823suckless
tacklers143010773tacklers
tackles133816523tackle_s
tactless10288463tactless
tailless8239083tailless
tameless10259903tameless
tapeless10218643tapeless
tartlets8289663tartlets
tartness82210133tartness
taxless1436913ta_xless
tearless848713tear_less
termless1036233termless
thankless1633203thankless
tireless82510263tireless
trackless15246723trackless
tramless1037503tramless
turfless1135533turfless
tuskless1234213tuskless
varlets10411573var_lets
verbless1336033verbless
wageless1237173wageless
wakeless1536473wakeless
warblers13319103warblers
warbles123215563warble_s
wardress12256163wardress
wariness11313213wariness
warmness1337063warmness
warslers11328073warslers
warsles103413643warsle_s
wattless11268723wattless
waveless1437483waveless
wayless13308243wa_yless
weariless1234763weariless
wickless1736083wickless
wireless11249633wireless
wordless12258843wordless

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.423422437.4
2DLD Change Limit1461623497.92018454.8
3Display Results3493490.1402492.9
 (SQL Overall)1786913498.48321064.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.