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

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

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
doozers	17	41	929	(None)
boozers	18	39	1244	1	boozers
doozer	16	39	1046	1	doozer_
dozers	16	48	1542	1	d_ozers
boogers	10	45	1463	2	boogers
bookers	13	40	1661	2	bookers
boomers	11	41	1591	2	boomers
boozer	17	48	1596	2	boozer_
boozes	17	49	1652	2	booze_s
cooers	8	43	2456	2	coo_ers
cookers	13	46	1946	2	cookers
coolers	9	35	2249	2	coolers
coopers	11	40	1948	2	coopers
cooters	9	45	2572	2	cooters
crozers	18	41	1108	2	crozers
dobbers	12	35	1325	2	dobbers
dockers	14	37	1500	2	dockers
dodders	10	55	1179	2	dodders
dodgers	10	52	1382	2	dodgers
doers	6	52	2571	2	d_o_ers
doffers	14	35	985	2	doffers
doggers	10	44	1343	2	doggers
donzels	17	3	539	2	donzels
doodlers	10	33	884	2	doodlers
doolees	8	37	1161	2	doolees
doors	6	50	2213	2	doo__rs
doozies	17	38	1272	2	doozies
dopers	9	55	2248	2	d_opers
dormers	10	43	1392	2	dormers
dorpers	10	41	1317	2	dorpers
dorsers	8	35	1630	2	dorsers
dosers	7	57	2363	2	d_osers
dossers	8	45	1623	2	dossers
doters	7	44	2391	2	d_oters
dotters	8	37	1597	2	dotters
dousers	8	48	1727	2	dousers
dowers	10	45	2329	2	d_owers
downers	11	39	1277	2	downers
dowsers	11	50	1353	2	dowsers
dozens	16	46	1246	2	d_ozens
dozer	15	84	1927	2	d_ozer_
dozes	15	52	2630	2	d_oze_s
droners	8	41	1438	2	droners
drovers	11	52	1264	2	drovers
footers	10	46	1833	2	footers
foozlers	20	34	607	2	foozlers
goobers	10	21	962	2	goobers
hoofers	13	45	1333	2	hoofers
hookers	14	49	1652	2	hookers
hoopers	12	36	1649	2	hoopers
hooters	10	45	2048	2	hooters
hoovers	13	43	1271	2	hoovers
lookers	11	40	1407	2	lookers
loopers	9	39	1403	2	loopers
looters	7	44	1916	2	looters
momzers	20	36	713	2	momzers
mooners	9	40	1534	2	mooners
mooters	9	38	1862	2	mooters
noosers	7	49	1393	2	noosers
oozes	14	54	1871	2	_ooze_s
poolers	9	42	1742	2	poolers
potzers	18	40	1054	2	potzers
roofers	10	50	1390	2	roofers
roomers	9	54	1641	2	roomers
roosers	7	42	1788	2	roosers
rooters	7	45	2293	2	rooters
rozzers	15	3	563	2	rozzers
snoozers	17	29	694	2	snoozers
sooners	7	39	1664	2	sooners
toolers	7	44	1650	2	toolers
tooters	7	38	1877	2	tooters
wooers	9	37	1244	2	woo_ers
woofers	13	38	1058	2	woofers
woolers	10	42	1402	2	woolers

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	107671	0.403	443402.0
2	DLD Change Limit	107671	74	6.033	17847.0
3	Display Results	74	74	0.063	1174.6
	(SQL Overall)	178691	74	6.499	27495.2