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

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

78 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
croups	10	43	1255	(None)
coups	9	55	2247	1	c_oups
crops	9	61	2523	1	cro_ps
croup	9	56	1678	1	croup_
croupe	10	51	1443	1	croupe
croupes	11	46	1310	1	croupes
croupy	13	45	873	1	croupy
groups	9	42	1051	1	groups
roups	7	51	1890	1	_roups
cerous	8	58	2120	2	cerou_s
chomps	15	51	1222	2	chomps
chops	12	50	1987	2	cho_ps
clomps	12	52	1223	2	clomps
clops	9	59	2485	2	clo_ps
clouds	9	46	1235	2	clouds
clours	8	52	1508	2	clours
clouts	8	70	1720	2	clouts
comps	11	55	2605	2	c_omps
coops	9	62	2964	2	c_oops
cops	8	67	5137	2	c_o_ps
corps	9	59	2704	2	c_orps
corpus	10	60	1529	2	corpus
coup	8	67	2979	2	c_oup_
coupe	9	60	2348	2	c_oupe
coupes	10	50	2252	2	c_oupes
cramps	12	56	1556	2	cramps
craps	9	53	2864	2	cr_aps
creeps	10	42	1362	2	creeps
crimps	12	46	1345	2	crimps
crisps	10	44	1151	2	crisps
croaks	12	58	1298	2	croaks
crocks	14	51	1842	2	crocks
crocs	9	57	2243	2	cro_cs
crocus	10	48	1317	2	crocus
crofts	11	49	1059	2	crofts
crones	8	47	2924	2	crones
crooks	12	49	1441	2	crooks
croons	8	54	1842	2	croons
crop	8	76	2863	2	cro_p_
croquis	18	3	476	2	croquis
crores	8	61	2116	2	crores
cross	7	51	2450	2	cro_ss
crouch	13	39	1020	2	crouch
croupous	12	4	590	2	croupous
crouse	8	46	1936	2	crouse
croute	8	46	1727	2	croute
croutes	9	48	1564	2	croutes
crowds	12	49	1076	2	crowds
crowns	11	56	1511	2	crowns
crows	10	57	2731	2	cro_ws
crozes	17	44	1766	2	crozes
cruds	8	58	1585	2	cr_uds
crumps	12	45	1434	2	crumps
cruors	8	3	862	2	cruors
crus	6	58	2848	2	cr_u_s
cups	8	54	3082	2	c__ups
cutups	10	3	681	2	cutups
droops	9	51	1096	2	droops
drops	8	57	1950	2	dro_ps
drouks	11	3	712	2	drouks
group	8	54	1392	2	group_
grouts	7	50	1561	2	grouts
loups	7	53	1962	2	_loups
props	9	57	2688	2	pro_ps
romps	9	46	1754	2	_romps
roues	5	60	3935	2	_roues
roup	6	66	2769	2	_roup_
roupy	10	61	1271	2	_roupy
routs	5	71	3341	2	_routs
scroops	11	28	824	2	scroops
soups	7	53	2294	2	_soups
stoups	8	53	1327	2	stoups
tromps	10	49	1170	2	tromps
troops	8	57	1277	2	troops
troupe	8	48	1243	2	troupe
troupes	9	41	1284	2	troupes
trouts	6	61	1662	2	trouts
vrouws	12	49	474	2	vrouws

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.156	1145455.1
2	DLD Change Limit	82551	78	2.766	29844.9
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	2.952	60532.2