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

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

58 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
hippy	15	51	1279	(None)
chippy	18	43	761	1	chippy
dippy	13	51	1154	1	dippy
happy	15	58	1353	1	happy
hiply	13	41	1361	1	hiply
hippo	12	36	906	1	hippo
hoppy	15	49	1235	1	hoppy
lippy	12	45	1190	1	lippy
nippy	12	49	1111	1	nippy
tippy	12	54	1179	1	tippy
whippy	19	38	584	1	whippy
zippy	21	51	874	1	zippy
buppy	14	48	1007	2	buppy
chirpy	16	49	891	2	chirpy
choppy	18	37	629	2	choppy
cuppy	14	47	1038	2	cuppy
drippy	14	44	565	2	drippy
flippy	16	5	461	2	flippy
gappy	13	62	1203	2	gappy
gimpy	13	52	1223	2	gimpy
gipsy	11	57	954	2	gipsy
grippy	14	44	776	2	grippy
guppy	13	52	1127	2	guppy
haply	13	59	1506	2	haply
harpy	13	64	1821	2	harpy
heapy	13	59	1498	2	heapy
hempy	15	49	1276	2	hempy
hilly	11	44	2216	2	hilly
hinky	15	56	1875	2	hinky
hinny	11	56	1667	2	hinny
hip	8	67	5044	2	hi_p_
hipped	14	43	1769	2	hipped
hipper	13	38	1802	2	hipper
hippie	13	28	1124	2	hippie
hippos	13	40	843	2	hippos
hips	9	64	3371	2	hi_ps
hissy	11	61	1212	2	hissy
humpy	15	51	1567	2	humpy
jimpy	19	52	1082	2	jimpy
loppy	12	59	1166	2	loppy
nappy	12	63	1233	2	nappy
pappy	11	47	1380	2	pappy
peppy	11	43	1036	2	peppy
pipy	11	54	2152	2	pi_py
poppy	11	48	1319	2	poppy
puppy	11	49	1241	2	puppy
quippy	22	38	426	2	quippy
ripply	13	34	800	2	ripply
sappy	12	54	1347	2	sappy
slippy	13	7	584	2	slippy
snippy	13	7	484	2	snippy
soppy	12	51	1352	2	soppy
tipsy	10	60	1050	2	tipsy
trippy	13	45	780	2	trippy
wimpy	15	59	1192	2	wimpy
wispy	13	72	1097	2	wispy
yuppy	15	48	791	2	yuppy
zappy	21	54	894	2	zappy

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	53800	0.623	286823.4
2	DLD Change Limit	53800	58	1.936	27789.3
3	Display Results	58	58	0.016	3625.0
	(SQL Overall)	178691	58	2.575	69394.6