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

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

90 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
riant	5	58	3315	(None)
giant	6	54	3059	1	giant
rant	4	58	6468	1	r_ant
alant	5	57	4229	2	alant
ant	3	72	7079	2	__ant
arrant	6	6	2325	2	arrant
avant	8	62	2466	2	avant
bint	6	73	5504	2	bi_nt
biont	7	7	2716	2	biont
brant	7	47	4217	2	brant
brisant	9	3	1268	2	brisant
cant	6	63	6203	2	_cant
chant	10	59	3269	2	chant
dint	5	67	5905	2	di_nt
errant	6	6	1873	2	errant
faint	8	58	3706	2	faint
fiat	7	66	4664	2	fia_t
giants	7	47	1350	2	giants
grant	6	48	4002	2	grant
haint	8	54	3632	2	haint
hant	7	54	6159	2	_hant
hint	7	74	5574	2	hi_nt
kiang	10	48	1135	2	kiang
leant	5	67	3778	2	leant
liana	5	39	1589	2	liana
liane	5	47	2066	2	liane
liang	6	49	1441	2	liang
lint	4	162	6623	2	li_nt
meant	7	65	3721	2	meant
mint	6	67	5806	2	mi_nt
orient	6	3	2253	2	orient
paint	7	54	4369	2	paint
pant	6	60	6126	2	_pant
pian	6	61	3609	2	pian_
piano	7	61	1871	2	piano
pians	7	51	2696	2	pians
pint	6	69	6317	2	pi_nt
plant	7	54	3711	2	plant
pliant	8	39	1882	2	pliant
print	7	48	3746	2	pri_nt
quant	14	36	2481	2	quant
radiant	8	28	1713	2	radiant
raft	7	62	4591	2	r_aft
rain	4	62	5173	2	rain_
rains	5	51	4023	2	rains
rainy	8	59	2108	2	rainy
ran	3	82	6662	2	r_an_
rand	5	58	3957	2	r_and
rang	5	69	3916	2	r_ang
rani	4	66	4011	2	r_ani
rank	8	51	3553	2	r_ank
rants	5	59	3534	2	r_ants
rapt	6	72	4531	2	r_apt
rat	3	78	9274	2	r_a_t
react	7	46	3433	2	react
recant	8	32	2868	2	recant
reliant	7	3	1924	2	reliant
rent	4	66	6124	2	r_ent
ria	3	67	4550	2	ria__
rial	4	59	3809	2	ria_l
rials	5	50	2667	2	rials
rialto	6	3	860	2	rialto
riantly	10	3	761	2	riantly
rias	4	55	4059	2	ria_s
riata	5	46	1802	2	riata
riband	9	23	962	2	riband
rident	7	5	2019	2	rident
rift	7	56	4233	2	ri_ft
right	9	44	3050	2	right
rin	3	66	6318	2	ri_n_
rind	5	65	3560	2	ri_nd
ring	5	65	4115	2	ri_ng
rink	8	77	3699	2	ri_nk
rins	4	61	5319	2	ri_ns
riot	4	59	4721	2	ri_ot
rivet	8	56	3636	2	rivet
roan	4	72	3420	2	roan_
roans	5	49	2644	2	roans
roast	5	62	3014	2	roast
ruana	5	3	1242	2	ruana
runt	4	66	4799	2	r_unt
saint	5	51	4707	2	saint
scant	7	97	3507	2	scant
slant	5	52	3870	2	slant
taint	5	55	4228	2	taint
tint	4	67	5886	2	ti_nt
truant	6	3	1578	2	truant
variant	10	3	1680	2	variant
viand	9	5	1107	2	viand
want	7	61	5617	2	_want

Search took 2 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	90	1.500	35866.7
3	Display Results	90	90	0.013	6923.1
	(SQL Overall)	178691	90	1.826	97859.3