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

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

89 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
raphe	10	49	1642	(None)
rape	6	50	4163	1	rap_e
raphae	11	43	1173	1	raphae
raphes	11	51	1745	1	raphes
rathe	8	58	2192	1	rathe
rhaphe	14	3	342	1	rhaphe
ache	9	68	2982	2	_ache
ape	5	72	5118	2	_ap_e
apse	6	77	2538	2	_apse
bathe	10	58	2288	2	bathe
cache	12	51	2248	2	cache
cape	8	72	4278	2	cap_e
caph	11	66	2329	2	caph_
caphs	12	45	1537	2	caphs
crape	9	61	2844	2	crap_e
daphne	12	23	701	2	daphne
drape	8	53	1963	2	drap_e
frappe	13	28	695	2	frappe
gape	7	51	3451	2	gap_e
grape	8	48	2466	2	grap_e
graph	11	53	1561	2	graph_
graphed	14	9	847	2	graphed
graphs	12	45	1015	2	graphs
jape	13	49	2342	2	jap_e
kaph	13	58	1575	2	kaph_
kaphs	14	49	1150	2	kaphs
lapse	7	49	1768	2	lapse
lathe	8	56	2672	2	lathe
mache	12	59	2530	2	mache
maple	9	55	2114	2	maple
nape	6	52	3080	2	nap_e
nappe	9	61	1499	2	nappe
orache	11	40	1359	2	orache
ouphe	10	44	1326	2	ouphe
race	6	67	4626	2	ra_ce
rachet	11	50	2897	2	rachet
rage	5	57	4235	2	ra_ge
ragee	6	54	3266	2	ragee
rah	6	80	5240	2	ra_h_
raise	5	48	2805	2	raise
rake	8	48	4157	2	ra_ke
rakee	9	60	3117	2	rakee
rale	4	50	5056	2	ra_le
ralph	10	7	874	2	ralph_
ralphed	13	3	436	2	ralphed
ralphs	11	3	537	2	ralphs
ramee	7	46	3385	2	ramee
ramie	7	50	2782	2	ramie
rance	7	50	2851	2	rance
ranee	5	54	3810	2	ranee
range	6	47	2841	2	range
rap	5	62	6196	2	rap__
raped	8	53	3462	2	raped
raper	7	49	3275	2	raper
rapes	7	57	4072	2	rapes
raphia	11	35	1126	2	raphia
raphide	13	13	807	2	raphide
raphis	11	40	1432	2	raphis
rapid	8	64	2203	2	rapid
rapier	8	40	1999	2	rapier
rapine	8	50	2308	2	rapine
rapped	11	41	2268	2	rapped
rappee	10	36	1867	2	rappee
rappel	10	42	1195	2	rappel
rappen	10	35	1271	2	rappen
rapper	10	46	2157	2	rapper
raps	6	62	4773	2	rap_s
rapt	6	72	4531	2	rap_t
rare	4	53	4843	2	ra_re
rase	4	61	4998	2	ra_se
rash	7	60	3993	2	rash_
rasher	9	50	2412	2	rasher
rashes	9	53	3015	2	rashes
rate	4	54	5876	2	ra_te
rath	7	60	3766	2	rath_
rather	9	43	1974	2	rather
rave	7	55	4209	2	ra_ve
raze	13	52	3543	2	ra_ze
razee	14	58	2780	2	razee
rhaphae	15	4	319	2	rhaphae
rhaphes	15	3	470	2	rhaphes
ripe	6	60	3892	2	rip_e
rope	6	55	4291	2	rop_e
ruche	10	42	1676	2	ruche
rupee	7	3	2128	2	rupee
sadhe	9	48	1513	2	sadhe
tache	10	62	2237	2	tache
tape	6	45	3814	2	tap_e
tophe	10	67	1897	2	tophe

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.313	570897.8
2	DLD Change Limit	53800	89	1.720	31279.1
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	2.063	86617.1