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

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

62 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
tipsy	10	60	1050	(None)
gipsy	11	57	954	1	gipsy
tippy	12	54	1179	1	tippy
tips	6	64	3676	1	tips_
biopsy	13	3	453	2	biopsy
bitsy	10	45	1130	2	bitsy
cissy	10	48	1107	2	cissy
dippy	13	51	1154	2	dippy
dips	7	55	3691	2	dips_
dipso	8	51	1155	2	dipso
ditsy	9	56	1256	2	ditsy
gips	7	56	3292	2	gips_
gypsy	14	63	699	2	gypsy
hiply	13	41	1361	2	hiply
hippy	15	51	1279	2	hippy
hips	9	64	3370	2	hips_
hissy	11	61	1212	2	hissy
kips	10	64	3051	2	kips_
kissy	12	55	1031	2	kissy
limpsy	13	51	684	2	limpsy
lippy	12	45	1190	2	lippy
lips	6	71	4144	2	lips_
mips	8	55	3407	2	mips_
missy	10	56	1756	2	missy
nippy	12	49	1111	2	nippy
nips	6	58	3092	2	nips_
pips	8	58	3713	2	pips_
pipy	11	54	2151	2	pip_y
popsy	12	57	1340	2	popsy
rips	6	62	3743	2	rips_
sips	6	57	4010	2	sips_
sissy	8	58	1207	2	sissy
tansy	8	45	1493	2	tansy
taps	6	60	5067	2	taps_
tepoy	10	3	1216	2	tepoy
tics	6	57	2963	2	tics_
tidy	8	68	2241	2	ti_dy
ties	4	52	4831	2	ties_
tils	4	57	3961	2	tils_
tinny	8	53	1765	2	tinny
tins	4	52	5130	2	tins_
tiny	7	61	3463	2	ti_ny
tip	5	65	5122	2	tip__
tipi	6	99	2443	2	tip_i
tipis	7	60	1992	2	tipis
tipsily	12	3	604	2	tipsily
tis	3	70	5664	2	ti_s_
tits	4	61	4503	2	tits_
titty	8	53	1665	2	titty
tivy	10	145	1686	2	ti_vy
tizzy	16	54	889	2	tizzy
tops	6	62	4812	2	tops_
triply	11	42	1102	2	triply
trippy	13	45	780	2	trippy
trips	7	49	2336	2	trips_
tups	6	56	2876	2	tups_
typey	13	55	1188	2	typey
typy	12	60	1304	2	typ_y
wispy	13	72	1097	2	wispy
yips	9	52	2669	2	yips_
zippy	21	51	874	2	zippy
zips	15	57	2379	2	zips_

Search took 2 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	53800	0.096	1861364.6
2	DLD Change Limit	53800	62	1.780	30224.7
3	Display Results	62	62	0.016	3875.0
	(SQL Overall)	178691	62	1.892	94445.6