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

296 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
brabble1034997(None) 
babble94017111b_abble
brabbled12337631brabbled
brabbler11397371brabbler
brabbles11349751brabbles
bramble133710031bramble
drabble12238881drabble
grabble12339641grabble
rabble103818241_rabble
arable81821002ara_ble
babbled113612862b_abbled
babbler104012822b_abbler
babbles104416322b_abbles
barbule1137942barbule
bauble103813212b_auble
bedabble1243702bedabble
bobble94115142b_obble
brabblers12335562brabblers
braille939712braille
brambled15316732brambled
brambles14308972brambles
brambly16296252brambly
brattle9249252brattle
bribable1137222bribable
bubble94016592b_ubble
dabble114515192_dabble
drabbled14367052drabbled
drabbles13308522drabbles
dribble12368602dribble
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
abradable1495063abradable
abubble1044523abubble
amble95924643__amble
arabize1849343arabize
arables91814973ara_bles
babblers113510353b_abblers
babe86835823b_a_b_e
babel95821693b_abel_
babels105216723b_abels
babul96317713b_abul_
babuls105413643b_abuls
baffle14399873b_affle
bale66353843b_a__le
bangle94018953b_angle
barbal104016663barbal_
barbate11314543barbate
barbe95328283b_arb_e
barbel104317073barbel_
barbell11429963barbell
barbels114514433barbels
barbie105018353b_arbie
barbules1238043barbules
barrable1249243barrable
battle85217863b_attle
baubee103215993b_aubee
baubles113611863b_aubles
bawbee132714233b_awbee
beadle93314683bea_dle
beagle93612593bea_gle
bearable121512363bearable
beatable121612243beatable
bedabbled1442543bedabbled
bedabbles1343043bedabbles
bible95119423b__ible
bitable11312203bitable
blabbed11357813blabbed
blabber10418923blabber
blabby1234813blabb_y
blamable1436693blamable
boatable121610263boatable
bobbled113811833b_obbled
bobbles104514913b_obbles
bombable1336263bombable
brabbling1334963brabbling
brace95629273bra__ce
bracelet12310693bracelet
braciole1246973braciole
bractlet1239283bractlet
brae65639113bra___e
brail75525553bra_il_
brailed103914013bra_iled
brailled1147193brailled
brailler1036883brailler
brailles1039493brailles
brails84621293bra_ils
braise84318753bra_ise
braize174113113bra_ize
brake116025343bra__ke
bramblier1543503bramblier
brashly15427613brashly
brasil8713863brasil_
brasils9410973brasils
brassie93411523brassie
brattled11196723brattled
brattles10199333brattles
brave104925503bra__ve
bravely15428233bravely
bravure1254393bravure
brawl106217963bra_wl_
brawled133910123bra_wled
brawler124310233bra_wler
brawlie12198153brawlie
brawls115214333bra_wls
brawly144312353bra_wly
braze165423453bra__ze
brazil1779623brazil_
brazils1867753brazils
breakable1746163breakable
bribe94820783br_ib_e
bribee104316363br_ibee
brickle15279933brickle
bricole112810493bricole
bridle94115463br_idle
brindle104210103brindle
bristle91910103bristle
brittle9168603brittle
bubale104014623b_ubale
bubbled113612123b_ubbled
bubbler103611783b_ubbler
bubbles104315963b_ubbles
bubbly124110353b_ubbly
bumble124216893b_umble
burble104617703b_urble
burnable1237263burnable
buyable1437493buyable
cabbie122913353_cabbie
cable95329913_ca_ble
cobble123615263_cobble
crabbed14388873crabbed
crabber133810733crabber
crabbier14326803crabbier
crabbily1744343crabbily
crabby15346753crabb_y
crackle153611253crackle
cradle93313163cra_dle
crambe1239073cramb_e
crankle133610063crankle
cribbled15305803cribbled
crumble133410403crumble
curable112414513cura_ble
curbable1447663curbable
dabbled133712073_dabbled
dabbler124012153_dabbler
dabbles124514773_dabbles
dibble114013843_dibble
doable93115243doa_ble
drabbed13428723drabbed
drabber12438593drabber
drabbet12319573drabbet
drably123511613dra_bly
draggle1056103draggle
drapable1377573drapable
drawable1467113drawable
dribbled14376593dribbled
dribbler13316313dribbler
dribbles13348393dribbles
dribblet13347543dribblet
dribbly15274953dribbly
drumble12337893drumble
dryable13237433dryable
durable102312723dura_ble
dyable12308983dya_ble
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
trouble957703trouble
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.1701051123.5
2DLD Change Limit1340272966.75019855.9
3Display Results2962960.1102690.9
 (SQL Overall)1786912967.03025418.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.