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

Here are the results of your fuzzy-string dictionary search for “bondholders” 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.

64 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
bondholders	18	5	283	(None)
bondholder	17	5	309	1	bondholder_
landholders	16	5	325	2	landholders
bandoleers	13	4	356	3	band_oleers
bandoliers	13	4	414	3	band_oliers
beholders	15	4	493	3	b__eholders
cardholders	18	5	299	3	cardholders
coholders	15	3	562	3	co__holders
condolers	12	27	1057	3	cond_ol_ers
copyholders	22	5	217	3	copyholders
gondoliers	12	4	369	3	gond_oliers
inholders	13	4	535	3	_in_holders
jobholders	23	5	217	3	jo_bholders
landholder	15	6	355	3	landholder_
penholders	16	4	379	3	pen_holders
potholders	16	4	434	3	po_tholders
toolholders	15	5	251	3	toolholders
bandleaders	15	5	271	4	bandleaders
bandoleer	12	4	425	4	band_oleer_
bandolier	12	4	528	4	band_olier_
bankrollers	17	6	195	4	bankrollers
beholder	14	3	505	4	b__eholder_
boltholes	14	4	572	4	bolthol_e_s
bonders	10	41	2066	4	bon____ders
bondless	11	4	881	4	bond__l_ess
bonhomies	16	5	578	4	bon_homie_s
boodlers	11	37	1074	4	bood__l_ers
boreholes	14	4	735	4	borehol_e_s
boulders	11	30	1003	4	bo___ulders
bowlders	14	30	649	4	bo___wlders
bundlers	11	39	918	4	bund__l_ers
bungholes	15	4	399	4	bunghol_e_s
candleholders	20	6	165	4	candleholders
cardholder	17	5	317	4	cardholder_
coholder	14	3	607	4	co__holder_
condoler	11	34	1212	4	cond_ol_er_
condoles	11	30	1580	4	cond_ol_e_s
condoners	12	28	1151	4	cond_o_ners
consolers	11	25	1092	4	con_sol_ers
controllers	13	4	478	4	controllers
copyholder	21	5	225	4	copyholder_
enfolders	13	9	509	4	_en_folders
fondlers	12	33	802	4	fond__l_ers
freeholders	18	5	285	4	freeholders
gasholders	15	4	380	4	_gasholders
gondolier	11	4	472	4	gond_olier_
handholds	17	4	500	4	handhold__s
holders	11	37	1590	4	____holders
householders	19	5	285	4	householders
infolders	13	8	517	4	_in_folders
inholder	12	7	611	4	_in_holder_
jobholder	22	4	224	4	jo_bholder_
nongolfers	14	4	339	4	non_golfers
penholder	15	4	441	4	pen_holder_
pewholders	19	4	270	4	_pewholders
potholder	15	4	476	4	po_tholder_
stadtholders	17	5	225	4	stadtholders
stockholders	22	12	288	4	stockholders
toolholder	14	5	279	4	toolholder_
unfolders	13	4	472	4	_un_folders
unsolders	10	6	469	4	_un_solders
upholders	15	4	364	4	__upholders
windhovers	20	4	221	4	windho_vers
withholders	21	5	198	4	withholders

Search took 9 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	148819	0.436	409841.7
2	DLD Change Limit	148819	64	8.266	18003.8
3	Display Results	64	64	0.030	2133.3
	(SQL Overall)	178691	64	8.732	20463.9