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

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

284 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
fernery	13	3	581	(None)
beanery	12	3	756	2	beanery
deanery	11	3	761	2	deanery
fernier	10	31	1082	2	fernier_
ferny	11	58	1618	2	fern__y
ferrety	13	28	701	2	ferrety
ferry	11	60	2080	2	fer__ry
finery	12	45	1289	2	f_inery
forgery	14	41	930	2	forgery
hennery	13	3	530	2	hennery
mercery	14	39	762	2	mercery
ornery	9	3	846	2	_ornery
ternary	10	3	834	2	ternary
turnery	10	35	742	2	turnery
venery	12	37	1066	2	ve_nery
aerier	6	48	2315	3	aerier_
artery	9	9	1145	3	_artery
barney	11	53	1445	3	barne_y
beery	10	52	2012	3	be__ery
bergere	10	6	891	3	bergere
berry	10	45	2177	3	ber__ry
berserk	13	3	491	3	berserk
brewery	15	37	696	3	brewery
briery	11	45	1077	3	_briery
burner	8	38	1920	3	burner_
burners	9	41	1567	3	burners
cannery	12	36	1001	3	cannery
carney	11	53	1570	3	carne_y
celery	11	3	962	3	ce_lery
corner	8	46	2562	3	corner_
corners	9	47	2331	3	corners
darner	7	40	1730	3	darner_
darners	8	38	1577	3	darners
denary	10	53	1686	3	de_nary
dernier	8	30	1194	3	dernier_
derry	9	47	2137	3	der__ry
earner	6	36	1722	3	earner_
earners	7	40	1645	3	earners
eatery	9	53	1635	3	_eatery
eerier	6	43	2002	3	eerier_
eery	7	61	2962	3	_e__ery
emery	10	48	1433	3	_e_mery
empery	13	4	868	3	_empery
enemy	10	5	999	3	_e_nemy
energy	10	13	751	3	_e_nergy
entry	8	24	1426	3	_e_ntry
erne	4	67	2743	3	_erne__
ernes	5	52	2481	3	_erne_s
every	11	52	1545	3	_e_very
faery	11	60	1548	3	f__aery
fainer	9	47	1724	3	fainer_
fakery	16	50	926	3	f_akery
fanner	9	42	1818	3	fanner_
fanners	10	39	1465	3	fanners
farcer	11	50	1608	3	farcer_
farcers	12	47	1344	3	farcers
farer	8	67	3314	3	far_er_
farers	9	59	2405	3	far_ers
farmer	11	50	1737	3	farmer_
farmers	12	43	1526	3	farmers
farness	10	29	1220	3	farness
farriery	14	29	540	3	farriery
fawner	12	59	1046	3	fawner_
fawners	13	38	849	3	fawners
fearer	9	48	2018	3	fearer_
fearers	10	48	1527	3	fearers
feater	9	52	2405	3	feater_
feathery	17	36	807	3	feathery
feeder	10	35	1384	3	feeder_
feeders	11	37	1286	3	feeders
feeler	9	32	1517	3	feeler_
feelers	10	38	1474	3	feelers
feigner	11	3	559	3	feigner_
feigners	12	3	548	3	feigners
felinely	14	4	595	3	felinely
feller	9	44	1955	3	feller_
fellers	10	41	1754	3	fellers
felonry	13	29	484	3	felonry
fencer	11	46	1353	3	fencer_
fencers	12	38	1062	3	fencers
fender	10	37	1872	3	fender_
fenders	11	37	1726	3	fenders
fennec	11	32	691	3	fenne_c
fennecs	12	30	569	3	fennecs
fennel	9	42	947	3	fenne_l
fennels	10	38	790	3	fennels
fennier	10	33	925	3	fennier_
fenny	11	51	1513	3	fe_n_ny
feodary	14	4	471	3	feodary
fere	7	63	4223	3	fer_e__
feres	8	60	3818	3	fer_e_s
feretory	14	4	751	3	feretory
ferine	9	64	2258	3	ferine__
ferity	12	28	1334	3	fer_ity
ferly	11	55	1735	3	fer__ly
ferment	12	3	1557	3	ferment
fern	7	61	2932	3	fern___
ferneries	12	3	904	3	ferneries
ferniest	11	322	1415	3	ferniest
fernless	11	3	606	3	fernless
ferns	8	52	2008	3	fern__s
ferrel	9	28	1020	3	ferre_l
ferrels	10	24	862	3	ferrels
ferret	9	30	2117	3	ferre_t
ferrets	10	31	1139	3	ferrets
fervency	19	4	438	3	fervency
fervent	13	3	1006	3	fervent
fervor	12	3	564	3	fervor_
fervors	13	3	623	3	fervors
fester	9	47	2351	3	fester_
festers	10	41	2139	3	festers
fetter	9	41	2038	3	fetter_
fetters	10	35	1790	3	fetters
feudary	14	4	427	3	feudary
fever	11	56	1795	3	fe_ver_
fevers	12	54	1489	3	fe_vers
fewer	11	52	1612	3	fe_wer_
fewness	13	3	500	3	fewness
feyer	11	50	1452	3	fe_yer_
feyness	13	3	492	3	feyness
fiercely	16	4	331	3	fiercely
fiercer	12	35	695	3	fiercer_
fierier	10	35	1119	3	fierier_
fiery	11	47	1479	3	f__iery
finely	12	30	1156	3	f_inely
finer	8	54	3156	3	f_iner_
firer	8	112	2925	3	fir_er_
firers	9	49	2268	3	fir_ers
firmer	11	47	1244	3	firmer_
firmers	12	47	1144	3	firmers
firry	11	57	1353	3	fir__ry
fishery	16	39	773	3	fishery
flowery	16	32	778	3	flowery
foolery	13	3	669	3	foolery
foppery	17	38	562	3	foppery
forcer	11	49	1734	3	forcer_
forcers	12	42	1571	3	forcers
foreby	14	3	863	3	for_eby
forger	10	48	2077	3	forger_
forgers	11	52	1818	3	forgers
forker	13	47	1790	3	forker_
forkers	14	46	1578	3	forkers
former	11	42	2140	3	former_
formerly	16	4	500	3	formerly
formers	12	82	1795	3	formers
fornent	10	3	1293	3	fornent
foundry	14	3	391	3	foundry
freely	12	3	1096	3	f_reely
freer	8	60	2124	3	f_reer_
freers	9	47	1730	3	f_reers
frenzy	21	3	588	3	fren_zy
frere	8	56	1772	3	f_r_ere
friary	12	40	1009	3	f_riary
frier	8	52	2584	3	f_rier_
friers	9	47	1893	3	f_riers
fryer	11	59	1343	3	f_ryer_
fryers	12	57	1097	3	f_ryers
fullery	13	33	797	3	fullery
funner	9	34	1410	3	funner_
furler	9	36	1640	3	furler_
furlers	10	42	1422	3	furlers
furmety	15	3	481	3	furmety
furriery	14	39	568	3	furriery
furry	11	67	1928	3	fur__ry
garner	7	39	1700	3	garner_
garners	8	38	1598	3	garners
genera	7	12	1171	3	ge_nera
gentry	10	34	1044	3	ge_ntry
gerbera	10	3	477	3	gerbera
greenery	12	26	592	3	greenery
gunnery	11	37	637	3	gunnery
gurney	10	42	941	3	gurne_y
hellery	13	32	921	3	hellery
henry	11	40	1447	3	he_n_ry
herder	10	45	1646	3	herder_
herders	11	39	1412	3	herders
hereby	14	46	833	3	her_eby
heresy	12	50	1123	3	her_esy
heronry	13	4	604	3	heronry
herry	11	49	2247	3	her__ry
jerker	17	36	904	3	jerker_
jerkers	18	28	708	3	jerkers
jerry	15	50	1618	3	jer__ry
jersey	16	3	633	3	jerse_y
joinery	17	36	659	3	joinery
keener	10	40	1284	3	keener_
keeners	11	36	1078	3	keeners
kerne	9	47	1822	3	kerne__
kerned	11	41	1293	3	kerne_d
kernel	10	40	1059	3	kerne_l
kernelly	15	4	393	3	kernelly
kernels	11	41	795	3	kernels
kernes	10	47	1753	3	kerne_s
kerry	12	49	1609	3	ker__ry
kersey	13	3	679	3	kerse_y
leaner	6	40	2219	3	leaner_
leaners	7	37	1817	3	leaners
learner	7	31	938	3	learner_
learners	8	39	815	3	learners
lechery	15	25	764	3	lechery
leery	8	59	1913	3	le__ery
meaner	8	46	1784	3	meaner_
meaners	9	44	1524	3	meaners
mercer	10	52	1420	3	mercer_
mercers	11	44	1277	3	mercers
mercury	14	36	489	3	mercury
merely	11	13	1259	3	mer_ely
merer	7	51	2623	3	mer_er_
merger	9	50	1648	3	merger_
mergers	10	38	1342	3	mergers
merry	10	47	2149	3	mer__ry
nunnery	10	35	530	3	nunnery
nursery	10	39	602	3	nursery
onery	8	4	1412	3	__onery
orrery	9	3	678	3	_orrery
pedlery	13	29	708	3	pedlery
peery	10	57	1944	3	pe__ery
penner	8	46	1666	3	penner_
penners	9	34	1418	3	penners
penury	11	4	810	3	pe_nury
peppery	13	28	625	3	peppery
perjury	19	24	425	3	perjury
perry	10	52	2271	3	per__ry
perter	8	44	2228	3	perter_
pervert	12	3	1558	3	pervert
pinery	11	52	1429	3	_pinery
reentry	10	3	803	3	reentry
refinery	14	44	719	3	refinery
revery	12	40	1421	3	re_very
scenery	12	3	656	3	scenery
sealery	10	40	1105	3	sealery
seiner	6	46	2248	3	seiner_
seiners	7	42	1927	3	seiners
senary	9	37	1607	3	se_nary
sentry	9	29	1205	3	se_ntry
serenely	11	4	762	3	serenely
serener	7	34	1576	3	serener_
serer	5	59	3551	3	ser_er_
serger	7	38	1974	3	serger_
sergers	8	38	1563	3	sergers
serry	8	48	2412	3	ser__ry
server	9	49	1771	3	server_
servers	10	32	1483	3	servers
sorcery	12	3	703	3	sorcery
sorner	6	47	2039	3	sorner_
sorners	7	34	1687	3	sorners
sterner	7	4	1191	3	sterner_
surgery	11	31	921	3	surgery
tannery	10	38	866	3	tannery
teener	6	47	1750	3	teener_
teeners	7	44	1545	3	teeners
tenner	6	41	1710	3	tenner_
tenners	7	40	1492	3	tenners
termer	8	57	1725	3	termer_
termers	9	54	1450	3	termers
terne	5	64	2615	3	terne__
ternes	6	54	2290	3	terne_s
terry	8	47	2187	3	ter__ry
tersely	10	3	811	3	tersely
terser	6	73	1782	3	terser_
turner	6	39	1461	3	turner_
turners	7	39	1289	3	turners
veery	11	58	1625	3	ve__ery
veiner	9	45	1475	3	veiner_
veiners	10	41	1252	3	veiners
verger	10	43	1570	3	verger_
vergers	11	44	1263	3	vergers
verier	9	46	2096	3	verier_
vernier	10	27	1127	3	vernier_
verniers	11	22	784	3	verniers
verser	9	45	1696	3	verser_
versers	10	38	1352	3	versers
vinery	12	49	1260	3	_vinery
warner	9	37	1722	3	warner_
warners	10	33	1556	3	warners
weaner	9	38	1677	3	weaner_
weaners	10	46	1383	3	weaners
weiner	9	42	1413	3	weiner_
weiners	10	39	1306	3	weiners
winery	12	50	1428	3	_winery
yarner	9	33	1306	3	yarner_
yarners	10	43	1220	3	yarners
yearner	10	33	687	3	yearner_
yearners	11	34	637	3	yearners

Search took 9 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	284	8.063	16622.5
3	Display Results	284	284	0.110	2581.8
	(SQL Overall)	178691	284	8.579	20828.9