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

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

74 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
joiners	14	42	1157	(None)
coiners	9	36	2075	1	coiners
joinders	16	33	720	1	joinders
joiner	13	41	1413	1	joiner_
joinery	17	36	659	1	joinery
jointers	15	28	932	1	jointers
aliners	7	47	1772	2	aliners
biners	8	50	2363	2	_biners
boilers	9	34	1706	2	boilers
boners	8	48	2543	2	bo_ners
briners	9	43	1563	2	briners
coilers	9	36	1990	2	coilers
coiner	8	43	2378	2	coiner_
coinfers	13	34	950	2	coinfers
cointers	10	36	1641	2	cointers
conners	9	40	2311	2	conners
corners	9	47	2331	2	corners
diners	7	55	2595	2	_diners
downers	11	39	1277	2	downers
eloiners	8	12	815	2	eloiners
enjoiners	16	23	462	2	enjoiners
gainers	8	42	1459	2	gainers
goiters	8	40	1444	2	goiters
goners	7	44	2017	2	go_ners
honers	9	43	2497	2	ho_ners
jailers	14	41	1404	2	jailers
jibers	15	59	1288	2	j_ibers
jinkers	18	35	1181	2	j_inkers
jivers	16	45	1564	2	j_ivers
jobbers	18	29	1113	2	jobbers
joggers	16	41	1069	2	joggers
joinder	15	33	759	2	joinder_
joined	14	46	1307	2	joine_d
joineries	16	4	810	2	joineries
joins	12	58	1841	2	join__s
jointer	14	37	971	2	jointer_
joints	13	38	1145	2	join_ts
jokers	17	55	1119	2	jo_kers
jokiness	19	22	739	2	jokiness
jolters	14	37	1199	2	jolters
jones	12	50	2818	2	jo_ne_s
joshers	17	41	1159	2	joshers
jotters	14	34	1380	2	jotters
juicers	16	3	615	2	juicers
koines	10	4	1573	2	koine_s
liners	6	54	2885	2	_liners
loaners	7	39	1362	2	loaners
loiters	7	41	1661	2	loiters
loners	6	42	2581	2	lo_ners
loriners	8	3	996	2	loriners
miners	8	41	2663	2	_miners
moaners	9	28	1355	2	moaners
moilers	9	36	1520	2	moilers
mooners	9	40	1534	2	mooners
oilers	6	47	2119	2	_oilers
owners	9	42	1070	2	_owners
pointers	10	30	1372	2	pointers
poisers	9	42	1443	2	poisers
ruiners	7	42	1302	2	ruiners
seiners	7	42	1927	2	seiners
shiners	10	40	1594	2	shiners
sooners	7	39	1664	2	sooners
sorners	7	34	1687	2	sorners
toilers	7	41	1626	2	toilers
toners	6	41	2800	2	to_ners
tonners	7	38	1640	2	tonners
twiners	10	45	963	2	twiners
veiners	10	41	1252	2	veiners
voicers	12	34	899	2	voicers
voiders	11	27	982	2	voiders
weiners	10	39	1306	2	weiners
whiners	13	40	1157	2	whiners
wonners	10	43	1281	2	wonners
zoners	15	51	1599	2	zo_ners

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	107671	0.126	1418182.5
2	DLD Change Limit	107671	74	2.830	38046.3
3	Display Results	74	74	0.030	2466.7
	(SQL Overall)	178691	74	2.986	59842.9