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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

104 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
rifles	9	42	1770	(None)
riffles	13	39	1116	1	riffles
rifle	8	55	1833	1	rifle_
rifled	10	41	1500	1	rifled
rifler	9	40	1426	1	rifler
riflers	10	35	1219	1	riflers
riles	5	53	4364	1	ri_les
rilles	6	47	2550	1	rilles
trifles	10	38	1482	1	trifles
aisles	6	47	2114	2	aisles
bibles	10	46	1764	2	bibles
biflex	18	3	495	2	biflex
biles	7	55	4214	2	bi_les
birles	8	49	2064	2	birles
bridles	10	41	1447	2	bridles
fifes	11	48	2239	2	fif_es
files	8	54	4127	2	fi_les
filles	9	42	2452	2	filles
griffes	14	36	792	2	griffes
grilles	8	37	1502	2	grilles
idles	6	67	2012	2	_idles
isles	5	42	2056	2	_isles
lisles	6	34	1628	2	lisles
miles	7	46	4507	2	mi_les
milles	8	45	2656	2	milles
orioles	7	4	1299	2	orioles
piffles	15	36	876	2	piffles
piles	7	47	4261	2	pi_les
raffles	13	36	1184	2	raffles
rales	5	49	4749	2	r_ales
reales	6	49	3412	2	reales
refels	9	46	1805	2	refels
refiles	10	41	2242	2	refiles
reflet	9	40	2423	2	reflet
reflets	10	35	1315	2	reflets
reflew	12	38	945	2	reflew
reflex	16	35	951	2	reflex
reflies	10	44	1853	2	reflies
reifies	10	42	1828	2	reifies
rials	5	50	2667	2	rial_s
ribes	7	55	3017	2	ri_bes
ribless	9	34	1034	2	ribless
riblet	8	42	2244	2	riblet
riblets	9	34	1255	2	riblets
rices	7	55	3615	2	ri_ces
riches	11	50	2208	2	riches
riddles	9	32	1502	2	riddles
rides	6	61	4081	2	ri_des
ridges	8	58	1700	2	ridges
ridley	10	16	954	2	ridley
ridleys	11	14	578	2	ridleys
riels	5	51	2133	2	riel_s
rife	7	46	3232	2	rif_e_
rifely	12	37	1003	2	rifely
rifer	8	47	2198	2	rif_er
rifest	9	31	1458	2	rif_est
riffed	13	38	1156	2	riffed
riffle	12	42	1023	2	riffle_
riffled	14	33	860	2	riffled
riffler	13	32	835	2	riffler
rifflers	14	33	644	2	rifflers
riffs	11	51	1461	2	rif_fs
riflery	13	34	580	2	riflery
riflip	11	3	472	2	riflip
riflips	12	3	416	2	riflips
rifs	7	49	2900	2	rif__s
rifted	10	41	1531	2	rifted
riftless	11	3	694	2	riftless
rifts	8	57	1864	2	rif_ts
rile	4	56	5053	2	ri_le_
riled	6	58	3325	2	ri_led
riley	8	44	2058	2	ri_ley
rille	5	57	2873	2	rille_
rilled	7	45	2565	2	rilled
rillet	6	48	2885	2	rillet
rillets	7	42	1615	2	rillets
rills	5	50	3271	2	ri_lls
rimes	7	56	3454	2	ri_mes
rimless	9	36	936	2	rimless
rimples	11	31	1422	2	rimples
rinses	6	47	2038	2	rinses
ripes	7	54	3577	2	ri_pes
ripples	11	35	1329	2	ripples
rises	5	52	4404	2	ri_ses
rites	5	44	4255	2	ri_tes
ritzes	15	48	1294	2	ritzes
rives	8	53	3600	2	ri_ves
robles	8	53	2169	2	robles
roles	5	67	4798	2	r_oles
rubles	8	39	2170	2	rubles
ruffes	12	41	1242	2	ruffes
ruffles	13	35	1226	2	ruffles
rules	5	52	3425	2	r_ules
sidles	7	47	2115	2	sidles
stifles	10	30	1339	2	stifles
tiles	5	55	4210	2	ti_les
titles	6	37	1992	2	titles
trifle	9	40	1288	2	trifle_
trifled	11	37	1196	2	trifled
trifler	10	39	1215	2	trifler
triflers	11	31	1021	2	triflers
triples	9	46	1687	2	triples
wifes	11	45	2256	2	wif_es
wiles	8	54	3787	2	wi_les

Search took 9 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.233	766914.2
2	DLD Change Limit	82551	104	6.453	12792.7
3	Display Results	104	104	0.080	1300.0
	(SQL Overall)	178691	104	6.766	26410.1