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

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

67 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
gipsy	11	57	954	(None)
gips	7	56	3292	1	gips_
gypsy	14	63	699	1	gypsy
tipsy	10	60	1050	1	tipsy
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
gappy	13	62	1203	2	gappy
gaps	7	60	4297	2	gaps_
gapy	10	63	2091	2	gap_y
gassy	9	55	1402	2	gassy
gawsy	12	45	909	2	gawsy
gibs	7	55	2926	2	gibs_
giddy	11	58	1020	2	giddy
gids	6	59	3373	2	gids_
gies	5	56	4142	2	gies_
gigs	6	66	3118	2	gigs_
gilly	9	43	2163	2	gilly
gimps	10	59	1520	2	gimps_
gimpy	13	52	1223	2	gimpy
ginny	9	53	1457	2	ginny
gins	5	55	4395	2	gins_
gip	6	76	4536	2	gip__
gipon	8	42	1241	2	gipon
girly	9	44	1529	2	girly
girsh	9	53	1002	2	girsh
gist	5	60	4676	2	gi_st
gits	5	57	4459	2	gits_
goosy	9	60	1888	2	goosy
gorsy	9	59	1578	2	gorsy
gripey	12	41	1120	2	gripey
grippy	14	44	776	2	grippy
grips	8	55	2013	2	grips_
gripy	11	51	1525	2	grip_y
guppy	13	52	1127	2	guppy
gussy	9	53	1432	2	gussy
gutsy	9	64	1284	2	gutsy
gyps	10	51	1502	2	gyps_
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
tippy	12	54	1179	2	tippy
tips	6	64	3676	2	tips_
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 6 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.186	960704.3
2	DLD Change Limit	53800	67	5.173	10400.2
3	Display Results	67	67	0.060	1116.7
	(SQL Overall)	178691	67	5.419	32974.9