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

228 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
drabbled1436705(None) 
brabbled12337631brabbled
dabbled133712071d_abbled
drabbed13428721drabb_ed
drabble12238881drabble_
drabbles13308521drabbles
dribbled14376591dribbled
grabbled14327371grabbled
rabbled123514421_rabbled
babbled113612862_babbled
brabble10349972brabble_
brabbler11397372brabbler
brabbles11349752brabbles
brambled15316722brambled
crabbed14388872crabb_ed
cribbled15305802cribbled
dabbed124416142d_abb_ed
dabble114515192d_abble_
dabbler124012152d_abbler
dabbles124514772d_abbles
dibbled133510842d_ibbled
drabber12438592drabb_er
drabbet12319572drabb_et
draggled1254672draggled
drawled12368342dra_wled
dribbed13326752dribb_ed
dribble12368602dribble_
dribbler13316312dribbler
dribbles13348392dribbles
dribblet13347542dribblet
drubbed13406982drubb_ed
drumbled14266032drumbled
fribbled16305742fribbled
gabbled134112452_gabbled
grabbed13368642grabb_ed
grabble12339642grabble_
grabbler13377692grabbler
grabbles13339892grabbles
rabble103818242_rabble_
rabbler113514092_rabbler
rabbles113517972_rabbles
rambled123913512_rambled
rubbled124611622_rubbled
scabbled15156302scabbled
scrabbled16154972scrabbled
wabbled153311442_wabbled
abled86926833__a_bled
ambled115116353__ambled
arabized2047173arabized
arable81821003ara_ble_
arables91814973ara_bles
babble94017113_babble_
babbler104012823_babbler
babbles104416323_babbles
bedabbled1442543bedabbled
blabbed11357813blabb_ed
bobbled113811833_bobbled
brabblers12335563brabblers
brailed103914013bra_iled
brailled1147193brailled
bramble133710033bramble_
brambles14308973brambles
brattled11196723brattled
brawled133910123bra_wled
bubbled113612123_bubbled
cabbed135416263_cabb_ed
cabled114819873_ca_bled
cobbled143411633_cobbled
craaled10339423cra_aled
crabber133810733crabb_er
crabbier14326803crabbier
crackled17428863crackled
cradled113410813cra_dled
crankled15408153crankled
crawled133710393cra_wled
cribbed14407663cribb_ed
crumbled15357443crumbled
dabber114816963d_abb_er
dabblers13379363d_abblers
daddled113810743d_addled
daggled11329463d_aggled
dandled103313543d_andled
dangled104013153d_angled
dappled1336393d_appled
darkled13378713d_arkled
dartled9409853d_artled
daubed104611783d_aub_ed
dawdled13376723d_awdled
daybed13438673d_ayb_ed
dazzled1735033d_azzled
derailed102410403dera_iled
dialed84716453dia__led
dialled9510133dia_lled
dibbed124713473d_ibb_ed
dibble114013843d_ibble_
dibbler124510283d_ibbler
dibbles124013333d_ibbles
disabled1248713disabled
doable93115243doa_ble_
doubled11289953d_oubled
drabbest13295663drabbest
drabbets13294823drabbets
drabbing14286803drabbing
drabbling1544553drabbling
drably123511613dra_bl_y
drafted12439033dra_fted
dragged11379553dra_gged
draggle1056103draggle_
draggles1145963draggles
drained93713253dra_ined
drammed13378073dra_mmed
drapable1377573drapable_
draped105314363dra__ped
dratted9358593dra_tted
drawable1467113drawable_
drawler11338593dra_wler
drayed115911393dra__yed
dribblers14274453dribblers
dribblets14294143dribblets
dribbly15274953dribbl_y
driblet103712243dr_iblet
drilled94711673dr_illed
driveled1374973driveled
drizzled18284573drizzled
drolled93810223dr_olled
drooled9369203dr_ooled
drubber12357863drubb_er
drumble12337893drumble_
drumbles13277723drumbles
dryable13237433dryable_
dubbed124113213d_ubb_ed
durable102312723dura_ble_
durables11237013dura_bles
dyable12308983dya_ble_
enabled102510633ena_bled
fabled124216383_fa_bled
frazzled20303993frazzled
fribble14287783fribble_
fribbler15265953fribbler
fribbles15287713fribbles
gabbed125216893_gabb_ed
gabble113815723_gabble_
gabbler124013303_gabbler
gabbles124415413_gabbles
gabled105518453_ga_bled
gambled134112163_gambled
garbled114512803_garbled
gobbled134010253_gobbled
grabber12389763grabb_er
grabbier13316653grabbier
grabblers14345513grabblers
grappled14336093grappled
graveled13417363graveled
gribble12297273gribble_
gribbles13307363gribbles
grubbed13406433grubb_ed
grumbled14256753grumbled
hobbled153310783_hobbled
jabbed184213483_jabb_ed
kibbled16367983_kibbled
kraaled12254983kra_aled
labeled102510563_labeled
marbled123212113_marbled
nabbed115113613_nabb_ed
nibbled12389073_nibbled
nobbled123511283_nobbled
pebbled1445393_pebbled
prattled11246533prattled
preambled1643883preambled
quibbled2232723quibbled
rabbet103818653_rabb_et
rabbeted1334443_rabbeted
rabbies113416053_rabbies
rabbited1334763_rabbited
rabblers123810853_rabblers
raddled103812223_raddled
raffled14429083_raffled
railed74727543_ra_iled
ramble104519973_ramble_
rambler113313263_rambler
rambles113118313_rambles
rankled123910653_rankled
rassled83310443_rassled
rattled84012953_rattled
raveled114113633_raveled
ribbed114014373_ribb_ed
robbed113415193_robb_ed
rubbed114515083_rubb_ed
rubble104315673_rubble_
rubbles113715113_rubbles
rumbled124514593_rumbled
sabbed114518083_sabb_ed
scabbed14408223scabb_ed
scabble13168653scabble_
scabbles14167983scabbles
scrabble14196993scrabble_
scrabbler15195203scrabbler
scrabbles15206283scrabbles
scrambled16164813scrambled
scribbled16174033scribbled
shambled16156153shambled
slabbed12409503slabb_ed
squabbled2342563squabbled
stabbed123510373stabb_ed
stabled103514953sta_bled
stubbled1385073stubbled
swabbed15367403swabb_ed
tabbed114215363_tabb_ed
tabbied12297793_tabbied
tabled94020043_ta_bled
trachled1438313trachled
trailed83415673tra_iled
trameled11309073trameled
trampled13247903trampled
traveled12349453traveled
trawled113411523tra_wled
trebled1038483tr_ebled
trembled1335243trembled
troubled1134973troubled
wabble133714843_wabble_
wabbler143511923_wabbler
wabbles144013993_wabbles
wambled153610753_wambled
warbled133212163_warbled
wobbled15349593_wobbled
wrangled1335593wrangled
wrassled12325373wrassled
wrastled12346433wrastled

Search took 9 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.1731032896.0
2DLD Change Limit1461622288.04618165.8
3Display Results2282280.1102072.7
 (SQL Overall)1786912288.32921454.1
 
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.