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

297 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
grabble1233964(None) 
brabble10349971brabble
drabble12238881drabble
gabble113815721g_abble
grabbled14327371grabbled
grabbler13377691grabbler
grabbles13339891grabbles
gribble12297271gribble
rabble103818241_rabble
arable81821002ara_ble
babble94017112_babble
brabbled12337632brabbled
brabbler11397372brabbler
brabbles11349752brabbles
bramble133710032bramble
dabble114515192_dabble
drabbled14367052drabbled
drabbles13308522drabbles
dribble12368602dribble
fribble14287782fribble
gabbled134112452g_abbled
gabbler124013302g_abbler
gabbles124415412g_abbles
gable85325522g_a_ble
gamble115417182g_amble
garble94118452g_arble
gobble113512982g_obble
grabbable1343192grabbable
grabbed13368642grabbed
grabber12389762grabber
grabbier13316652grabbier
grabblers14345512grabblers
grabby14336182grabb_y
gracile102512602gracile
grackle14338892grackle
gradable1238822gradable
granule839472granule
grapple12378002grapple
grazable2036222grazable
gribbles13307362gribbles
grumble12349232grumble
rabbled123514422_rabbled
rabbler113514092_rabbler
rabbles113517972_rabbles
ramble104519972_ramble
rubble104315672_rubble
scabble13168652scabble
scrabble14196992scrabble
wabble133714842_wabble
abbe87627193__abb_e
abele76323253__abele
able66340533__a_ble
abubble1044523abubble
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
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
gabbed125216893g_abbed
gabber114916603g_abber
gabbier12379633g_abbier
gabblers134110083g_abblers
gabbro11114953g_abbro
gabby135512953g_abb_y
gabelle10259213g_abelle
gabled105518453g_a_bled
gables94222333g_a_bles
gaggle93412623g_aggle
gale56347323g_a__le
gambe106219213g_amb_e
gambled134112163g_ambled
gambler123612683g_ambler
gambles124016203g_ambles
garbage1138053garbage
garbled114512803g_arbled
garbler104012563g_arbler
garbles104016923g_arbles
gargle84215463g_argle
gelable101710733gelable
getable101712553getable
girasole984423girasole
globule1034383globule
gnawable1435683gnawable
gobbled134010253g_obbled
gobbler123310023g_obbler
gobbles123512583g_obbles
graal64316503gra_al_
graals74112913gra_als
grab75427613gra_b__
grabbers13337883grabbers
grabbiest1435323grabbiest
grabbing14267313grabbing
grabbling1564583grabbling
graben9419723gra_ben
grabens10367003grabens
grabs85719693gra_b_s
grace85124543gra__ce
graciles112511613graciles
grackles15309183grackles
gradate9511233gradate
grade75126093gra__de
gradine93317033gradine
grail64622873gra_il_
grails77518783gra_ils
gramme114210333gra_mme
grandee93115513grandee
grandly1238743grandly
grange83716203gra_nge
granite82017083granite
grannie8310353grannie
granola837913granola
grantable1257293grantable
grantee83217133grantee
granules939933granules
grape84824663gra__pe
grapnel1035603grapnel
grappled14336093grappled
grappler13336193grappler
grapples13348123grapples
graspable1444873graspable
grate64932883gra__te
gratine84719193gratine
graupel1034133graupel
grave94624873gra__ve
gravel105313823gravel_
graveled13417363graveled
gravels113611143gravels
gravely14469063gravely
gravure1134953gravure
grayly13287963gra_yly
graze155820053gra__ze
grazeable2144153grazeable
grebe85114943gr_eb_e
griddle1035503griddle
grille74315743gr_ille
gripple12416613gripple
gristle8169223gristle
grizzle16306113grizzle
growable1435623growable
grubbed13406433grubbed
grubber12417913grubber
grubbier13344753grubbier
grubbily1642973grubbily
grubby14324503grubb_y
grumbled14256753grumbled
grumbler13866683grumbler
grumbles13288873grumbles
grumbly15355403grumbly
gruntle8257053gruntle
guayule1142823guayule
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 7 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.390458182.1
2DLD Change Limit1340272975.97022450.1
3Display Results2972970.1102700.0
 (SQL Overall)1786912976.47027618.4
 
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.