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 “bronc” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
bronc9171434(None) 
bronco10179491bronco
broncs101611151broncs
baron78131242baron_
barong96015822barong
barons85025382barons
barony115915302barony
bionic103614572bionic
biont7727162biont
bloc85023272blo_c
blond85618372blond
bond75334362b_ond
bone65949322b_one
bong75633412b_ong
bonk105531712b_onk
bony96732082b_ony
boon67142172boon_
boons75031912boons
boric98024222boric
born67338412born_
borne77926792borne
boron76727142boron_
boronic11311162boronic
borons85520542borons
bran65740382bran_
branch134014772branch
brand85124492brand
brank115222282brank
brans75437432brans
brant74742172brant
bren65629562bren_
brens75823362brens
brent75734132brent
brin67038192brin_
brine75132272brine
bring85528502bring
brink116122002brink
brins75533972brins
briny104719662briny
briony1149042briony
bro56236602bro__
broach133611112broach
broad84817692broad
brock136017072brock
broil74918222broil
broke116019782broke
brome94421972brome
bromic122412692bromic
bromo95217202bromo
bronchi14176312bronchi
broncho14206462broncho
broncos11188072broncos
bronze173610922bronze
bronzy20306712bronzy
broo65129822bro_o
brooch13368442brooch
brood84620242brood
brook114717762brook
broom95022212broom
broos75126412broos
bros65635662bro_s
brose75227032brose
brosy106115382brosy
broth106521092broth
brow97228442bro_w
brown105619532brown
browns116415632browns
browny144510042browny
brows105425982brows
brunch13329352brunch
brung84613912brung
brunt75728752brunt
bryony1435832bryony
croc85723732cro_c
crone75231332crone
crony105918672crony
drone65324982drone
franc104615412franc
frond95316342frond
frons86124042frons
front85029222front
iron46728462iron_
irone55126362irone
ironic8313772ironic
irons55324132irons
irony85015902irony
krona93611792krona
krone94018732krone
prone75332622prone
prong85218112prong
roc520243252_ro_c
trona54118952trona
trone55131862trone
wrong94712322wrong

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit53800941.39038705.0
3Display Results94940.0303133.3
 (SQL Overall)178691941.716104132.3
 
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.