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

285 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
brambles1430897(None) 
brabbles11349751brabbles
bramble133710031bramble_
brambled15316731brambled
rambles113118311_rambles
ambles105121862__ambles
arables91814982ara_bles
babbles104416322b_abbles
baubles113611862b_aubles
brabble10349972brabble_
brabbled12337632brabbled
brabbler11397372brabbler
brabblers12335562brabblers
brailles1039502brailles
bramblier1543502bramblier
brambliest1643772brambliest
brambly16296252brambl_y
brattles10199332brattles
brumbies1436532brumbies
bumbles134016842b_umbles
crambes1339962cramb_es
cramboes1436542cramboes
crumbles14329682crumbles
drabbles13308522drabbles
drumbles13277722drumbles
gambles124016202_gambles
grabbles13339892grabbles
grumbles13288872grumbles
preambles1545332preambles
rabbles113517972_rabbles
ramblas112710262_ramblas
ramble104519972_ramble_
rambled123913522_rambled
rambler113313262_rambler
ramblers124010372_ramblers
rumbles114018392_rumbles
scrambles15146382scrambles
shambles15159042shambles
tramples122610202tramples
trembles1237352trembles
wambles143714022_wambles
ables75935543__a_bles
amble95924643__amble_
ambled115116373__ambled
ambler104916453__ambler
amblers115213563__amblers
amoles84122193__amoles
arable81821003ara_ble_
arames84622573aram__es
babble94017113b_abble_
babbled113612863b_abbled
babbler104012823b_abbler
babblers113510353b_abblers
babels105216723b_a_bels
babes95834113b_a_b_es
babies106123653b_a_bies
baffles153710683b_affles
bales76250083b_a__les
bamboos1348753b_amboos
bangles103617413b_angles
barbels114514433b_arbels
barbes104526233b_arb_es
barbies114519593b_arbies
barbless12318713b_arbless
barbules1238043barbules
battles94517683b_attles
baubees11348713b_aubees
bauble103813213b_auble_
bawbees14337243b_awbees
beadles103414733bea_dles
beagles103212123bea_gles
beamless12327003beam_less
bedabbles1343043bedabbles
bejumbles22122443bejumbles
besmiles1237393besmiles
bibles104617643b__ibles
bimboes13498733b_imboes
blamable1436693blamable_
blameless1334733blameless
blames105121863blam__es
bobbles104514913b_obbles
bombes124916823b_omb_es
bomblet13412263b_omblet
bomblets1436023b_omblets
bracelet12310693bracelet
bracelets1345963bracelets
braces108427773bra__ces
braches144621223bra_ches
bracioles1346493bracioles
bractless1335543bractless
bractlet1239283bractlet
bractlets1344753bractlets
braes75735053bra___es
brailed103914013bra_iled
braille939713braille_
brailled1147193brailled
brailler1036883brailler
braillers1135563braillers
brails84621293bra_il_s
brainless1136413brainless
braises93818873bra_ises
braizes183112453bra_izes
brakeless1544993brakeless
brakes124923123bra__kes
braless92910563bra__less
brambling1635543brambling
bramblings1742613bramblings
branches153613803branches
brandies11714563brandies
brandless1236133brandless
brashes124518463bra_shes
brasils9410973brasil_s
brasses93818353bra_sses
brassies103613533brassies
brattle9249253brattle_
brattled11196723brattled
braves115524083bra__ves
bravoes12418533bra_voes
brawled133910123bra_wled
brawler124310233bra_wler
brawlers13408643bra_wlers
brawls115214333bra_wl_s
braxies16711463bra_xies
brazes175522193bra__zes
brazils1867753brazil_s
breakables1842753breakables
bribees11409283br_ibees
bribes105918533br_ib_es
brickles162810283brickles
bricoles122610303bricoles
bridles104114473br_idles
brimless1235273brim_less
brindles113710233brindles
bristles101510433bristles
brittles10178653brittles
bromals1139743bromal_s
bromates12413153bromates
bromes104719763brom__es
bromides13219373bromides
bromines122514253bromines
bromizes21258333bromizes
brumes106417073brum__es
bubbles104315963b_ubbles
bumble124216893b_umble_
bumbled144113043b_umbled
bumbler134013233b_umbler
bumblers143710733b_umblers
burbles114916803b_urbles
burnables1344003burnables
cables104527553_ca_bles
crackles164111273crackles
cradles103114133cra_dles
crambe1239073cramb_e_
crambos1336783cramb_os
crankles143510163crankles
crimples14308963crimples
crumble133410403crumble_
crumbled15357443crumbled
crumples14348813crumples
dabbles124514773_dabbles
drabble12238883drabble_
drabbled14367053drabbled
draggles1145963draggles
dribbles13348393dribbles
drumble12337893drumble_
drumbled14266033drumbled
durables11237013dura_bles
enables92813123ena_bles
examples1944313examples
fables114921673_fa_bles
fimbles143510663_fimbles
flambes14419503flamb_es
framable1537573framable_
frameless1435533frameless
frames115119863fram__es
frazzles19284813frazzles
fribbles15287713fribbles
fumbles143514413_fumbles
gabbles124415413_gabbles
gables94222333_ga_bles
gambes116318313_gamb_es
gamble115417183_gamble_
gambled134112163_gambled
gambler123612683_gambler
gamblers13369733_gamblers
garbles104016923_garbles
grabble12339643grabble_
grabbled14327373grabbled
grabbler13377693grabbler
grabblers14345513grabblers
graciles112511613graciles
grackles15309183grackles
grammes123611323gram_mes
granules939943granules
grapples13348123grapples
gribbles13307363gribbles
grumble12349233grumble_
grumbled14256753grumbled
grumbler13866683grumbler
grumblers14245023grumblers
humbles143215803_humbles
jambes175914053_jamb_es
jumbles183013323_jumbles
lambies113015113_lambies
mamboes135011823_mamboes
marbles114516653_marbles
mumbles133014433_mumbles
nombles113212343_nombles
numbles113814273_numbles
oracles93212423ora_cles
parables121613573parables
prattles10189413prattles
preamble1436383preamble_
preambled1643893preambled
rabbies113416053_rabbies
rabble103818243_rabble_
rabbled123514423_rabbled
rabbler113514093_rabbler
rabblers123810853_rabblers
rabies85226023_ra_bies
raddles93615703_raddles
raffles133611853_raffles
raggles93813283_raggles
rales54947493_ra__les
rambla103510933_rambl_a
ramees84620893_ram_ees
ramies84630463_ram_ies
ramilies10311833_ramilies
rampoles1238893_rampoles
rankles113114553_rankles
rassles73513923_rassles
ratables10159723_ratables
rattles73217303_rattles
rimples113114223_rimples
robles85321693_r_obles
roubles93413513_roubles
rubbles113715113_rubbles
rubles83921703_r_ubles
rumble103718813_rumble_
rumbled124514593_rumbled
rumbler113514113_rumbler
rumblers123610743_rumblers
rumples113313133_rumples
sables85026693_sa_bles
samples112815453_samples
scabbles14167983scabbles
scrabbles15206283scrabbles
scramble14177253scramble_
scrambled16164813scrambled
scrambler15165043scrambler
scramblers16183543scramblers
scumbles1447023scumbles
shamble14149263shamble_
shambled16156153shambled
stables93219073sta_bles
stumbles1237493stumbles
tables84524893_ta_bles
tamales93216153_tamales
thimbles1536023thimbles
trachles13311753trachles
trameled11309073trameled
tramells10327833tramells
tramels93812493tramel_s
tramless1037503tram_less
trammels12295413trammels
trample11299703trample_
trampled13247903trampled
trampler12278013trampler
tramplers13305883tramplers
trebles9311443tr_ebles
tremble1138003tremble_
trembled1335253trembled
trembler1235363trembler
tremblers1334483tremblers
troubles1057203troubles
tumbles113816023_tumbles
umbles103817493__umbles
wabbles144013993_wabbles
wamble134415753_wamble_
wambled153610753_wambled
warbles123215563_warbles
wimbles143010853_wimbles
wrangles1237473wrangles
wrassles11376713wrassles
wrastles11328933wrastles

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622856.42322756.0
3Display Results2852850.1102590.9
 (SQL Overall)1786912856.95325699.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.