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

313 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
bronco1017949(None) 
bronc91714341bronc_
broncho14206461broncho
broncos11188071broncos
broncs101611151broncs
banco94019392b_anco
bongo85720942b_ongo
branch134014782branch
broach133611112broach
brock136017072bro_ck
bromo95217202bro_mo
bronchi14176312bronchi
bronchos15206172bronchos
bronze173610922bronze
bronzy20306712bronzy
broo65129822bro__o
brooch13368442brooch
brunch13329352brunch
bunco94616082b_unco
drongo836792drongo
pronto8313992pronto
rondo65218372_rondo
abroach1446213abroach
arco68331543ar__co
bagnio937523bagnio
bancos104713893b_ancos
banjo143812443b_anjo
baron78131243baron__
baronet91022213baronet
barong96015823baron_g
barongs105310833barongs
baronne938273baronne
barons85025383baron_s
barony115915303baron_y
barranco1244943barranco
beano75421553bean_o
bench125619503b_ench
bento75922953b_ento
bingo86020093b_ingo
binocs1039923binocs
bionic103614573bionic
bionics114310873bionics
biont7727163bion_t
bionts8612393bionts
blanch133410853blanch
blench133710453blench
bloc85023273blo_c_
block134917843blo_ck
blocs95219653blo_cs
blond85618373blon_d
blonde94813293blonde
blonds95213343blonds
blotch13197143blotch
blotto8198443blotto
bocce114313113b_occe
bocci113512713b_occi
bock126032513b_o_ck
boffo136010373b_offo
boho96923323b_o_ho
bolo65535953b_o_lo
bonaci10310963b_onaci
bonbon10310073b_onbon
bond75334363b_on_d
bonds86126843b_onds
bone65949323b_on_e
boned85133243b_oned
boner75133083b_oner
bones76446533b_ones
boney105227313b_oney
bong75633413b_on_g
bongos95316653b_ongos
bongs87828423b_ongs
bonito8313433b_onito
bonk105531713b_on_k
bonks116326463b_onks
bonne75124713b_onne
bonny105816623b_onny
bonobo1037143b_onobo
bonus75324323b_onus
bony96732083b_on_y
bonze165119353b_onze
boo58163663b_o__o
booboo1039463booboo
boocoo1039003boocoo
boohoo1148833boohoo
bookoo1248343bookoo
boon67142173boon__
boons75031913boon_s
boric98024223boric_
born67338413born__
borne77926793born_e
borneol936823borneol
boron76727143boron__
boronic11311163boronic
borons85520543boron_s
borsch1336133borsch
botch126717453b_otch
bounce104014833bounce
bouncy13409073bouncy
boyo96923843b_o_yo
bozo156821413b_o_zo
brace95629273br_ace
brach126123303br_ach
bract96332723br_act
bran65740383bran__
branchy17357913branchy
brand85124493bran_d
brands95118943brands
brandy124712063brandy
brank115222283bran_k
branks124817383branks
branny115111833branny
brans75437433bran_s
brant74742173bran_t
brants85723053brants
bravo105214343br_avo
breach134213723breach
breech13348263breech
bren65629563bren__
brens75823363bren_s
brent75734133bren_t
brents84717283brents
brick134618153br_ick
brillo84211003brillo
brin67038193brin__
brine75132273brin_e
brined95118413brined
briner84519043briner
brines85028853brines
bring85528503brin_g
brings94618433brings
brink116122003brin_k
brinks124616313brinks
brins75533973brin_s
briny104719663brin_y
brio65432493br__io
briony1149043brion_y
bro56236603br___o
broad84817693bro_ad
broads94515153broads
broccoli1443553broccoli
broche133612103broche
brocks145214153brocks
brocoli1146353bro_coli
brogan9311043brogan
brogue94211033brogue
broil74918223bro_il
broils84114173broils
broke116019783bro_ke
broken124011523broken
broker124314243broker
brolly114510853brolly
bromal10313653bromal
brome94421973bro_me
bromes104719763bromes
bromic122412693bromic
bromid112612893bromid
bromin102615693bromin
bromos104213313bromos
bronchia15195993bronchia
bronchus15204743bronchus
bronzed19308213bronzed
bronzer18348493bronzer
bronzes183510403bronzes
brood84620243bro_od
broods95416383broods
broody124510083broody
brook114717763bro_ok
brooks125813883brooks
broom95022213bro_om
brooms104915873brooms
broomy13449953broomy
broos75126413bro_os
bros65635663bro__s
brose75227033bro_se
broses86524403broses
brosy106115383bro_sy
broth106521093bro_th
broths115013923broths
brothy14519623brothy
brow97228443bro__w
browed125216403browed
brown105619533bro_wn
browned134710973browned
browner124911643browner
brownie12178433brownie
browns116415633browns
browny144510043browny
brows105425983bro_ws
browse115713863browse
brunet84419293brunet
brung84613913brun_g
brunt75728753brun_t
brunts85215453brunts
bryony1435833bryon_y
bunch125118603b_unch
buncos104011593b_uncos
bunko115514513b_unko
coco87330603_co_co
conch124620073_conch
concho134414263_concho
condo85322593_condo
congo85623133_congo
conto76027173_conto
corncob1345663corncob
cranch133613533cranch
croc85723733cro_c_
croci95818133cro_ci
crock135921993cro_ck
crocs95722433cro_cs
crone75231333cron_e
crones84729243crones
crony105918673cron_y
crotch133410083crotch
crouch133910203crouch
crunch13349503crunch
drench12369593drench
drone65324983dron_e
droned84616863droned
droner74717673droner
drones75023433drones
drongos935493drongos
eringo739553eringo
eryngo1033613eryngo
franc104615413franc_
francs114112193francs
french143511213french
fresco1136473fresco
frock145314653fro_ck
frond95316343fron_d
fronds106412343fronds
frons86124043fron_s
front85029223fron_t
fronton1037203fronton
fronts94415793fronts
frounce1236153frounce
gonzo15310243_gonzo
grinch1238483grinch
gringo838643gringo
grotto7349813grotto
grouch12318473grouch
honcho14389383_honcho
iroko939663iro_ko
iron46728463iron__
irone55126363iron_e
ironed74916013ironed
ironer64216453ironer
irones64724013irones
ironic8313773ironic
irons55324133iron_s
irony85015903iron_y
junco144612203_junco
krona93611793kron_a
krone94018733kron_e
kronen10348913kronen
kroner104612573kroner
kronor10417233kronor
kronur10415313kronur
loco67030743_lo_co
mondo85721233_mondo
mongo810122413_mongo
mono66036723_mon_o
morocco1343523morocco
nonce75719823_nonce
noncom1039683_noncom
once65423083__once
ono36838033__on_o
onto46127663__onto
phono104917023phon_o
poco86826153_po_co
ponce95222513_ponce
poncho133310123_poncho
porno75120653porn_o
prance104318573prance
prince104114763prince
princox1843573princox
promo95620003pro_mo
prone75332623pron_e
prong85218113pron_g
prongs94314483prongs
proso77222413pro_so
rance75028513_rance
ranch105019793_ranch
rancho114310853_rancho
rancor8810373_rancor
roach105717003_roach
roc520243253_ro_c_
rock105735183_ro_ck
rococo1036813_rococo
rocs65533663_ro_cs
rodeo65921093_rodeo
romeo73719703_romeo
rondos74616733_rondos
ronion63315643_ronion
ronyon9309133_ronyon
roscoe839763_roscoe
rotch105815933_rotch
roto45935053_ro_to
sconce104711723sconce
sirocco1143033sirocco
tondo69718683_tondo
trance84718763trance
trench114211613trench
trock114817603tro_ck
trona54118953tron_a
tronas63816903tronas
trone55131863tron_e
trones65629283trones
trounce936823trounce
unco66021403__unco
wrench14439353wrench
wrong94712323wron_g
wrongs10338933wrongs

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 Filter1786911127160.406440125.6
2DLD Change Limit1127163136.36017722.6
3Display Results3133130.0933365.6
 (SQL Overall)1786913136.85926052.0
 
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.