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

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

80 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
crushes	12	42	1513	(None)
brushes	12	40	1466	1	brushes
crashes	12	46	1840	1	crashes
cruses	8	81	2771	1	crus_es
crushed	13	41	1196	1	crushed
crusher	12	44	1232	1	crusher
crushers	13	40	1009	1	crushers
rushes	9	47	2436	1	_rushes
blushes	12	43	1482	2	blushes
brashes	12	45	1846	2	brashes
brushed	13	38	1121	2	brushed
brusher	12	38	1300	2	brusher
brushers	13	42	1057	2	brushers
bushes	11	52	2611	2	_bushes
cashes	11	47	2988	2	c_ashes
causes	8	80	2647	2	caus_es
ceruses	9	37	1623	2	cerus_es
choushes	16	3	762	2	choushes
clashes	12	40	1728	2	clashes
coshes	11	50	2278	2	c_oshes
couches	14	40	2047	2	couches
crases	8	55	3231	2	cras_es
crashed	13	42	1420	2	crashed
crasher	12	46	1616	2	crasher
crashers	13	40	1323	2	crashers
creches	14	3	1309	2	creches
creeshes	13	3	695	2	creeshes
cresses	9	42	1981	2	cresses
crises	8	45	2943	2	cris_es
crosses	9	42	2079	2	crosses
crouches	15	37	1129	2	crouches
cruces	10	51	1754	2	cru_ces
crudes	9	62	1862	2	cru_des
cruises	9	35	1444	2	cruises
crunches	15	37	1135	2	crunches
crusades	11	4	633	2	crusades
cruse	7	57	2610	2	crus_e_
cruset	8	44	2509	2	crus_et
crusets	9	38	1104	2	crusets
crush	10	68	1599	2	crush__
crusted	10	37	1275	2	crusted
crusts	8	49	1654	2	crus_ts
crutches	15	35	959	2	crutches
cruxes	15	49	1156	2	cru_xes
cuishes	12	28	1082	2	cuishes
curches	14	35	1274	2	curches
curses	8	53	2827	2	curs_es
cusses	8	45	2277	2	c_usses
druses	7	55	1725	2	drus_es
flushes	13	41	1414	2	flushes
freshes	13	35	1582	2	freshes
gurshes	11	22	1003	2	gurshes
gushes	10	47	1903	2	_gushes
hushes	12	47	1859	2	_hushes
inrushes	11	3	627	2	inrushes
lushes	9	40	2274	2	_lushes
mushes	11	41	2456	2	_mushes
onrushes	11	3	521	2	onrushes
plushes	12	43	1367	2	plushes
pushes	11	46	2166	2	_pushes
qurshes	19	22	857	2	qurshes
qurushes	20	3	494	2	qurushes
rashes	9	53	3015	2	_rashes
reshes	9	41	2436	2	_reshes
ruches	11	48	1958	2	_ruches
ruses	5	61	3658	2	_rus_es
rushed	10	44	1986	2	_rushed
rushee	9	38	1877	2	_rushee
rushees	10	33	1195	2	_rushees
rusher	9	40	1965	2	_rusher
rushers	10	38	1610	2	_rushers
shushes	13	35	1030	2	shushes
slushes	10	35	1441	2	slushes
smushes	12	37	1009	2	smushes
thrushes	14	3	652	2	thrushes
trashes	10	41	1926	2	trashes
trusses	7	38	1364	2	trusses
tushes	9	43	1947	2	_tushes
uprushes	13	19	486	2	uprushes
uruses	6	36	1650	2	urus_es

Search took 4 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	107671	0.373	479064.3
2	DLD Change Limit	107671	80	3.393	31733.3
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	3.796	47073.5