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

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

93 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
realm	7	56	2162	(None)
real	4	57	5029	1	real_
realms	8	49	1349	1	realms
reals	5	50	3865	1	reals
ream	6	58	4161	1	rea_m
rearm	7	59	2356	1	rearm
areal	5	59	2873	2	areal_
balm	8	55	3420	2	_balm
beam	8	69	3923	2	bea_m
becalm	12	3	920	2	becalm
bream	9	51	2181	2	brea_m
calm	8	50	3236	2	_calm
cream	9	57	2134	2	crea_m
deal	5	63	4741	2	deal_
deals	6	54	3534	2	deals
dealt	6	52	3428	2	dealt
dream	8	51	2039	2	drea_m
elm	5	75	3174	2	_e_lm
feal	7	139	4042	2	feal_
halm	9	58	3497	2	_halm
heal	7	56	4569	2	heal_
heals	8	57	3345	2	heals
helm	9	55	3002	2	he_lm
leal	4	60	4327	2	leal_
malm	8	51	2997	2	_malm
meal	6	56	4317	2	meal_
meals	7	59	3337	2	meals
mealy	10	44	2218	2	mealy
palm	8	53	3136	2	_palm
peal	6	86	4810	2	peal_
peals	7	52	3549	2	peals
prearm	10	45	1234	2	prearm
psalm	9	4	927	2	psalm
qualm	16	35	1118	2	qualm
rale	4	50	5056	2	r_ale
ram	5	68	6727	2	r_a_m
reach	10	51	2388	2	reach
react	7	46	3433	2	react
read	5	59	4253	2	rea_d
readd	7	46	1713	2	readd
reads	6	48	3527	2	reads
ready	9	48	2150	2	ready
realer	6	35	2859	2	realer
reales	6	49	3412	2	reales
realia	6	3	1459	2	realia
realism	9	31	1592	2	realism
really	9	33	1561	2	really
realty	9	27	1369	2	realty
reams	7	57	2962	2	reams
reap	6	59	3474	2	rea_p
reaps	7	56	2619	2	reaps
rear	4	56	4455	2	rea_r
rearms	8	51	1465	2	rearms
rears	5	47	3965	2	rears
reata	5	42	2539	2	reata
reave	8	45	2802	2	reave
recall	8	38	1572	2	recall
redly	9	42	1719	2	redly
reel	4	52	4053	2	reel_
reels	5	53	3326	2	reels
refall	9	43	1439	2	refall
refilm	11	43	1140	2	refilm
refly	11	39	1456	2	refly
regal	6	50	2379	2	regal_
regale	7	48	2145	2	regale
rehem	10	38	1535	2	rehem
relax	12	48	1780	2	relax
relay	8	44	2467	2	relay
rely	7	54	2895	2	re_ly
rem	5	61	5004	2	re__m
renal	5	59	2950	2	renal_
reply	10	40	1585	2	reply
resale	6	40	2554	2	resale
retem	7	42	2195	2	retem
rewarm	11	59	1348	2	rewarm
rial	4	59	3809	2	rial_
rials	5	50	2667	2	rials
roam	6	71	3241	2	roa_m
seal	4	56	5437	2	seal_
seals	5	48	3969	2	seals
seam	6	66	4597	2	sea_m
teal	4	55	4650	2	teal_
teals	5	62	3413	2	teals
team	6	62	3865	2	tea_m
ureal	5	67	2268	2	ureal_
veal	7	69	3681	2	veal_
veals	8	49	2619	2	veals
vealy	11	58	1777	2	vealy
weal	7	58	3868	2	weal_
weald	9	56	1502	2	weald
weals	8	54	2874	2	weals
zeal	13	55	3033	2	zeal_
zeals	14	53	2085	2	zeals

Search took 6 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.190	940478.9
2	DLD Change Limit	53800	93	4.250	12658.8
3	Display Results	93	93	0.046	2021.7
	(SQL Overall)	178691	93	4.486	39833.0