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

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

74 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
bookends	15	37	485	(None)
bookend	14	39	664	1	bookend_
booked	13	53	1950	2	booke_d_
bookers	13	40	1661	2	booke_rs
bookings	15	35	873	2	bookings
backbends	20	4	409	3	backbends
bartends	11	3	679	3	bartends
bends	8	56	2897	3	b___ends
betokens	14	32	457	3	betoken_s
biogens	10	3	896	3	biogen_s
blends	9	60	1288	3	b__lends
blokes	12	38	1388	3	bloke__s
blonds	9	52	1334	3	blo__nds
bodkins	14	3	831	3	bodkin_s
bonds	8	61	2684	3	b_o__nds
bonked	13	55	1731	3	bonke_d_
bonkers	13	40	1530	3	bonke_rs
boobed	11	45	1487	3	boobe_d_
boobirds	13	4	418	3	boobirds
booed	8	51	2727	3	boo_e_d_
boogers	10	45	1463	3	booge_rs
boogeys	13	47	687	3	booge_ys
booker	12	47	1919	3	booke__r
bookfuls	17	4	345	3	bookfuls
bookies	13	38	1940	3	book_ies
booking	14	36	1838	3	bookin_g
booklets	14	24	712	3	booklets
bookmen	15	12	626	3	bookmen__
bookoos	13	3	750	3	book_oos
bookrests	15	4	262	3	bookrests
books	11	57	2971	3	book___s
bookstands	17	5	253	3	bookstands
boomed	11	53	1813	3	boome_d_
boomers	11	41	1591	3	boome_rs
boomkins	16	4	550	3	boomkin_s
boons	7	50	3191	3	boo__n_s
booted	9	48	2273	3	boote_d_
bootees	9	41	1447	3	boote_es
boozed	18	48	1383	3	booze_d_
boozers	18	39	1244	3	booze_rs
boozes	17	49	1652	3	booze__s
boreens	9	3	1040	3	boreen_s
borked	13	51	1729	3	borke_d_
boskets	13	40	947	3	boske_ts
bounds	9	44	1580	3	b_o_unds
bowheads	17	4	537	3	bowheads
broken	12	40	1152	3	broken__
brokenly	17	4	420	3	brokenly
brokers	13	31	1191	3	broke_rs
brokings	15	31	771	3	brokings
brooked	14	36	1003	3	brooke_d_
commends	15	30	846	3	commends
compends	15	37	825	3	compends
contends	11	28	1057	3	contends
cooked	13	59	2136	3	cooke_d_
cookers	13	46	1946	3	cooke_rs
cookeys	16	47	850	3	cooke_ys
cookings	15	35	860	3	cookings
forfends	15	4	483	3	forfends
godsends	11	11	335	3	godsends
hooked	14	53	2055	3	hooke_d_
hookers	14	49	1651	3	hooke_rs
hookeys	17	44	895	3	hooke_ys
looked	11	47	1707	3	looke_d_
lookers	11	40	1407	3	looke_rs
loosens	7	163	1095	3	loosen_s
offends	14	23	429	3	_offends
portends	11	35	896	3	portends
propends	13	24	917	3	propends
protends	11	30	1035	3	protends
rooked	11	49	1814	3	rooke_d_
tokens	10	47	1156	3	_token_s
weekends	16	4	273	3	weekends
woolens	10	39	884	3	woolen_s

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	146162	0.156	1145455.1
2	DLD Change Limit	146162	74	8.313	17582.3
3	Display Results	74	74	0.016	4625.0
	(SQL Overall)	178691	74	8.485	21059.6