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

Here are the results of your fuzzy-string dictionary search for “aruspex” with Change Limit: [1] [2] [3] [4]

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
aruspex	16	4	254	(None)
auspex	15	7	479	1	a_uspex
haruspex	20	4	168	1	haruspex
abuse	7	71	1956	3	abus_e_
abused	9	56	1427	3	abus_ed
abuser	8	54	1368	3	abus_er
abuses	8	51	1910	3	abus_es
amuse	7	59	2083	3	amus_e_
amused	9	44	1251	3	amus_ed
amuser	8	47	1262	3	amus_er
amuses	8	51	1794	3	amus_es
anuses	6	62	1877	3	anus_es
apex	13	72	2021	3	a___pex
arcuses	9	48	1469	3	arcus_es
arguses	8	47	1174	3	argus_es
arise	5	64	3643	3	aris_e_
arisen	6	53	1679	3	aris_en
arises	6	52	3380	3	aris_es
arose	5	58	3208	3	aros_e_
arouse	6	50	1998	3	arous_e_
aroused	8	49	1434	3	arous_ed
arouser	7	45	1442	3	arous_er
arouses	7	49	2129	3	arous_es
arpen	7	44	1804	3	ar__pen
arse	4	65	3927	3	ar_s_e_
arses	5	57	3387	3	ar_s_es
artsier	7	6	894	3	artsier
aruspices	13	4	335	3	aruspices
aspen	7	52	1609	3	a__spen
asper	7	55	2043	3	a__sper
brushed	13	38	1121	3	brushed
brusher	12	38	1300	3	brusher
brushes	12	40	1466	3	brushes
brusker	13	43	785	3	brusker
crisped	12	40	1010	3	crisped
crispen	11	34	820	3	crispen
crisper	11	35	1105	3	crisper
crumped	14	43	1122	3	crumped
crumpet	13	37	1106	3	crumpet
crupper	13	33	856	3	crupper
cruse	7	57	2610	3	crus_e_
cruses	8	81	2771	3	crus_es
cruset	8	44	2509	3	crus_et
crushed	13	41	1196	3	crushed
crusher	12	44	1232	3	crusher
crushes	12	42	1513	3	crushes
crusted	10	37	1275	3	crusted
cusped	11	43	1204	3	_cusped
drupe	8	50	1299	3	dru_pe_
drupes	9	49	1265	3	dru_pes
druse	6	48	1766	3	drus_e_
druses	7	55	1725	3	drus_es
grasped	11	40	906	3	grasped
grasper	10	38	979	3	grasper
grumped	13	33	733	3	grumped
perspex	18	3	418	3	perspex
prosper	11	40	1219	3	prosper
rasped	9	47	1520	3	_rasped
rasper	8	39	1733	3	_rasper
rupee	7	3	2128	3	_ru_pee
ruse	4	59	3893	3	_rus_e_
ruses	5	61	3658	3	_rus_es
rushed	10	44	1986	3	_rushed
rushee	9	38	1877	3	_rushee
rusher	9	40	1965	3	_rusher
rushes	9	47	2436	3	_rushes
russet	6	3	1943	3	_russet
rusted	7	50	2092	3	_rusted
trumped	12	43	971	3	trumped
trumpet	11	38	1072	3	trumpet
trussed	8	40	1003	3	trussed
trusser	7	40	1026	3	trusser
trusses	7	38	1364	3	trusses
trusted	8	34	1279	3	trusted
trustee	7	35	1444	3	trustee
truster	7	31	1431	3	truster
uruses	6	36	1650	3	urus_es
varuses	10	3	1062	3	varus_es

Search took 8 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	134027	0.406	440125.6
2	DLD Change Limit	134027	78	6.983	19193.3
3	Display Results	78	78	0.016	4875.0
	(SQL Overall)	178691	78	7.405	24131.1