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

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

95 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
boomkin	15	4	536	(None)
boomkins	16	4	550	1	boomkins
bodkin	13	3	892	2	b_odkin
bookie	12	35	1600	2	boo_kie
booking	14	36	1838	2	boo_king
bookman	15	13	648	2	bookman
bookmen	15	12	626	2	bookmen
booming	12	37	1622	2	boom_ing
bromin	10	26	1569	2	brom_in
bumkin	14	30	808	2	b_umkin
biotin	8	32	1583	3	bio_tin
blocking	17	45	1057	3	blocking
bloodfin	14	4	339	3	bloodfin
blooming	13	29	943	3	bloom_ing
bobbin	9	34	1073	3	b_obbin
bodkins	14	3	831	3	b_odkins
boffin	14	35	905	3	b_offin
boinking	15	37	842	3	boinking
bombing	14	32	1139	3	b_ombing
bonking	14	41	1637	3	b_onking
boobie	10	40	1529	3	boo_bie
boobing	12	36	1391	3	boo_bing
boodling	12	19	1024	3	boodling
boogie	9	35	1599	3	boo_gie
boogying	15	3	537	3	boogying
booing	9	45	2164	3	boo__ing
book	10	68	3633	3	boo_k__
booked	13	53	1950	3	boo_ked
bookend	14	39	664	3	boo_kend
booker	12	47	1919	3	boo_ker
bookies	13	38	1940	3	boo_kies
bookings	15	35	873	3	boo_kings
bookish	16	36	1002	3	boo_kish
bookmaking	18	4	313	3	bookmaking
bookoo	12	4	834	3	boo_koo
books	11	57	2971	3	boo_k_s
boom	8	74	3567	3	boom___
boombox	20	7	361	3	boombox
boomed	11	53	1813	3	boom_ed
boomer	10	46	1851	3	boom_er
boomers	11	41	1591	3	boomers
boomier	11	33	1218	3	boomier
boomlet	11	24	1227	3	boomlet
booms	9	54	2712	3	boom__s
boomtown	15	4	212	3	boomtown
boomy	12	54	2182	3	boom__y
boon	6	71	4217	3	boo___n
boosting	11	33	1105	3	boosting
bootie	8	54	2116	3	boo_tie
booting	10	38	2136	3	boo_ting
boozing	19	40	1216	3	boo_zing
borking	14	47	1617	3	b_orking
bosoming	13	3	664	3	bosom_ing
botulin	9	4	765	3	botulin
boudin	9	4	1237	3	b_oudin
boursin	9	3	828	3	boursin
bowfin	14	33	835	3	b_owfin
bowman	13	12	985	3	bowm_an
bowmen	13	9	985	3	bowm_en
broken	12	40	1152	3	bro_ken
broking	14	35	1482	3	bro_king
bromelin	12	4	634	3	bromelin
bromic	12	24	1269	3	brom_ic
bromid	11	26	1289	3	brom_id
bromine	11	29	1524	3	brom_ine
bromins	11	25	1378	3	brom_ins
brookie	13	4	737	3	brookie
brooking	15	37	1070	3	brooking
brooming	13	29	1114	3	broom_ing
bumkins	15	31	801	3	b_umkins
bumpkin	17	4	361	3	bumpkin
buskin	12	38	1149	3	b_uskin
cookie	12	37	1604	3	coo_kie
cooking	14	38	1897	3	coo_king
coonskin	14	4	439	3	coonskin
cowskin	16	4	555	3	cowskin
doeskin	12	4	515	3	doeskin
domain	9	5	1132	3	_domain
dooming	11	31	1253	3	doom_ing
dormin	9	3	1231	3	dorm_in
foxskin	21	4	313	3	foxskin
hooking	15	37	1669	3	hoo_king
kookie	9	38	984	3	koo_kie
lomein	8	4	1020	3	_lomein
looking	12	34	1504	3	loo_king
looming	10	28	1485	3	loom_ing
nookie	10	37	1243	3	noo_kie
ptomain	11	4	696	3	ptomain
rookie	10	36	1326	3	roo_kie
rooking	12	35	1736	3	roo_king
roomie	8	30	1387	3	room_ie
rooming	10	41	1704	3	room_ing
woodbin	13	5	487	3	woodbin
woolskin	15	4	301	3	woolskin
zooming	19	26	965	3	zoom_ing

Search took 7 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	134027	0.483	369960.7
2	DLD Change Limit	134027	95	6.313	21230.3
3	Display Results	95	95	0.046	2065.2
	(SQL Overall)	178691	95	6.842	26116.8