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

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

111 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
refels	9	46	1805	(None)
rebels	8	45	1813	1	rebels
reels	5	53	3326	1	re_els
refeels	10	37	969	1	refeels
refel	8	49	2081	1	refel_
refell	9	42	1444	1	refell
refelt	9	45	2142	1	refelt
refers	9	39	2108	1	refers
refuels	10	39	952	1	refuels
repels	8	43	1876	1	repels
revels	9	42	2057	1	revels
bedels	9	40	1527	2	bedels
befell	11	42	871	2	befell
betels	8	45	1506	2	betels
bevels	11	39	1398	2	bevels
bezels	17	37	1228	2	bezels
creels	8	44	1694	2	cre_els
crenels	9	37	1101	2	crenels
crewels	12	43	849	2	crewels
defers	10	51	1694	2	defers
defuels	11	29	698	2	defuels
devels	10	43	1390	2	devels
eels	4	65	3674	2	_e_els
feels	8	52	2304	2	fe_els
heels	8	56	2553	2	he_els
jebels	15	41	891	2	jebels
jefes	15	56	1367	2	jefe_s
jewels	16	50	861	2	jewels
keels	9	46	2241	2	ke_els
kevels	13	44	1071	2	kevels
levels	9	41	1328	2	levels
newels	9	37	1082	2	newels
peels	7	52	2642	2	pe_els
prefers	12	37	1333	2	prefers
ratels	6	45	1821	2	ratels
ravels	9	47	1707	2	ravels
reales	6	49	3412	2	reales
reals	5	50	3865	2	re_als
rebecs	10	39	1367	2	rebecs
rebel	7	34	2129	2	rebel_
recess	8	3	1426	2	recess
redes	6	51	3913	2	rede_s
reeds	6	54	3090	2	re_eds
reefers	10	33	1259	2	reefers
reefs	8	51	2166	2	re_efs
reeks	9	41	2403	2	re_eks
reel	4	52	4053	2	re_el_
rees	4	53	6419	2	re_e_s
refall	9	43	1439	2	refall
refalls	10	33	1224	2	refalls
refect	11	43	1933	2	refect
refects	12	40	1274	2	refects
refed	9	39	2192	2	refe_d
refeed	10	47	1762	2	refeed
refeeds	11	36	897	2	refeeds
refeel	9	39	1324	2	refeel
refer	8	48	2214	2	refe_r
refile	9	51	2237	2	refile
refiles	10	41	2242	2	refiles
refill	9	45	1405	2	refill
refills	10	37	1142	2	refills
refilm	11	43	1140	2	refilm
refilms	12	34	750	2	refilms
refits	9	40	1765	2	refits
reflet	9	40	2423	2	reflet
reflets	10	35	1315	2	reflets
reflew	12	38	945	2	reflew
reflex	16	35	951	2	reflex
refly	11	39	1456	2	ref_ly
refold	10	38	1211	2	refold
refolds	11	29	895	2	refolds
refs	7	57	3224	2	ref__s
refuel	9	39	1262	2	refuel_
reges	6	56	2879	2	rege_s
reheels	10	29	825	2	reheels
rehems	11	34	1098	2	rehems
rekeys	13	34	769	2	rekeys
relets	6	40	2567	2	relets
remelt	8	51	2312	2	remelt
remelts	9	35	1149	2	remelts
renews	9	38	1175	2	renews
reoils	6	45	1687	2	reoils
repeals	9	40	1453	2	repeals
repegs	9	33	1194	2	repegs
repel	7	49	2140	2	repel_
reseals	7	39	1768	2	reseals
resees	6	38	2748	2	resees
resell	6	42	1520	2	resell
resells	7	33	1320	2	resells
resets	6	54	2761	2	resets
resews	9	48	1417	2	resews
retell	6	38	1364	2	retell
retells	7	32	1152	2	retells
retems	8	39	1457	2	retems
reveals	10	38	1273	2	reveals
revel	8	44	2316	2	revel_
revers	9	45	2963	2	revers
revets	9	40	2217	2	revets
reweds	10	44	1230	2	reweds
reweld	10	37	1111	2	reweld
rewelds	11	45	741	2	rewelds
rewets	9	46	1721	2	rewets
rexes	12	45	2695	2	rexe_s
riels	5	51	2133	2	r_iels
rifely	12	37	1003	2	rifely
rifles	9	42	1771	2	rifles
rowels	9	45	1545	2	rowels
rubels	8	41	1299	2	rubels
seels	5	56	3282	2	se_els
teels	5	57	2637	2	te_els
wedels	10	38	1103	2	wedels

Search took 4 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.373	479064.3
2	DLD Change Limit	82551	111	3.140	26290.1
3	Display Results	111	111	0.046	2413.0
	(SQL Overall)	178691	111	3.559	50208.2