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

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

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.

70 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
burgundies	14	5	178	(None)
brandies	11	7	1456	3	b_r_andies
burdies	10	41	1756	3	bur___dies
burglaries	13	4	419	3	burglaries
burgundy	15	4	135	3	burgund__y
burnies	9	40	1782	3	bur__n_ies
organdies	11	8	721	3	_organdies
turgencies	13	4	551	3	turgencies
urgencies	12	5	664	3	_urgencies
argufies	12	4	374	4	_argu_fies
auguries	9	4	793	4	au_gu_ries
bandies	10	41	2486	4	b___andies
baronies	10	3	1502	4	bar_on_ies
begrudges	14	7	236	4	begru_dges
biogenies	12	4	851	4	biogen_ies
birdies	10	40	1621	4	bir___dies
bounties	10	3	1140	4	b__ounties
brandied	12	5	911	4	b_r_andied
braunites	11	4	672	4	b_raunites
brigandines	15	5	243	4	brigandines
brindles	11	37	1022	4	b_r_indles
brinies	9	33	1791	4	b_r_in_ies
brionies	10	3	1054	4	b_rion_ies
brogueries	13	4	481	4	brogueries
brownies	13	18	961	4	b_rown_ies
brulyies	13	4	342	4	b_r_ulyies
brulzies	19	3	398	4	b_r_ulzies
brumbies	14	3	653	4	b_r_umbies
brunches	15	37	1045	4	b_r_unches
bryonies	13	3	684	4	b_ryon_ies
buddies	11	39	1435	4	b___uddies
budgies	11	53	1251	4	budg___ies
buggeries	13	4	708	4	bu_ggeries
buggies	11	46	1381	4	bu_g__gies
bundles	10	35	1577	4	b___undles
bunnies	9	44	1500	4	b___unnies
buoyancies	17	4	299	4	buoyancies
burdie	9	36	1502	4	bur___die_
burgages	12	3	648	4	burg__ages
burgees	10	49	1589	4	burg___ees
burgesses	12	4	551	4	burg_esses
burglarizes	23	5	292	4	burglarizes
burgles	10	56	1596	4	burg___les
burgonet	11	4	810	4	burgon__et
burgonets	12	4	351	4	burgon_ets
burgraves	15	4	344	4	burg_raves
buries	8	46	3327	4	bur____ies
burnie	8	37	1541	4	bur__n_ie_
burnsides	12	4	423	4	bur__nsides
bursaries	11	5	764	4	bur_saries
busybodies	18	5	113	4	busybodies
byrnies	12	37	857	4	byr__n_ies
currencies	14	4	566	4	currencies
furmenties	15	4	485	4	furmenties
furuncles	14	4	249	4	fur_uncles
gerundives	15	5	173	4	ger_undives
gunnies	8	34	1312	4	___gunnies
hurdies	11	40	1566	4	hur___dies
maundies	11	3	785	4	__maundies
organdie	10	9	612	4	_organdie_
outguides	11	4	541	4	outguid_es
pungencies	15	4	472	4	pungencies
randies	8	42	2566	4	__r_andies
rundles	8	32	1471	4	__r_undles
surgeries	10	3	1136	4	surg_eries
trendies	9	3	1221	4	_tr_endies
trundles	9	27	848	4	_tr_undles
unbundles	12	4	378	4	_unbundles
undies	7	38	2196	4	____undies
uranides	9	22	1128	4	_ur_anides

Search took 10 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	161450	0.513	348325.5
2	DLD Change Limit	161450	70	9.330	17304.4
3	Display Results	70	70	0.030	2333.3
	(SQL Overall)	178691	70	9.873	18099.0