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

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

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
woolers	10	42	1402	(None)
coolers	9	35	2249	1	coolers
poolers	9	42	1742	1	poolers
toolers	7	44	1650	1	toolers
wooers	9	37	1244	1	woo_ers
woofers	13	38	1058	1	woofers
woolens	10	39	884	1	woolens
wooler	9	36	1587	1	wooler_
boilers	9	34	1706	2	boilers
boodlers	11	37	1074	2	boodlers
boogers	10	45	1463	2	boogers
bookers	13	40	1661	2	bookers
boomers	11	41	1591	2	boomers
boozers	18	39	1244	2	boozers
bowlers	12	37	1578	2	bowlers
cholers	12	42	1520	2	cholers
coalers	9	44	1935	2	coalers
coilers	9	36	1990	2	coilers
cooers	8	43	2456	2	coo_ers
cookers	13	46	1946	2	cookers
cooler	8	48	2471	2	cooler_
coopers	11	40	1948	2	coopers
cooters	9	45	2572	2	cooters
doodlers	10	33	884	2	doodlers
doolees	8	37	1161	2	doolees
doozers	17	41	929	2	doozers
foolery	13	3	669	2	foolery
footers	10	46	1833	2	footers
footlers	11	39	1079	2	footlers
foozlers	20	34	607	2	foozlers
fowlers	13	34	1120	2	fowlers
gaolers	8	35	1156	2	gaolers
goobers	10	21	962	2	goobers
hollers	10	38	1823	2	hollers
hoofers	13	45	1332	2	hoofers
hookers	14	49	1651	2	hookers
hoopers	12	36	1648	2	hoopers
hooters	10	45	2047	2	hooters
hoovers	13	43	1270	2	hoovers
howlers	13	33	1235	2	howlers
lollers	7	27	1379	2	lollers
lookers	11	40	1407	2	lookers
loopers	9	39	1403	2	loopers
looters	7	44	1916	2	looters
moilers	9	36	1520	2	moilers
mooleys	12	3	686	2	mooleys
mooners	9	40	1534	2	mooners
mooters	9	38	1862	2	mooters
noosers	7	49	1392	2	noosers
oglers	7	43	1318	2	_oglers
oilers	6	47	2119	2	_oilers
polers	8	42	2564	2	_polers
pollers	9	34	2002	2	pollers
pooler	8	38	1984	2	pooler_
rollers	7	31	1747	2	rollers
roofers	10	50	1390	2	roofers
roomers	9	54	1641	2	roomers
roosers	7	42	1787	2	roosers
rooters	7	45	2293	2	rooters
sooners	7	39	1664	2	sooners
spoolers	10	34	936	2	spoolers
swooners	11	33	686	2	swooners
swoopers	13	31	752	2	swoopers
toilers	7	41	1626	2	toilers
tollers	7	32	1746	2	tollers
tooler	6	38	1861	2	tooler_
tooters	7	38	1877	2	tooters
tootlers	8	28	950	2	tootlers
wailers	10	39	1680	2	wailers
walers	9	48	2446	2	w_alers
whalers	13	52	970	2	whalers
wholes	12	46	1677	2	whole_s
whoopers	16	28	626	2	whoopers
willers	10	35	1791	2	willers
wobblers	15	32	788	2	wobblers
wolfers	13	40	963	2	wolfers
wolvers	13	34	931	2	wolvers
wonders	11	33	1599	2	wonders
wonners	10	43	1281	2	wonners
woodless	12	27	845	2	woodless
wooer	8	43	1669	2	woo_er_
woofer	12	44	1136	2	woofer_
wooled	10	37	1550	2	woole_d
woolen	9	31	1137	2	woole_n
woolier	10	36	1235	2	woolier_
woolies	10	41	1736	2	woolies
woollens	11	4	409	2	woollens
wools	8	44	2146	2	wool__s
woomera	12	13	577	2	woomera
woomeras	13	13	511	2	woomeras
workers	14	46	1269	2	workers
wormers	12	40	1257	2	wormers
wowsers	13	48	876	2	wowsers
yodlers	11	29	892	2	yodlers
yowlers	13	32	892	2	yowlers

Search took 4 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.376	475242.0
2	DLD Change Limit	107671	95	3.310	32529.0
3	Display Results	95	95	0.050	1900.0
	(SQL Overall)	178691	95	3.736	47829.5