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

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

47 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
spiffed	16	25	710	(None)
sniffed	14	31	818	1	sniffed
spiffied	17	23	482	1	spiffied
stiffed	14	35	958	1	stiffed
biffed	15	44	988	2	_biffed
coiffed	16	3	541	2	coiffed
miffed	15	39	871	2	_miffed
piaffed	16	9	375	2	_piaffed
piffled	16	36	640	2	_piffled
puffed	15	35	1060	2	_puffed
riffed	13	38	1156	2	_riffed
scoffed	16	26	618	2	scoffed
scuffed	16	29	824	2	scuffed
seriffed	15	9	497	2	seriffed
shifted	14	35	997	2	shifted
sifted	10	43	1367	2	s_ifted
skiffled	19	24	442	2	skiffled
sluffed	14	30	830	2	sluffed
sniffer	13	31	890	2	sniffer
sniffled	15	27	643	2	sniffled
snuffed	14	30	806	2	snuffed
spiced	11	52	1831	2	spi_ced
spied	8	54	2771	2	spi__ed
spieled	10	48	1188	2	spieled
spiered	10	44	1246	2	spiered
spiff	13	36	1640	2	spiff__
spiffier	16	25	588	2	spiffier
spiffies	16	27	798	2	spiffies
spiffs	14	32	847	2	spiff_s
spiffy	17	32	622	2	spiff_y
spiked	13	49	1555	2	spi_ked
spiled	9	46	2199	2	spi_led
spilled	10	36	1362	2	spilled
spined	9	54	2394	2	spi_ned
spired	9	49	2186	2	spi_red
spirted	10	39	1307	2	spirted
spited	9	48	2044	2	spi_ted
spitted	10	39	1270	2	spitted
spoofed	13	39	910	2	spoofed
squiffed	24	3	372	2	squiffed
staffed	14	29	828	2	staffed
stiffen	13	28	602	2	stiffen
stiffer	13	31	939	2	stiffer
stifled	11	35	1109	2	stifled
stuffed	14	32	897	2	stuffed
tiffed	13	36	839	2	_tiffed
whiffed	20	6	447	2	whiffed

Search took 5 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.140	1276364.3
2	DLD Change Limit	107671	47	3.830	28112.5
3	Display Results	47	47	0.013	3615.4
	(SQL Overall)	178691	47	3.983	44863.4