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

Here are the results of your fuzzy-string dictionary search for “whiffs” 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
whiffs	18	3	508	(None)
whiff	17	3	1006	1	whiff_
biffs	13	48	1441	2	_biffs
chaffs	17	45	961	2	chaffs
chiefs	14	50	965	2	chiefs
chuffs	17	42	778	2	chuffs
cliffs	14	47	759	2	cliffs
diffs	12	63	1548	2	_diffs
gliffs	13	43	632	2	gliffs
griffs	13	39	899	2	griffs
huffs	14	45	1474	2	_huffs
jiffs	18	57	1031	2	_jiffs
miffs	13	45	1288	2	_miffs
quiffs	21	13	543	2	quiffs
riffs	11	51	1461	2	_riffs
shifts	12	44	1294	2	shifts
skiffs	16	32	701	2	skiffs
sniffs	12	37	884	2	sniffs
spiffs	14	32	847	2	spiffs
stiffs	12	38	996	2	stiffs
tiffs	11	44	1488	2	_tiffs
waffs	14	63	1547	2	w_affs
waifs	11	57	1987	2	wai_fs
wharfs	15	4	637	2	wharfs
whids	12	54	1398	2	whi_ds
whiffed	20	6	447	2	whiffed
whiffer	19	10	532	2	whiffer
whiffers	20	6	449	2	whiffers
whiffet	19	6	534	2	whiffet
whiffets	20	7	252	2	whiffets
whiffle	19	3	353	2	whiffle
whiffles	20	3	426	2	whiffles
whigs	12	56	1264	2	whi_gs
whiles	12	44	1801	2	whiles
whims	13	45	1533	2	whi_ms
whines	12	51	2010	2	whines
whins	11	49	2233	2	whi_ns
whips	13	49	1708	2	whi_ps
whirls	12	47	1053	2	whirls
whirrs	12	40	859	2	whirrs
whirs	11	52	1809	2	whi_rs
whisks	16	49	735	2	whisks
whists	12	46	1381	2	whists
whites	12	39	1988	2	whites
whits	11	59	2382	2	whi_ts
whoofs	15	45	724	2	whoofs
wifes	11	45	2256	2	w_ifes

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.360	496363.9
2	DLD Change Limit	82551	47	2.436	33887.9
3	Display Results	47	47	0.016	2937.5
	(SQL Overall)	178691	47	2.812	63545.9