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

312 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
bramble13371003(None) 
brabble10349971brabble
brambled15316721brambled
brambles14308971brambles
brambly16296251brambly
ramble104519971_ramble
amble95924632__amble
arable81821002ara_ble
babble94017112b_abble
bauble103813212b_auble
blamable1436692blamable
brabbled12337632brabbled
brabbler11397372brabbler
brabbles11349752brabbles
braille939712braille
bramblier1543502bramblier
brattle9249252brattle
bumble124216892b_umble
crambe1239072cramb_e
crumble133410402crumble
drabble12238882drabble
drumble12337892drumble
framable1537572framable
gamble115417182_gamble
grabble12339642grabble
grumble12349232grumble
preamble1436372preamble
rabble103818242_rabble
rambla103510932_rambla
rambled123913512_rambled
rambler113313262_rambler
rambles113118312_rambles
rumble103718812_rumble
scramble14177252scramble
shamble14149262shamble
trample11299702trample
tremble1138002tremble
wamble134415752_wamble
able66340533__a_ble
abradable1495063abradable
ambled115116353__ambled
ambler104916443__ambler
ambles105121853__ambles
amole75724593__amole
ample94720303__ample
arables91814973ara_bles
arame75026623aram__e
atremble1244113atremble
babbled113612863b_abbled
babbler104012823b_abbler
babbles104416323b_abbles
babe86835813b_a_b_e
babel95821693b_a_bel
baffle14399873b_affle
bale66353843b_a__le
bamboo12310013b_amboo
bangle94018953b_angle
barbe95328283b_arb_e
barbel104317073b_arbel
barbie105018353b_arbie
barbule1137943barbule
barmie103816393barm_ie
barrable1249243barrable
battle85217863b_attle
baubee103215993b_aubee
baubles113611863b_aubles
bawbee132714233b_awbee
beadle93314683bea_dle
beagle93612593bea_gle
beamily1477393beamily
bearable121512363bearable
beatable121612243beatable
bedabble1243703bedabble
bejumble2172773bejumble
besmile1137463besmile
bible95119413b__ible
biramose1243933biramose
bitable11312203bitable
blamably1744903blamably
blame95625493blam__e
blameable1544723blameable
boatable121610263boatable
bobble94115143b_obble
bombe115519313b_omb_e
bomblet13412263b_omblet
brabblers12335563brabblers
brace95629273bra__ce
bracelet12310693bracelet
braciole1246973braciole
bractlet1239283bractlet
brae65639113bra___e
brail75525553bra_il_
brailed103914013bra_iled
brailled1147193brailled
brailler1036883brailler
brailles1039483brailles
brails84621293bra_ils
braise84318753bra_ise
braize174113113bra_ize
brake116025343bra__ke
brambliest1643773brambliest
brambling1635543brambling
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
bribable1137223bribable
bribe94820773br_ib_e
bribee104316363br_ibee
brickle15279933brickle
bricole112810493bricole
bridle94115463br_idle
brindle104210103brindle
bristle91910103bristle
brittle9168603brittle
bromal10313653bromal_
bromals1139743bromals
bromate11313553bromate
brome94421973brom__e
bromide12269583bromide
bromine112915243bromine
bromize20238823bromize
brumal1049503brumal_
brumbies1436533brumbies
brumby15385953brumb_y
brume95817983brum__e
bubble94016593b_ubble
bumbled144113043b_umbled
bumbler134013233b_umbler
bumbles134016843b_umbles
burble104617703b_urble
burnable1237263burnable
buyable1437493buyable
cable95329913_ca_ble
crackle153611253crackle
cradle93313163cra_dle
crambes1339953crambes
crambo1238043cramb_o
cramboes1436543cramboes
crambos1336783crambos
crankle133610063crankle
crimple13408693crimple
crumbled15357443crumbled
crumbles14329683crumbles
crumbly16347523crumbly
crumple13368363crumple
curable112414513cura_ble
dabble114515193_dabble
doable93115243doa_ble
drabbled14367053drabbled
drabbles13308523drabbles
drably123511613dra_bly
draggle1056103draggle
drapable1377573drapable
drawable1467113drawable
dribble12368603dribble
drumbled14266033drumbled
drumbles13277723drumbles
dryable13237433dryable
durable102312723dura_ble
dyable12308983dya_ble
enable83318483ena_ble
erasable10511043erasable
errable9312183errable
example1844283example
fable105824753_fa_ble
farmable1538203farmable
fimble133611743_fimble
flambe13489153flamb_e
flambee144210013flambee
foamable1537043foamable
formable1539503formable
fragile1147843fragile
frame105821803fram__e
frameable1645353frameable
frazzle18305223frazzle
friable122612563friable
fribble14287783fribble
fryable15277463fryable
fumble133214263_fumble
gabble113815723_gabble
gable85325523_ga_ble
gambe106219213_gamb_e
gambled134112163_gambled
gambler123612683_gambler
gambles124016203_gambles
garble94118453_garble
grabbled14327373grabbled
grabbler13377693grabbler
grabbles13339893grabbles
gracile102512603gracile
grackle14338893grackle
gradable1238823gradable
gramme114210333gram_me
granule839473granule
grapple12378003grapple
grazable2036223grazable
gribble12297273gribble
grumbled14256753grumbled
grumbler13866683grumbler
grumbles13288873grumbles
grumbly15355403grumbly
hirable121612313hira_ble
humble133615053_humble
jambe165314753_jamb_e
jumble174012653_jumble
lambie103213663_lambie
liable81415813lia_ble
marble104219103_marble
mumble123614343_mumble
namable11312333_namable
nimble103412933_nimble
oracle84313293ora_cle
parable111819773parable
prattle9208833prattle
preambled1643883preambled
preambles1545323preambles
rabbled123514423_rabbled
rabbler113514093_rabbler
rabbles113517973_rabbles
rackle123917293_rackle
raddle84816173_raddle
raffle123910703_raffle
raggle83712883_raggle
rale45050563_ra__le
ramal74622243_ramal_
ramate83921683_ramate
ramblas112710263_ramblas
ramblers124010373_ramblers
ramee74633853_ram_ee
ramie75027823_ram_ie
ramilie9310283_ramilie
ramose8314403_ramose
rampole1139693_rampole
rankle103414883_rankle
rassle63813203_rassle
ratable91717553_ratable
rattle64717613_rattle
rimple103814583_rimple
roble75223023_r_oble
rouble83913313_rouble
rubble104315673_rubble
ruble74521253_r_uble
rumbled124514593_rumbled
rumbler113514113_rumbler
rumbles114018393_rumbles
rumbly134412163_rumbly
rumple103913013_rumple
sable74732163_sa_ble
sample104215013_sample
scabble13168653scabble
scrabble14196993scrabble
scrambled16164813scrambled
scrambler15165043scrambler
scrambles15146383scrambles
scumble1337013scumble
shamable15168793shamable
shambled16156153shambled
shambles15159043shambles
stable83921643sta_ble
stumble1147553stumble
suable83920553sua_ble
table75429603_ta_ble
tamable11312843_tamable
tamale83717393_tamale
thimble1435863thimble
trachle12311853trachle
tradable1139873tradable
tramel84113713tramel_
trameled11309073trameled
tramell9398703tramell
tramels93812493tramels
trammel11357663trammel
trampled13247903trampled
trampler12278003trampler
tramples122610203tramples
treble8311663tr_eble
trembled1335243trembled
trembler1235363trembler
trembles1237353trembles
trembly1435523trembly
triable92515393triable
trouble957703trouble
tumble103215643_tumble
unable83819223una_ble
usable84012553usa_ble
viable111613773via_ble
wabble133714843_wabble
wambled153610753_wambled
wambles143714023_wambles
wambly16388663_wambly
warble113516603_warble
wimble133211913_wimble
wirable121610963wira_ble
wrangle1137383wrangle
wrassle10357173wrassle
wrastle10368993wrastle

Search took 10 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.1401276364.3
2DLD Change Limit1340273129.08014760.7
3Display Results3123120.1102836.4
 (SQL Overall)1786913129.33019152.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.