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

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

83 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
pardee	9	39	2202	(None)
pardie	9	60	2144	1	pardie
ardeb	8	3	1452	2	_ardeb
awardee	11	3	756	2	awardee
barde	8	53	3077	2	bard_e
barded	10	54	2642	2	barded
bardes	9	50	2693	2	bardes
bargee	9	46	2444	2	bargee
carded	10	54	2490	2	carded
carder	9	45	2418	2	carder
farded	11	45	1895	2	farded
fardel	10	47	1259	2	fardel
garden	8	42	1508	2	garden
harden	10	57	1853	2	harden
harder	10	50	2240	2	harder
larded	8	43	1909	2	larded
larder	7	37	2097	2	larder
laree	5	60	3629	2	lar_ee
padded	11	41	1350	2	padded
padder	10	34	1549	2	padder
paddle	10	46	1514	2	paddle
padle	8	45	2234	2	pa_dle
padre	8	60	1816	2	pa_dre
padres	9	50	1698	2	padres
pander	9	37	2552	2	pander
parade	9	47	2064	2	parade
paraded	11	40	1426	2	paraded
parader	10	39	1486	2	parader
parades	10	41	2146	2	parades
parae	7	63	3570	2	par_ae
parcel	10	39	1547	2	parcel
pard	7	64	4132	2	pard__
pardah	12	34	1282	2	pardah
pardi	8	57	2395	2	pard_i
pardine	10	36	1672	2	pardine
pardner	10	23	947	2	pardner
pardon	9	46	1873	2	pardon
pards	8	56	3433	2	pard_s
pardy	11	55	2395	2	pard_y
pare	6	67	6084	2	par__e
pared	8	69	4676	2	par_ed
pareo	7	46	3260	2	par_eo
parer	7	58	3990	2	par_er
pares	7	71	6448	2	par_es
pareu	7	49	2874	2	par_eu
pareve	11	46	1301	2	pareve
parge	8	58	3185	2	par_ge
parged	10	49	2204	2	parged
parges	9	45	2954	2	parges
parget	9	45	2939	2	parget
paries	8	47	4251	2	paries
parked	13	44	2514	2	parked
parker	12	41	2137	2	parker
parle	7	58	3616	2	par_le
parled	9	46	2629	2	parled
parles	8	63	3440	2	parles
parley	11	67	1836	2	parley
parole	8	44	2525	2	parole
parolee	9	41	1964	2	parolee
parred	9	50	2407	2	parred
parrel	8	45	1598	2	parrel
parse	7	52	3699	2	par_se
parsec	10	59	1448	2	parsec
parsed	9	63	2389	2	parsed
parser	8	48	2237	2	parser
parses	8	55	3470	2	parses
parted	9	42	2868	2	parted
parure	8	3	1252	2	parure
parve	10	98	2485	2	par_ve
passee	8	45	2202	2	passee
pattee	8	43	2338	2	pattee
pawnee	11	31	1540	2	pawnee
payee	10	55	2472	2	pa_yee
perdie	9	47	1851	2	perdie
perdue	9	39	1263	2	perdue
pree	6	70	4473	2	p_r_ee
puree	7	46	3284	2	pur_ee
saree	5	50	4466	2	sar_ee
warded	11	50	2104	2	warded
warden	10	45	1551	2	warden
warder	10	40	2027	2	warder
yarded	11	47	1402	2	yarded
yarder	10	38	1397	2	yarder

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.346	516448.0
2	DLD Change Limit	82551	83	2.623	31472.0
3	Display Results	83	83	0.030	2766.7
	(SQL Overall)	178691	83	2.999	59583.5