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

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

76 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
retail	6	55	2207	(None)
detail	7	45	1643	1	detail
redtail	8	5	871	1	redtail
remail	8	50	1712	1	remail
renail	6	50	2076	1	renail
resail	6	44	1873	1	resail
retails	7	47	1897	1	retails
retain	6	45	2328	1	retain
retial	6	47	2499	1	retial
bewail	11	8	958	2	bewail
derail	7	42	1881	2	derail
details	8	42	1404	2	details
detain	7	46	1738	2	detain
email	7	47	1510	2	_email
entail	6	11	1434	2	entail
fetal	8	56	2337	2	feta_l
fetial	9	57	1619	2	fetial
jezail	22	3	464	2	jezail
metal	7	54	2738	2	meta_l
oxtail	13	3	765	2	oxtail
petal	7	65	2689	2	peta_l
prevail	12	3	824	2	prevail
rail	4	61	4776	2	r__ail
ratal	5	50	2511	2	rata_l
rattail	7	3	779	2	rattail
real	4	57	5029	2	re_a_l
reavail	10	3	564	2	reavail
rebait	8	3	2040	2	rebait
reboil	8	38	1468	2	reboil
recall	8	38	1572	2	recall
recoil	8	40	1672	2	recoil
rectal	8	44	1813	2	recta_l
redial	7	49	2311	2	redial
redtails	9	6	800	2	redtails
refall	9	43	1439	2	refall
regain	7	45	1776	2	regain
regal	6	50	2379	2	rega_l
relaid	7	55	1844	2	relaid
remails	9	47	1456	2	remails
remain	8	59	1986	2	remain
renails	7	49	1726	2	renails
renal	5	59	2950	2	rena_l
rental	6	39	2202	2	renta_l
reoil	5	53	2118	2	re_oil
repaid	9	47	1632	2	repaid
repair	8	40	1146	2	repair
resaid	7	45	1708	2	resaid
resails	7	46	1674	2	resails
retable	9	18	2040	2	retable
retack	12	26	1282	2	retack
retag	6	36	1841	2	reta_g
retags	7	34	1430	2	retags
retailed	9	41	1396	2	retailed
retailer	8	29	1157	2	retailer
retailor	8	28	522	2	retailor
retains	7	45	2225	2	retains
retake	10	47	1853	2	retake
retally	10	4	1368	2	retally
retape	8	39	1768	2	retape
retard	7	50	1893	2	retard
retax	12	45	1797	2	reta_x
retell	6	38	1364	2	retell
retia	5	53	2611	2	ret_ia
retie	5	57	3530	2	ret_ie
retile	6	59	2967	2	ret_ile
retool	6	39	1448	2	retool
retrain	7	6	1542	2	retrain
retral	6	44	1974	2	retral
retrial	7	6	1555	2	retrial
retrim	8	35	1487	2	retrim
serail	6	42	2267	2	serail
setal	5	64	3090	2	seta_l
tail	4	54	4365	2	__tail
tenail	6	45	1610	2	tenail
trenail	7	4	1080	2	trenail
ventail	10	3	1045	2	ventail

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.110	1624463.6
2	DLD Change Limit	82551	76	2.580	31996.5
3	Display Results	76	76	0.030	2533.3
	(SQL Overall)	178691	76	2.720	65695.2