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

354 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
barbless1231871(None) 
barkless14318021barkless
barless94317001bar_less
garbless11388251garbless
armless9369942_armless
artless73712512_artless
babblers113510352babblers
babbles104416322babble_s
backless162910632backless
barbells12368822barbells
barbels114514432barb_els
barbers114317502barb_ers
barbes104526232barb_e_s
barbets114915842barb_ets
barbies114519592barbie_s
barbules1238042barbule_s
bareness10912812bareness
barleys125011842bar_leys
baroness101210062baroness
baseless1099562baseless
bathless13127382bathless
baubles113611862bauble_s
beardless1234912beardless
bibless11439172b_ibless
braless92910562b_raless
burblers12399262burblers
burbles114916802burble_s
careless102813632careless
carless95118492car_less
earless74316072ear_less
garblers113810282garblers
garbles104016922garble_s
harmless1337402harmless
herbless1336662herbless
marblers12319232marblers
marbles114516652marble_s
oarless73913372oar_less
orbless937492_orbless
verbless1336032verbless
warblers13319102warblers
warbles123215562warble_s
wardless12249302wardless
warless104015102war_less
wartless11279922wartless
abbess10509773_a_bbess
ables75935543_a_ble_s
ablest84721833_a_blest
ageless8310343_ageless
aidless83612073_aidless
aimless93610813_aimless
airless73712043_airless
amblers115213563_amblers
ambles105121863_amble_s
arables91814973_arable_s
arbalest1039523_arbalest
arbalests1144123_arbalests
arbelest1049503_arbelest
arbelests1143653_arbelests
argles75218483_argle_s
arles56735743_ar_le_s
armlets94610063_armlets
ashless10318453_ashless
aweless1038723_aweless
awless939263_a_wless
awnless1035923_awnless
babble94017113babble__
babbled113612863babble_d
babbler104012823babble_r
babels105216723ba_b_els
babes95834113ba_b_e_s
babies106123653ba_bie_s
babiest114414753ba_biest
badgeless1343203badgeless
badness1039573ba_dness
bafflers16356593bafflers
baffles153710683baffle_s
bailees93914383ba_ilees
bailers94221353ba_ilers
baileys12388933ba_ileys
baldness1137043baldness
balers85626933ba__lers
bales76250083ba__le_s
ballers94421013ba_llers
ballets93719513ba_llets
bangles103617413bangle_s
barbe95328283barb_e__
barbed115121313barb_e_d
barbel104317073barb_e_l
barbell11429963barb_ell
barber104419323barb_e_r
barbet104427883barb_e_t
barbicels15113513barbicels
barbie105018353barbie__
barbs95928193barb___s
barbule1137943barbule__
barbuts11439843barb_uts
bardes95026933bar_de_s
bareges105212033barege_s
bares75457133bar__e_s
barest85327693bar__est
barflies1338303barflies
bargees105415873bar_gees
barges94528253bar_ge_s
barghest1447913barghest
barghests1543313barghests
barguest1137163barguest
barguests1243483barguests
barillas10310193barillas
barites94322333barite_s
barkeeps1634143barkeeps
barkers134318513bar_kers
barkiest144115153barkiest
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
bassness1096743bassness
battlers104110973battlers
battles94517683battle_s
baubees11348713baub_ees
bauble103813213bauble__
bawbees14337243bawb_ees
bawlers124412733ba_wlers
beakless14297383beakless
beamless12327003beamless
beatless103311593beatless
bedless1039703b_edless
beefless1335493beefless
beltless10297713beltless
berryless1442293berryless
bibles104617643b_ible_s
birlers93813003bir_lers
birles84920643bir_le_s
bladeless1234303bladeless
blameless1334733blameless
bless75917813___bless
blotless10347153blotless
bobbles104514913bobble_s
bodiless1135913bodiless
boltless10338283boltless
bomblets1436023bomblets
bondless1148813bondless
boneless10310213boneless
boonless10328353boonless
bootless103410983bootless
bowless123310313b_owless
brabblers12335563brabblers
brabbles11349753brabble_s
bractless1335543bractless
brainless1136403brainless
brakeless1544993brakeless
brambles14308973bramble_s
brandless1236123brandless
brawlers13408643brawlers
brimless1235273brimless
browless1346653browless
bubblers11448943bubblers
bubbles104315963bubble_s
budless1038873b_udless
bulblets1255353bulblets
bumblers143710733bumblers
bumbles134016843bumble_s
burble104617703burble__
burbled124312673burble_d
burbler114412423burble_r
burbliest1365593burbliest
burgess10409343bur_gess
burgles105615963burgle_s
burlers94120273bur_lers
burlesk1335463bur_lesk
burlesks1443223bur_lesks
burleys12479673bur_leys
bushless1335813bushless
cablers114416713ca_blers
cables104527553ca_ble_s
cablets114216343ca_blets
capless114312763ca_pless
carbonless1444083carbonless
caress85720263car__ess
carles85435083car_le_s
carolers103314173carolers
cashless1336773cashless
charmless1633583charmless
chartless1435703chartless
cordless11299963cordless
coreless103013833coreless
cureless10319703cureless
dabblers13379363dabblers
dabbles124514773dabble_s
darbies104216983darbie_s
darkles124011933darkle_s
darkness13247343darkness
dartles84014133dartle_s
dateless9259963dateless
drabness1135803drabness
fablers124812613fa_blers
fables114921673fa_ble_s
faceless13269173faceless
fadeless12258323fadeless
fameless13259203fameless
fangless1237663fangless
farles96025783far_le_s
farness102912203far_ness
fartleks1533963fartleks
fatless103212203fa_tless
fearless1137873fear_less
fernless1136063fernless
fireless112810593fireless
fordless12289003fordless
forkless15267433forkless
formless13248083formless
furless103210143fur_less
gabblers134110083gabblers
gabbles124415413gabble_s
gables94222333ga_ble_s
gainless9117403gainless
gamblers13369733gamblers
gambles124016203gamble_s
gapless10349993ga_pless
garble94118453garble__
garbled114512803garble_d
garbler104012563garble_r
garglers10418263garglers
gargles94214893gargle_s
gasless8319013ga_sless
gateless9279953gateless
gearless937373gear_less
gormless11235443gormless
hairless1157413hairless
haltless11308443haltless
handless123512063handless
hapless123311333ha_pless
harborless1542663harborless
hardness122411083hardness
harness102413933har_ness
harslets1137833harslets
hatless103813443ha_tless
heartless1236393heartless
hornless1137363hornless
hurtless11307783hurtless
ireless72312243_ireless
jagless1537103ja_gless
jawless1745653ja_wless
jobless16237563_jobless
juryless1832983juryless
laceless10239853laceless
landless94011173landless
largess8408913lar_gess
lawless1037033la_wless
limbless12246313limbless
lordless9277483lordless
mailless10248583mailless
maneless102812343maneless
manless93012933ma_nless
marble104219103marble__
marbled123212113marble_d
marbleise1343483marbleise
marbleises1443523marbleises
marbler113511673marble_r
marbliest1336763marbliest
marquess19204953marquess
martlets103310483martlets
massless10277113massless
mastless102610023mastless
mateless102711293mateless
matless93014043ma_tless
nameless10248373nameless
napless93110283na_pless
nathless11127023nathless
normless10235923normless
outbless1037963outbless
painless10108343painless
paneless102611763paneless
parables121613563parable_s
parflesh1643743parflesh
parles86334403par_le_s
parleys125212373par_leys
parolees104313983parolees
paroles95025883parole_s
parsleys1335083parsleys
partlets102811513partlets
passless10247223passless
pastless102411203pastless
pathless13138043pathless
portless10310643portless
prebless1236823prebless
rabblers123810853rabblers
rabbles113517973rabble_s
rainless8129703rainless
ramblers124010373ramblers
rambles113118313ramble_s
rankless12268233rankless
rareness81112853rareness
rayless10239003ra_yless
ribless93410343_ribless
sables85026693sa_ble_s
sailless82410373sailless
saltless8259343saltless
sandless93212343sandless
sapless93313443sa_pless
sashless1136603sashless
scarless10189053scar_less
starless81610843star_less
tables84524893ta_ble_s
tablets94714383ta_blets
tackless14419483tackless
tactless10288463tactless
tailless8239083tailless
tameless10259903tameless
tankless12267823tankless
tapeless10218643tapeless
tartlets8289663tartlets
tartness82210133tartness
taxless1436913ta_xless
tearless848713tear_less
termless1036233termless
tireless82510263tireless
tombless1236783tombless
tramless1037503tramless
turfless1135533turfless
varlets10411573var_lets
wabblers15398993wabblers
wabbles144013993wabble_s
wageless1237173wageless
wakeless1536473wakeless
wambles143714023wamble_s
warble113516603warble__
warbled133212163warble_d
warbler123211463warble_r
wardress12256163wardress
wariness11313213wariness
warmness1337063warmness
warslers11328073warslers
warsles103413643warsle_s
wattless11268723wattless
waveless1437483waveless
wayless13308243wa_yless
weariless1234763weariless
webless1237003_webless
wireless11249633wireless
wordless12258843wordless
workless15276803workless

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 Filter1786911461620.420425454.8
2DLD Change Limit1461623546.58022213.1
3Display Results3543540.1402528.6
 (SQL Overall)1786913547.14025026.8
 
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.