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

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

103 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
plowed	12	42	1320	(None)
blowed	12	50	1669	1	blowed
flowed	13	35	1376	1	flowed
glowed	11	49	1383	1	glowed
lowed	9	52	3390	1	_lowed
plower	11	43	1506	1	plower
ployed	12	43	1056	1	ployed
slowed	10	46	1707	1	slowed
allowed	11	16	1008	2	allowed
avowed	13	3	596	2	avowed
blawed	12	47	1389	2	blawed
blower	11	53	1657	2	blower
blowsed	13	44	902	2	blowsed
blowzed	22	43	597	2	blowzed
bowed	11	45	3342	2	_bowed
browed	12	52	1640	2	browed
chowed	15	49	1465	2	chowed
clawed	12	51	1507	2	clawed
clewed	12	251	1320	2	clewed
cloned	9	45	1880	2	cloned
closed	9	53	1797	2	closed
clowned	13	44	773	2	clowned
cloyed	12	51	1156	2	cloyed
cowed	11	56	3785	2	_cowed
crowed	12	47	1731	2	crowed
dowed	10	46	3261	2	_dowed
elbowed	13	23	548	2	elbowed
eloped	9	59	1415	2	eloped
flawed	13	47	1272	2	flawed
flower	12	48	1550	2	flower
globed	10	48	1176	2	globed
gloved	11	48	1187	2	gloved
glower	10	51	1493	2	glower
glozed	17	37	1122	2	glozed
jowed	16	47	2442	2	_jowed
lawed	9	60	2832	2	_lawed
lobed	8	60	2213	2	_lobed
looed	6	46	2613	2	_looed
loped	8	51	2833	2	_loped
loved	9	50	2136	2	_loved
lowe	7	54	3531	2	_lowe_
lower	8	58	3041	2	_lower
lowes	8	57	3246	2	_lowes
loxed	13	50	1705	2	_loxed
meowed	12	14	800	2	meowed
mowed	11	36	2901	2	_mowed
owed	8	68	3387	2	__owed
pawed	11	57	2561	2	p_awed
phoned	12	40	1455	2	phoned
pillowed	14	15	638	2	pillowed
piloted	10	3	1032	2	piloted
placed	11	43	1800	2	placed
planed	9	44	2091	2	planed
plated	9	52	2577	2	plated
played	12	48	1503	2	played
pled	7	52	3143	2	pl__ed
plied	8	51	1859	2	pl_ied
plod	7	67	2327	2	plo__d
plodded	12	6	556	2	plodded
plonked	14	34	810	2	plonked
plopped	11	28	877	2	plopped
plotted	10	46	1237	2	plotted
plotzed	19	37	622	2	plotzed
plover	11	53	1261	2	plover
plow	9	59	2323	2	plow__
plowers	12	38	1224	2	plowers
plowhead	17	4	280	2	plowhead
plowmen	14	3	488	2	plowmen
plows	10	54	1990	2	plow_s
plumed	11	44	1288	2	plumed
poked	12	54	2539	2	p_oked
poled	8	49	3484	2	p_oled
polled	9	40	2200	2	polled
pooed	8	52	2624	2	p_ooed
poohed	12	39	1252	2	poohed
pooled	9	46	1981	2	pooled
pooped	11	39	1594	2	pooped
pored	8	52	3451	2	p_ored
posed	8	58	2841	2	p_osed
power	10	53	2595	2	p_ower
poxed	15	48	1786	2	p_oxed
probed	11	41	1482	2	probed
prosed	9	49	2110	2	prosed
proved	12	50	1603	2	proved
prower	11	42	1812	2	prower
prowled	13	30	991	2	prowled
replowed	14	12	758	2	replowed
rowed	9	40	3432	2	_rowed
scowed	12	44	1383	2	scowed
showed	13	50	1697	2	showed
slewed	10	48	1552	2	slewed
sloped	9	42	1685	2	sloped
slower	9	40	1615	2	slower
snowed	10	46	1362	2	snowed
sowed	9	49	3386	2	_sowed
stowed	10	58	1720	2	stowed
towed	9	51	3458	2	_towed
trowed	10	47	1465	2	trowed
unplowed	14	3	635	2	unplowed
upflowed	17	4	289	2	upflowed
vowed	12	44	2457	2	_vowed
wowed	12	40	2377	2	_wowed
yowed	12	530	2518	2	_yowed

Search took 3 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.343	520965.0
2	DLD Change Limit	82551	103	2.360	34979.2
3	Display Results	103	103	0.033	3121.2
	(SQL Overall)	178691	103	2.736	65311.0