Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “barranco” with Change Limit: [1] [2] [3] [4]

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

49 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 Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
barranco	12	4	494	(None)
barranca	12	4	558	1	barranca
barrancos	13	4	420	1	barrancos
barbasco	14	4	314	2	barbasco
barrack	15	3	825	2	barra_ck
barrancas	13	4	509	2	barrancas
marrano	9	3	942	2	marran_o
aberrance	13	5	568	3	aberrance
aberrancy	16	8	376	3	aberrancy
arrack	12	11	1025	3	_arra_ck
arrange	8	3	868	3	_arrange
arrant	6	6	2325	3	_arran_t
balance	11	5	1026	3	ba_lance
banco	9	40	1939	3	b___anco
barbascos	15	4	273	3	barbascos
barman	10	35	1970	3	barman__
barrable	12	4	924	3	barrable
barracks	16	3	688	3	barracks
barracoon	13	4	330	3	barracoon
barrage	10	7	1084	3	barra_ge
barraged	12	9	768	3	barraged
barrages	11	7	1108	3	barrages
barrater	10	3	1014	3	barrater
barrator	10	4	840	3	barrator
barratry	13	11	447	3	barratry
barren	8	53	1761	3	barren__
barrener	10	3	833	3	barrener
barrenly	13	4	542	3	barrenly
barrens	9	44	1432	3	barren_s
barring	10	40	2159	3	barrin_g
barrio	8	3	1257	3	barr__io
branch	13	40	1477	3	b__ranch
bronco	10	17	949	3	b__ronco
carrack	15	4	875	3	carra_ck
errancy	12	5	636	3	_errancy
farrago	11	4	492	3	farra_go
garbanzo	20	4	258	3	garbanzo
largando	10	4	380	3	largando
marranos	10	3	842	3	marranos
parlance	12	4	872	3	parlance
parlando	11	4	541	3	parlando
serrano	7	6	846	3	serran_o
tarriance	11	4	427	3	tarriance
vagrancy	17	4	345	3	vagrancy
variance	13	9	741	3	variance
warrant	10	6	1424	3	warran_t
warrantor	12	4	321	3	warrantor
warrants	11	6	850	3	warrants
warranty	14	6	504	3	warranty

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	146162	0.420	425454.8
2	DLD Change Limit	146162	49	6.626	22058.9
3	Display Results	49	49	0.030	1633.3
	(SQL Overall)	178691	49	7.076	25253.1