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

Here are the results of your fuzzy-string dictionary search for “joinery” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

274 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
joinery	17	36	659	(None)
joiner	13	41	1413	1	joiner_
joiners	14	42	1157	1	joiners
coiner	8	43	2378	2	coiner_
coiners	9	36	2075	2	coiners
finery	12	45	1289	2	_finery
jobbery	21	36	601	2	jobbery
joinder	15	33	759	2	joinder_
joinders	16	33	720	2	joinders
joined	14	46	1307	2	joine_d
jointer	14	37	971	2	jointer_
jointers	15	28	932	2	jointers
jointly	17	3	548	2	jointly
onery	8	4	1412	2	_o_nery
ornery	9	3	846	2	_ornery
pinery	11	52	1429	2	_pinery
vinery	12	49	1260	2	_vinery
winery	12	50	1428	2	_winery
aliner	6	56	2198	3	aliner_
aliners	7	47	1772	3	aliners
beanery	12	3	756	3	beanery
binary	11	3	1222	3	_binary
bindery	13	45	983	3	_bindery
biner	7	59	3069	3	_biner_
biners	8	50	2363	3	_biners
bobbery	13	43	835	3	bobbery
boiler	8	43	1927	3	boiler_
boilers	9	34	1706	3	boilers
boner	7	51	3308	3	bo_ner_
boners	8	48	2543	3	bo_ners
boney	10	52	2731	3	bo_ne_y
bonier	8	43	2199	3	bonier_
bootery	12	3	898	3	bootery
bovinely	16	6	442	3	bovinely
bowery	14	60	1211	3	bo_wery
bribery	14	42	649	3	bribery
briery	11	45	1077	3	bri_ery
briner	8	45	1904	3	briner_
briners	9	43	1563	3	briners
broidery	14	35	608	3	broidery
cannery	12	36	1001	3	cannery
cindery	13	42	919	3	_cindery
clownery	16	3	331	3	clownery
cocinera	12	4	555	3	cocinera
coiler	8	44	2159	3	coiler_
coilers	9	36	1990	3	coilers
coined	9	45	2360	3	coine_d
coinfer	12	41	939	3	coinfer_
coinfers	13	34	950	3	coinfers
coinhere	13	3	713	3	coinhere
cointer	9	36	1672	3	cointer_
cointers	10	36	1641	3	cointers
coney	10	59	3288	3	co_ne_y
conner	8	44	2396	3	conner_
conners	9	40	2311	3	conners
cookery	16	42	1039	3	cookery
coopery	14	39	1027	3	coopery
coppery	16	40	939	3	coppery
corner	8	46	2562	3	corner_
corners	9	47	2331	3	corners
country	12	38	804	3	country
deanery	11	3	761	3	deanery
diner	6	56	3290	3	_diner_
dinero	7	56	1264	3	_dinero
diners	7	55	2595	3	_diners
doddery	13	51	685	3	doddery
dodgery	13	62	778	3	dodgery
doggery	13	44	826	3	doggery
donnerd	9	42	781	3	donnerd
donnert	8	28	1553	3	donnert
dowery	13	43	1166	3	do_wery
downer	10	44	1492	3	downer_
downers	11	39	1277	3	downers
eloiner	7	14	918	3	eloiner_
eloiners	8	12	815	3	eloiners
enginery	12	4	456	3	enginery
enjoiner	15	22	565	3	enjoiner_
enjoiners	16	23	462	3	enjoiners
fainer	9	47	1724	3	fainer_
fernery	13	3	581	3	fernery
fiery	11	47	1479	3	_fi_ery
finely	12	30	1156	3	_finely
finer	8	54	3156	3	_finer_
foined	10	59	1501	3	foine_d
foolery	13	3	669	3	foolery
foppery	17	38	562	3	foppery
forgery	14	41	930	3	forgery
foundry	14	3	391	3	foundry
gainer	7	41	1749	3	gainer_
gainers	8	42	1459	3	gainers
gingery	12	36	891	3	_gingery
goiter	7	41	1620	3	goiter_
goiters	8	40	1444	3	goiters
goner	6	60	2516	3	go_ner_
goners	7	44	2017	3	go_ners
gooney	10	66	1231	3	goone_y
grindery	13	25	551	3	grindery
gunnery	11	37	637	3	gunnery
hennery	13	3	530	3	hennery
honer	8	53	3209	3	ho_ner_
honers	9	43	2497	3	ho_ners
honey	11	56	2991	3	ho_ne_y
hosiery	13	33	718	3	hosiery
inert	5	32	3437	3	__inert
jaggery	19	33	690	3	jaggery
jailer	13	43	1668	3	jailer_
jailers	14	41	1404	3	jailers
japery	18	43	914	3	j_apery
jaspery	19	40	525	3	jaspery
jiber	14	51	1570	3	j_iber_
jibers	15	59	1288	3	j_ibers
jingly	17	41	1193	3	j_ingly
jinker	17	40	1354	3	j_inker_
jinkers	18	35	1181	3	j_inkers
jitney	16	30	462	3	jitne_y
jittery	17	34	644	3	jittery
jiver	15	51	1905	3	j_iver_
jivers	16	45	1564	3	j_ivers
jivey	18	51	1187	3	j_ive_y
jobber	17	38	1335	3	jobber_
jobbers	18	29	1113	3	jobbers
jockey	22	40	803	3	jocke_y
joey	14	57	1933	3	jo__e_y
jogger	15	47	1316	3	jogger_
joggers	16	41	1069	3	joggers
johnny	19	3	219	3	john_ny
join	11	67	2483	3	join___
joineries	16	4	810	3	joineries
joining	15	30	1148	3	joining
joins	12	58	1841	3	join__s
joint	12	52	2772	3	join__t
jointed	15	37	850	3	jointed
jointedly	20	13	272	3	jointedly
joints	13	38	1145	3	join_ts
jointure	15	13	483	3	jointure
joker	16	57	1589	3	jo_ker_
jokers	17	55	1119	3	jo_kers
jokey	19	50	1469	3	jo_ke_y
jokier	17	61	875	3	jokier_
jokiness	19	22	739	3	jokiness
jokingly	23	3	477	3	jokingly
jolter	13	35	1309	3	jolter_
jolters	14	37	1199	3	jolters
jones	12	50	2818	3	jo_ne_s
josher	16	43	1296	3	josher_
joshers	17	41	1159	3	joshers
jotter	13	43	1563	3	jotter_
jotters	14	34	1380	3	jotters
jouncy	18	33	620	3	joun_cy
journey	17	3	487	3	journe_y
juicer	15	3	628	3	juicer_
juicers	16	3	615	3	juicers
koine	9	5	1648	3	koine__
koines	10	4	1573	3	koine_s
lineny	9	40	1144	3	_lineny
liner	5	59	3892	3	_liner_
liners	6	54	2885	3	_liners
liney	8	70	2963	3	_line_y
livery	12	49	1090	3	_livery
loaner	6	44	1650	3	loaner_
loaners	7	39	1362	3	loaners
loiter	6	46	1917	3	loiter_
loiters	7	41	1661	3	loiters
lonely	9	29	1247	3	lo_nely
loner	5	54	3104	3	lo_ner_
loners	6	42	2581	3	lo_ners
looney	9	47	1241	3	loone_y
loriner	7	5	1189	3	loriner_
loriners	8	3	996	3	loriners
lottery	10	38	983	3	lottery
lowery	12	41	1271	3	lo_wery
miner	7	69	3354	3	_miner_
miners	8	41	2663	3	_miners
misery	11	41	1354	3	_misery
moaner	8	44	1511	3	moaner_
moaners	9	28	1355	3	moaners
mockery	18	37	691	3	mockery
moiety	11	4	822	3	moi_ety
moiler	8	40	1726	3	moiler_
moilers	9	36	1520	3	moilers
money	10	48	2684	3	mo_ne_y
monkery	16	31	745	3	monkery
mooner	8	53	1783	3	mooner_
mooners	9	40	1534	3	mooners
mopery	13	52	1097	3	mo_pery
mothery	15	37	1051	3	mothery
ninety	9	5	1096	3	_ninety
nitery	9	44	1217	3	_nitery
noninert	8	4	1502	3	noninert
nunnery	10	35	530	3	nunnery
ochery	14	31	944	3	_ochery
oiler	5	46	2828	3	_oiler_
oilers	6	47	2119	3	_oilers
orrery	9	3	678	3	_orrery
owner	8	46	1331	3	_owner_
owners	9	42	1070	3	_owners
piney	10	57	2750	3	_pine_y
pointer	9	38	1493	3	pointer_
pointers	10	30	1372	3	pointers
pointy	11	49	1328	3	poin_ty
poiser	8	42	1724	3	poiser_
poisers	9	42	1443	3	poisers
popery	13	45	1170	3	po_pery
pottery	12	30	1107	3	pottery
powdery	16	39	612	3	powdery
printery	13	31	843	3	printery
quinary	19	3	693	3	quinary
quivery	22	26	546	3	quivery
refinery	14	44	719	3	refinery
robbery	14	34	828	3	robbery
rockery	16	43	925	3	rockery
roguery	11	3	489	3	roguery
rookery	14	39	831	3	rookery
ropery	11	43	1387	3	ro_pery
rosery	9	38	1328	3	ro_sery
ruiner	6	40	1364	3	ruiner_
ruiners	7	42	1302	3	ruiners
scenery	12	3	656	3	scenery
seiner	6	46	2248	3	seiner_
seiners	7	42	1927	3	seiners
shiner	9	38	2087	3	shiner_
shiners	10	40	1594	3	shiners
shinnery	14	30	567	3	shinnery
shivery	16	31	702	3	shivery
sinewy	12	66	751	3	_sinewy
sooner	6	42	2046	3	sooner_
sooners	7	39	1664	3	sooners
sorcery	12	3	703	3	sorcery
sorner	6	47	2039	3	sorner_
sorners	7	34	1687	3	sorners
spicery	14	49	901	3	spicery
spidery	13	30	820	3	spidery
spinnery	13	41	659	3	spinnery
tannery	10	38	866	3	tannery
tindery	11	38	936	3	_tindery
toggery	12	50	592	3	toggery
toiler	6	39	1828	3	toiler_
toilers	7	41	1626	3	toilers
toiletry	11	4	410	3	toiletry
toner	5	53	3624	3	to_ner_
toners	6	41	2800	3	to_ners
toney	8	60	2741	3	to_ne_y
tonier	6	55	2071	3	tonier_
tonner	6	48	1920	3	tonner_
tonners	7	38	1640	3	tonners
tottery	10	38	848	3	tottery
towery	12	40	1209	3	to_wery
trinary	10	3	917	3	trinary
turnery	10	35	742	3	turnery
twiner	9	40	1259	3	twiner_
twiners	10	45	963	3	twiners
urinary	10	3	724	3	urinary
vainer	9	37	1457	3	vainer_
veiner	9	45	1475	3	veiner_
veiners	10	41	1252	3	veiners
venery	12	37	1066	3	_venery
voicer	11	39	1054	3	voicer_
voicers	12	34	899	3	voicers
voider	10	36	1155	3	voider_
voiders	11	27	982	3	voiders
volery	12	3	787	3	vo_lery
weiner	9	42	1413	3	weiner_
weiners	10	39	1306	3	weiners
whiner	12	45	1663	3	whiner_
whiners	13	40	1157	3	whiners
whiney	15	50	1264	3	whine_y
winey	11	53	2543	3	_wine_y
wintery	13	39	975	3	_wintery
wintry	12	49	892	3	_wintry
wonner	9	51	1444	3	wonner_
wonners	10	43	1281	3	wonners
zonary	18	3	879	3	zo_nary
zoner	14	45	2034	3	zo_ner_
zoners	15	51	1599	3	zo_ners

Search took 7 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	134027	0.406	440125.6
2	DLD Change Limit	134027	274	6.296	21287.6
3	Display Results	274	274	0.093	2946.2
	(SQL Overall)	178691	274	6.795	26297.4