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

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

64 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
crusher	12	44	1232	(None)
brusher	12	38	1300	1	brusher
crasher	12	46	1616	1	crasher
crushed	13	41	1196	1	crushed
crushers	13	40	1009	1	crushers
crushes	12	42	1513	1	crushes
rusher	9	40	1965	1	_rusher
blusher	12	41	1311	2	blusher
brasher	12	45	1524	2	brasher
brushed	13	38	1121	2	brushed
brushers	13	42	1057	2	brushers
brushes	12	40	1466	2	brushes
brushier	13	30	697	2	brushier
brusker	13	43	785	2	brusker
busher	11	49	2220	2	_busher
causer	8	41	1778	2	caus_er
clasher	12	46	1551	2	clasher
cluster	9	40	1333	2	cluster
cosher	11	48	1990	2	c_osher
coucher	14	45	1585	2	coucher
cougher	13	37	1173	2	cougher
couther	12	39	1463	2	couther
crashed	13	42	1420	2	crashed
crashers	13	40	1323	2	crashers
crashes	12	46	1840	2	crashes
crasser	9	41	1434	2	crasser
crisper	11	35	1105	2	crisper
crosier	9	41	1657	2	crosier
crosser	9	50	1546	2	crosser
cruder	9	56	1238	2	cru_der
crueler	9	3	902	2	crueler
cruiser	9	34	1043	2	cruiser
cruller	9	6	875	2	cruller
crumber	13	33	964	2	crumber
cruncher	15	33	807	2	cruncher
crupper	13	33	856	2	crupper
crusader	11	4	427	2	crusader
cruse	7	57	2610	2	crus_e_
cruses	8	81	2771	2	crus_es
cruset	8	44	2509	2	crus_et
crush	10	68	1599	2	crush__
crusted	10	37	1275	2	crusted
crustier	10	25	953	2	crustier
curser	8	47	2147	2	curs_er
cushier	12	36	1083	2	c_ushier
cusser	8	60	1609	2	c_usser
flusher	13	30	1227	2	flusher
fresher	13	26	1264	2	fresher
gusher	10	41	1577	2	_gusher
lusher	9	38	1876	2	_lusher
musher	11	38	2057	2	_musher
plusher	12	40	1038	2	plusher
pusher	11	43	1828	2	_pusher
rasher	9	50	2412	2	_rasher
rushed	10	44	1986	2	_rushed
rushee	9	38	1877	2	_rushee
rushers	10	38	1610	2	_rushers
rushes	9	47	2436	2	_rushes
rushier	10	34	1197	2	_rushier
shusher	13	28	811	2	shusher
trasher	10	44	1613	2	trasher
trusser	7	40	1026	2	trusser
truster	7	31	1431	2	truster
usher	8	45	1776	2	__usher

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.376	475242.0
2	DLD Change Limit	107671	64	3.203	33615.7
3	Display Results	64	64	0.013	4923.1
	(SQL Overall)	178691	64	3.592	49746.9