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

274 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
drabble1223888(None) 
brabble10349971brabble
dabble114515191d_abble
drabbled14367051drabbled
drabbles13308521drabbles
dribble12368601dribble
grabble12339641grabble
rabble103818241_rabble
arable81821002ara_ble
babble94017112_babble
brabbled12337632brabbled
brabbler11397372brabbler
brabbles11349752brabbles
bramble133710032bramble
dabbled133712072d_abbled
dabbler124012152d_abbler
dabbles124514772d_abbles
dibble114013842d_ibble
doable93115242doa_ble
drabbed13428722drabbed
drabber12438592drabber
drabbet12319572drabbet
drably123511612dra_bly
draggle1056102draggle
drapable1377572drapable
drawable1467112drawable
dribbled14376592dribbled
dribbler13316312dribbler
dribbles13348392dribbles
dribblet13347542dribblet
dribbly15274952dribbly
drumble12337892drumble
dryable13237432dryable
durable102312722dura_ble
dyable12308982dya_ble
fribble14287782fribble
gabble113815722_gabble
grabbled14327372grabbled
grabbler13377692grabbler
grabbles13339892grabbles
gribble12297272gribble
rabbled123514422_rabbled
rabbler113514092_rabbler
rabbles113517972_rabbles
ramble104519972_ramble
rubble104315672_rubble
scabble13168652scabble
scrabble14196992scrabble
wabble133714842_wabble
abbe87627193__abb_e
abele76323253__abele
able66340533__a_ble
abubble1044523abubble
addable11218843adda_ble
adorable1138773adora_ble
amble95924643__amble
arabize1849343arabize
arables91814973ara_bles
babbled113612863_babbled
babbler104012823_babbler
babbles104416323_babbles
barbule1137943barbule
bauble103813213_bauble
bedabble1243703bedabble
bobble94115143_bobble
brabblers12335563brabblers
braille939713braille
brambled15316733brambled
brambles14308973brambles
brambly16296253brambly
brattle9249253brattle
bribable1137223bribable
bubble94016593_bubble
cabbie122913353_cabbie
cable95329913_ca_ble
cobble123615263_cobble
crabbed14388873crabbed
crabber133810733crabber
crabbier14326803crabbier
crabbily1744343crabbily
crabby15346753crabb_y
crackle153611253crackle
cradle93313163cra_dle
crambe1239073cramb_e
crankle133610063crankle
cribbled15305803cribbled
crumble133410403crumble
curable112414513cura_ble
curbable1447663curbable
dabbed124416143d_abbed
dabber114816963d_abber
dabblers13379363d_abblers
daddle94214283d_addle
daggle93711903d_aggle
dale55643983d_a__le
dandle84218093d_andle
dangle84119303d_angle
dapple1138853d_apple
dariole8711163dariole
darkle113813943d_arkle
dartle73714833d_artle
datable101714233datable
daube85015303d_aub_e
dawdle11399503d_awdle
dazzle1536853d_azzle
debacle1237443debacle
diabase1037113diabase
diabolo1065483diabolo
diazole1736793diazole
dibbled133510843d_ibbled
dibbler124510283d_ibbler
dibbles124013333d_ibbles
disable10516433disable
double94013993d_ouble
dowable13189453dowable
drab76226453dra_b__
drabbest13295663drabbest
drabbets13294823drabbets
drabbing14286803drabbing
drabbling1544553drabbling
drabs85119673dra_b_s
draftable1575563draftable
draftee11379523draftee
dragee84415603dra_gee
draggled1254673draggled
draggles1145963draggles
drail65020973dra_il_
drails74716953dra_ils
drainable1237583drainable
drake104918303dra__ke
drape85319633dra__pe
drapeable1445673drapeable
drave95219273dra__ve
drawbar13103193drawbar
drawbore1442683drawbore
drawee104413823dra_wee
drawl95516013dra_wl_
drawled12368343dra_wled
drawler11338593dra_wler
drawls105511393dra_wls
drawly134910723dra_wly
drayage1234423drayage
dribbed13326753dribbed
dribblers14274453dribblers
dribblets14294143dribblets
driblet103712243dr_iblet
drivable1438023drivable
drizzle16285913drizzle
drubbed13406983drubbed
drubber12357863drubber
drumbled14266033drumbled
drumbles13277723drumbles
dupable12238383dupable
durables11237013dura_bles
durably13229053dura_bly
dyeable1337303dyeable
enable83318483ena_ble
erasable10511043erasable
errable9312183errable
fable105824753_fa_ble
fragile1147843fragile
framable1537573framable
frazzle18305223frazzle
friable122612563friable
fribbled16305743fribbled
fribbler15265953fribbler
fribbles15287713fribbles
fryable15277463fryable
gabbled134112453_gabbled
gabbler124013303_gabbler
gabbles124415413_gabbles
gable85325523_ga_ble
gamble115417183_gamble
garble94118453_garble
gobble113512983_gobble
grabbable1343193grabbable
grabbed13368643grabbed
grabber12389763grabber
grabbier13316653grabbier
grabblers14345513grabblers
grabby14336183grabb_y
gracile102512603gracile
grackle14338893grackle
gradable1238823gradable
granule839473granule
grapple12378003grapple
grazable2036223grazable
gribbles13307363gribbles
grumble12349233grumble
habile11515213_habile
hirable121612313hira_ble
hobble133913433_hobble
kibble143910953_kibble
labile8315223_labile
liable81415813lia_ble
marble104219103_marble
nibble103713283_nibble
nobble103814313_nobble
nubble103813713_nubble
oracle84313293ora_cle
parable111819773parable
pebble1238003_pebble
prattle9208833prattle
preamble1436383preamble
probable1439053probable
quibble2034713quibble
rabbet103818653_rabbet
rabbi93113183_rabb_i
rabbies113416053_rabbies
rabbin103112303_rabbin
rabbis102613163_rabbis
rabbit102914563_rabbit
rabblers123810853_rabblers
rackle123917293_rackle
raddle84816173_raddle
raffle123910703_raffle
raggle83712883_raggle
rale45050563_ra__le
rambla103510933_rambla
rambled123913523_rambled
rambler113313263_rambler
rambles113118313_rambles
rankle103414883_rankle
rassle63813203_rassle
ratable91717553_ratable
rattle64717613_rattle
rebbe9313163_rebb_e
roble75223023_r_oble
rouble83913313_rouble
rubbled124611623_rubbled
rubbles113715113_rubbles
rubbly133710613_rubbly
ruble74521253_r_uble
rumble103718813_rumble
sable74732163_sa_ble
scabbled15156303scabbled
scabbles14167983scabbles
scrabbled16154973scrabbled
scrabbler15195203scrabbler
scrabbles15206283scrabbles
scrabbly17164623scrabbly
scramble14177253scramble
scribble14175433scribble
shamble14149263shamble
sorbable1239303sorbable
squabble2143883squabble
stabile9312063stabile
stable83921643sta_ble
stubble1136843stubble
suable83920553sua_ble
swabbie1484333swabbie
table75429603_ta_ble
trachle12311853trachle
tradable1139873tradable
trample11299703trample
treble8311663tr_eble
tremble1138003tremble
triable92515393triable
trouble957713trouble
unable83819223una_ble
usable84012553usa_ble
viable111613773via_ble
wabbled153311443_wabbled
wabbler143511923_wabbler
wabbles144013993_wabbles
wabbly16348363_wabbly
wamble134415753_wamble
warble113516603_warble
wirable121610963wira_ble
wobble133212313_wobble
wrangle1137383wrangle
wrassle10357173wrassle
wrastle10368993wrastle
yabbie13308663_yabbie

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272746.82619634.8
3Display Results2742740.0932946.2
 (SQL Overall)1786912747.32524394.7
 
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.