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

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

91 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
rearms	8	51	1465	(None)
prearms	11	36	917	1	prearms
realms	8	49	1349	1	realms
reams	7	57	2962	1	rea_ms
rearm	7	59	2357	1	rearm_
rears	5	47	3965	1	rear_s
rewarms	12	43	960	1	rewarms
alarms	8	59	1305	2	alarms
arms	6	61	3749	2	__arms
barms	9	61	2846	2	_barms
beams	9	53	2817	2	bea_ms
beards	9	41	1667	2	beards
bears	7	57	3904	2	bear_s
berms	9	53	2366	2	be_rms
breams	10	48	1504	2	brea_ms
charms	13	52	1884	2	charms
creams	10	47	1525	2	crea_ms
dears	6	57	3688	2	dear_s
derms	8	50	2289	2	de_rms
dreams	9	45	1398	2	drea_ms
drears	7	46	1425	2	drear_s
earls	5	61	2751	2	_earls
earns	5	59	2756	2	_earns
ears	4	63	5659	2	_ear_s
farms	10	63	2495	2	_farms
fears	8	48	2939	2	fear_s
firearms	13	3	540	2	firearms
forearms	13	3	660	2	forearms
gears	6	46	2869	2	gear_s
germs	8	51	1887	2	ge_rms
harms	10	68	2901	2	_harms
hears	8	67	3737	2	hear_s
hearts	9	62	1894	2	hearts
herms	10	56	2643	2	he_rms
inarms	8	4	1009	2	inarms
learns	6	55	1374	2	learns
lears	5	59	3873	2	lear_s
nears	5	55	2942	2	near_s
pearls	8	47	1539	2	pearls
pears	7	51	3861	2	pear_s
perms	9	55	2451	2	pe_rms
prearm	10	45	1235	2	prearm_
prewarms	15	40	673	2	prewarms
rams	6	59	5077	2	r_a_ms
rares	5	52	4744	2	r_ares
reacts	8	36	1660	2	reacts
readds	8	41	1164	2	readds
reads	6	48	3527	2	rea_ds
reales	6	49	3412	2	reales
realm	7	56	2162	2	realm_
reals	5	50	3865	2	rea_ls
ream	6	58	4161	2	rea_m_
reaps	7	56	2619	2	rea_ps
rear	4	56	4455	2	rear__
reared	7	59	3001	2	reared
rearer	6	49	2891	2	rearer
rearers	7	43	2356	2	rearers
rearmed	10	39	1282	2	rearmed
rearmost	10	4	726	2	rearmost
reatas	6	40	2101	2	reatas
reaves	9	41	2757	2	reaves
rebars	8	40	1983	2	rebar_s
reearns	7	4	910	2	reearns
reforms	12	3	982	2	reforms
regards	9	41	1256	2	regards
rehems	11	34	1098	2	rehems
remarks	13	32	998	2	remarks
rems	6	62	3772	2	re__ms
reparks	13	24	951	2	reparks
repros	8	42	1600	2	repros
retards	8	50	1500	2	retards
retems	8	39	1457	2	retems
retrims	9	36	1237	2	retrims
retros	6	38	2019	2	retros
rewards	11	48	1399	2	rewards
rewarm	11	59	1349	2	rewarm_
roams	7	49	1961	2	roa_ms
roars	5	56	2224	2	roar_s
seams	7	57	3166	2	sea_ms
sears	5	47	4491	2	sear_s
smarms	10	57	1253	2	smarms
swarms	11	61	1217	2	swarms
teams	7	57	2651	2	tea_ms
tears	5	54	3646	2	tear_s
terms	7	55	2347	2	te_rms
tharms	11	57	1224	2	tharms
unarms	8	3	924	2	unarms
warms	10	77	2685	2	_warms
wears	8	60	3030	2	wear_s
yearns	9	50	954	2	yearns
years	8	45	2767	2	year_s

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.326	548131.9
2	DLD Change Limit	82551	91	2.360	34979.2
3	Display Results	91	91	0.033	2757.6
	(SQL Overall)	178691	91	2.719	65719.4