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

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

72 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
rankle	10	34	1488	(None)
ankle	9	52	2025	1	_ankle
crankle	13	36	1006	1	crankle
rackle	12	39	1729	1	rackle
rankled	12	39	1065	1	rankled
rankles	11	31	1454	1	rankles
rankly	13	39	1045	1	rankly
runkle	10	36	1154	1	runkle
anele	5	56	2883	2	_anele
angle	6	45	2887	2	_angle
anile	5	46	3446	2	_anile
ankled	11	43	1347	2	_ankled
ankles	10	48	1838	2	_ankles
anklet	10	56	1873	2	_anklet
anole	5	53	3037	2	_anole
bangle	9	40	1895	2	bangle
cackle	14	34	1692	2	cackle
candle	9	43	2148	2	candle
cantle	8	45	2215	2	cantle
crackle	15	36	1125	2	crackle
crankled	15	40	815	2	crankled
crankles	14	35	1015	2	crankles
crankly	16	35	812	2	crankly
crinkle	13	35	941	2	crinkle
dandle	8	42	1809	2	dandle
dangle	8	41	1930	2	dangle
dankly	14	41	946	2	dankly
darkle	11	38	1394	2	darkle
frankly	17	31	563	2	frankly
grackle	14	33	889	2	grackle
granule	8	3	947	2	granule
hackle	15	49	1681	2	hackle
handle	10	42	1929	2	handle
hankie	13	39	1571	2	hankie
hantle	9	43	1820	2	hantle
inkle	9	45	1583	2	_inkle
jangle	14	44	1629	2	jangle
lankly	13	43	962	2	lankly
mackle	14	37	1643	2	mackle
mangle	9	39	2132	2	mangle
mantle	8	44	2092	2	mantle
rabble	10	38	1824	2	rabble
raddle	8	48	1617	2	raddle
raffle	12	39	1070	2	raffle
raggle	8	37	1288	2	raggle
rake	8	48	4157	2	ra_k_e
rakee	9	60	3117	2	ra_kee
rale	4	50	5056	2	ra__le
ramble	10	45	1997	2	ramble
rance	7	50	2851	2	ran_ce
ranee	5	54	3810	2	ran_ee
range	6	47	2841	2	ran_ge
rank	8	51	3552	2	rank__
ranked	11	46	2074	2	ranked
ranker	10	50	2190	2	ranker
rankless	12	26	823	2	rankless
ranks	9	52	2573	2	rank_s
ranula	6	3	1181	2	ranula
rassle	6	38	1320	2	rassle
rattle	6	47	1761	2	rattle
ruckle	12	44	1458	2	ruckle
rundle	7	32	1423	2	rundle
runkled	12	39	901	2	runkled
runkles	11	41	1194	2	runkles
tackle	12	38	1573	2	tackle
tangle	7	40	1995	2	tangle
tinkle	10	37	1445	2	tinkle
wandle	10	53	1666	2	wandle
wangle	10	38	1750	2	wangle
winkle	13	38	1283	2	winkle
wrangle	11	3	738	2	wrangle
wrinkle	14	29	692	2	wrinkle

Search took 5 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	72	3.936	20973.3
3	Display Results	72	72	0.046	1565.2
	(SQL Overall)	178691	72	4.092	43668.4