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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

102 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
fowler	12	37	1258	(None)
bowler	11	42	1731	1	bowler
fouler	9	36	1490	1	fouler
fowled	13	39	1409	1	fowled
fowlers	13	34	1120	1	fowlers
howler	12	35	1431	1	howler
yowler	12	33	1004	1	yowler
bawler	11	43	1505	2	bawler
boiler	8	43	1927	2	boiler
bower	10	73	2818	2	bow_er
bowlder	13	40	747	2	bowlder
bowled	12	50	1813	2	bowled
bowleg	12	36	917	2	bowleg
bowlers	12	37	1578	2	bowlers
bowyer	14	36	892	2	bowyer
coaler	8	41	2170	2	coaler
coiler	8	44	2159	2	coiler
cooler	8	48	2471	2	cooler
cower	10	45	3177	2	cow_er
cowier	11	36	1616	2	cowier
cowled	12	52	1838	2	cowled
dower	9	50	2770	2	dow_er
downer	10	44	1492	2	downer
dowser	10	47	1608	2	dowser
fabler	11	61	1581	2	fabler
faller	9	46	2123	2	faller
fawner	12	59	1046	2	fawner
feeler	9	32	1517	2	feeler
feller	9	44	1955	2	feller
fewer	11	52	1612	2	few_er
filer	8	54	3300	2	f_iler
filler	9	46	2362	2	filler
flower	12	48	1550	2	flow_er
foaled	10	45	1596	2	foaled
foamer	11	47	1431	2	foamer
fodder	11	47	1211	2	fodder
fogger	11	44	1477	2	fogger
foiled	10	46	1840	2	foiled
folder	10	43	1754	2	folder
foley	11	52	2230	2	fo_ley
folles	9	38	2047	2	folles
fonder	10	41	2006	2	fonder
fondler	11	34	888	2	fondler
fooled	10	43	1782	2	fooled
foolery	13	3	669	2	foolery
footer	9	43	2076	2	footer
footler	10	40	1186	2	footler
foozler	19	39	759	2	foozler
forcer	11	49	1734	2	forcer
forger	10	48	2076	2	forger
forker	13	47	1790	2	forker
former	11	42	2140	2	former
foster	9	43	2222	2	foster
fouled	10	43	1597	2	fouled
fowl	10	57	2363	2	fowl__
fowls	11	55	1889	2	fowl_s
foxier	16	39	1003	2	foxier
foyer	11	64	1655	2	fo_yer
fozier	18	37	1066	2	fozier
frowner	13	42	968	2	frowner
fueler	9	43	1393	2	fueler
fuller	9	42	2038	2	fuller
furler	9	36	1640	2	furler
growler	11	31	897	2	growler
holler	9	35	2061	2	holler
howled	13	40	1496	2	howled
howlers	13	33	1235	2	howlers
howlet	12	35	1834	2	howlet
jowled	17	42	1079	2	jowled
jowlier	17	32	756	2	jowlier
loller	6	33	1528	2	loller
lower	8	58	3041	2	low_er
lowlier	10	33	890	2	lowlier
mewler	11	35	1023	2	mewler
moiler	8	40	1726	2	moiler
mower	10	45	2345	2	mow_er
nobler	8	37	1345	2	nobler
ogler	6	59	1744	2	_ogler
oiler	5	46	2828	2	_oiler
owlet	8	33	2446	2	_owlet
owner	8	46	1331	2	_owner
poler	7	44	3179	2	po_ler
poller	8	39	2185	2	poller
pooler	8	38	1984	2	pooler
powder	12	36	1190	2	powder
power	10	53	2595	2	pow_er
powter	11	41	1603	2	powter
prowler	12	33	1001	2	prowler
roller	6	39	1979	2	roller
rower	8	54	3049	2	row_er
scowler	12	24	817	2	scowler
sower	8	52	2931	2	sow_er
toiler	6	39	1828	2	toiler
toller	6	38	1944	2	toller
tooler	6	38	1861	2	tooler
tower	8	57	2920	2	tow_er
vower	11	52	2079	2	vow_er
wooler	9	36	1587	2	wooler
wowser	12	51	1020	2	wowser
yodler	10	38	994	2	yodler
yowled	13	38	1108	2	yowled
yowlers	13	32	892	2	yowlers

Search took 8 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	82551	0.440	406115.9
2	DLD Change Limit	82551	102	6.420	12858.4
3	Display Results	102	102	0.063	1619.0
	(SQL Overall)	178691	102	6.923	25811.2