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

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

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

345 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
farer	8	67	3314	(None)
barer	7	45	3580	1	barer
carer	7	49	4233	1	carer
darer	6	52	3079	1	darer
facer	10	55	2505	1	facer
fader	9	44	2151	1	fader
fairer	9	52	1206	1	fairer
faker	12	48	2459	1	faker
farcer	11	50	1608	1	farcer
fare	7	63	5446	1	fare_
fared	9	58	4234	1	fared
farers	9	59	2405	1	farers
fares	8	58	5287	1	fares
farmer	11	50	1737	1	farmer
fearer	9	48	2018	1	fearer
firer	8	112	2925	1	firer
parer	7	58	3990	1	parer
rarer	5	47	3170	1	rarer
yarer	8	43	2157	1	yarer
after	8	57	1979	2	after
ager	5	59	3584	2	_ager
airer	5	49	2789	2	airer
aper	6	63	3623	2	_aper
are	3	78	7457	2	_are_
area	4	58	4339	2	_area
ares	4	58	7102	2	_ares
armer	7	69	2444	2	_armer
aver	7	59	3188	2	_aver
baker	11	56	2954	2	baker
baler	7	56	3527	2	baler
barber	10	44	1932	2	barber
bare	6	54	6052	2	bare_
bared	8	51	4448	2	bared
bares	7	54	5713	2	bares
barker	12	48	2286	2	barker
barre	7	59	2954	2	barre
barter	8	55	2537	2	barter
baser	7	48	2892	2	baser
bearer	8	53	2391	2	bearer
borer	7	51	3127	2	borer
caber	9	51	2683	2	caber
cager	8	52	2922	2	cager
caner	7	53	3477	2	caner
caper	9	48	3162	2	caper
carder	9	45	2418	2	carder
care	6	69	6837	2	care_
cared	8	60	5009	2	cared
career	8	58	2224	2	career
carers	8	51	3396	2	carers
cares	7	73	6918	2	cares
caret	7	53	6056	2	caret
carex	14	48	2230	2	carex
carper	10	49	2363	2	carper
carr	6	54	3470	2	car_r
carter	8	49	3227	2	carter
carver	11	44	2015	2	carver
cater	7	48	4072	2	cater
caver	10	56	2906	2	caver
corer	7	55	3887	2	corer
curer	7	50	3075	2	curer
dare	5	58	4886	2	dare_
dared	7	59	3501	2	dared
darers	7	59	2187	2	darers
dares	6	61	4670	2	dares
darker	11	47	1869	2	darker
darner	7	40	1730	2	darner
darter	7	53	2036	2	darter
dater	6	53	3231	2	dater
dearer	7	48	2280	2	dearer
direr	6	49	2707	2	direr
eager	6	55	2697	2	eager
eared	6	51	3950	2	eared
earner	6	36	1722	2	earner
eater	5	46	3984	2	eater
fabber	13	48	1411	2	fabber
fabler	11	61	1581	2	fabler
face	9	61	4012	2	face_
faced	11	77	2765	2	faced
facers	11	55	1944	2	facers
faces	10	64	3943	2	faces
facet	10	60	3852	2	facet
fade	8	57	3634	2	fade_
faded	10	50	2524	2	faded
faders	10	51	1746	2	faders
fades	9	49	3286	2	fades
faery	11	60	1548	2	faery
fainer	9	47	1724	2	fainer
fair	7	63	3252	2	fa_ir
faired	10	59	1577	2	faired
fake	11	55	3494	2	fake_
faked	13	52	2548	2	faked
fakeer	13	37	874	2	fakeer
fakers	13	42	1953	2	fakers
fakery	16	50	926	2	fakery
fakes	12	60	3248	2	fakes
fakey	15	55	1542	2	fakey
fakir	12	51	1149	2	fakir
faller	9	46	2123	2	faller
falser	9	39	1241	2	falser
falter	9	45	1905	2	falter
fame	9	56	3939	2	fame_
famed	11	59	2834	2	famed
fames	10	57	3592	2	fames
fane	7	53	4357	2	fane_
fanes	8	46	3989	2	fanes
fanner	9	42	1818	2	fanner
faqir	17	54	864	2	faqir
far	6	77	6260	2	fa__r
farad	9	57	2067	2	farad
farce	10	49	2532	2	farce
farced	12	52	1653	2	farced
farcers	12	47	1344	2	farcers
farces	11	52	2332	2	farces
farceur	12	52	527	2	farceur
farci	10	59	1931	2	farci
farcy	13	52	1709	2	farcy
fard	8	56	3906	2	far_d
farded	11	45	1895	2	farded
fardel	10	47	1259	2	fardel
fards	9	66	2984	2	fards
farfel	12	43	1043	2	farfel
farl	7	63	3855	2	far_l
farle	8	69	2924	2	farle
farles	9	60	2578	2	farles
farls	8	57	3111	2	farls
farm	9	59	3453	2	far_m
farmed	12	51	1765	2	farmed
farmers	12	43	1526	2	farmers
farms	10	63	2495	2	farms
faro	7	61	3692	2	far_o
faros	8	55	3202	2	faros
farrier	10	35	1489	2	farrier
fart	7	68	6056	2	far_t
farted	10	51	2178	2	farted
farther	13	4	834	2	farther
farts	8	83	3684	2	farts
faster	9	46	2577	2	faster
fate	7	54	4428	2	fate_
fated	9	56	3213	2	fated
fates	8	51	3923	2	fates
father	12	51	1671	2	father
fatter	9	45	2321	2	fatter
fave	10	55	3296	2	fave_
faves	11	53	3142	2	faves
favor	11	47	1245	2	favor
favorer	13	5	588	2	favorer
fawner	12	59	1046	2	fawner
faxed	16	62	2053	2	faxed
faxes	15	57	2665	2	faxes
fayed	12	64	2215	2	fayed
faze	16	56	3004	2	faze_
fazed	18	62	2296	2	fazed
fazes	17	55	2721	2	fazes
feared	10	63	2043	2	feared
fearers	10	48	1527	2	fearers
feater	9	52	2405	2	feater
fer	6	66	4612	2	f__er
fere	7	63	4223	2	fere_
feres	8	60	3818	2	feres
fever	11	56	1795	2	fever
fewer	11	52	1612	2	fewer
feyer	11	50	1452	2	feyer
fiber	10	49	2113	2	fiber
fifer	11	55	1997	2	fifer
filer	8	54	3300	2	filer
finer	8	54	3156	2	finer
fire	7	62	4559	2	fire_
fired	9	48	2974	2	fired
firers	9	49	2268	2	firers
fires	8	57	4075	2	fires
firmer	11	47	1244	2	firmer
fiver	11	60	2494	2	fiver
fixer	15	47	1783	2	fixer
flaker	13	49	1617	2	flaker
flamer	11	49	1912	2	flamer
flare	8	48	2363	2	flare_
flared	10	53	1760	2	flared
flares	9	45	2170	2	flares
flayer	12	47	1356	2	flayer
fleer	8	60	2077	2	fleer
flier	8	60	2340	2	flier
flyer	11	49	1625	2	flyer
foamer	11	47	1431	2	foamer
forcer	11	49	1734	2	forcer
fore	7	83	5147	2	fore_
fores	8	58	4710	2	fores
forger	10	48	2077	2	forger
forker	13	47	1790	2	forker
former	11	42	2140	2	former
foyer	11	64	1655	2	foyer
frae	7	53	3047	2	frae_
framer	11	48	1744	2	framer
frater	9	45	2059	2	frater
free	7	59	4018	2	f_ree
freer	8	60	2124	2	freer
frere	8	56	1772	2	f_rere
fret	7	58	4504	2	f_ret
frier	8	52	2584	2	frier
fryer	11	59	1343	2	fryer
fuhrer	12	3	503	2	fuhrer
fumer	10	59	1823	2	fumer
furler	9	36	1640	2	furler
furor	8	3	1239	2	furor
gager	7	47	2629	2	gager
gamer	8	49	2894	2	gamer
gaper	8	61	2512	2	gaper
garner	7	39	1700	2	garner
garter	7	44	2051	2	garter
gater	6	45	3365	2	gater
gayer	9	45	1919	2	gayer
gazer	15	57	2007	2	gazer
haler	8	50	3352	2	haler
harder	10	50	2240	2	harder
hare	7	62	5573	2	hare_
hared	9	57	4218	2	hared
harem	10	49	2445	2	harem
hares	8	62	5554	2	hares
harmer	11	47	1955	2	harmer
harper	11	50	1840	2	harper
hater	8	50	3475	2	hater
haver	11	51	2446	2	haver
hayer	11	46	2024	2	hayer
hazer	17	48	2023	2	hazer
hearer	9	43	2364	2	hearer
hirer	8	54	2312	2	hirer
jager	13	43	1813	2	jager
japer	14	62	1888	2	japer
lacer	7	58	3375	2	lacer
lader	6	56	3372	2	lader
lager	6	51	3286	2	lager
laker	9	54	3287	2	laker
lamer	7	52	3370	2	lamer
larder	7	37	2097	2	larder
laree	5	60	3629	2	laree
lares	5	48	5263	2	lares
larger	7	44	1751	2	larger
larker	10	45	1924	2	larker
laser	5	46	3332	2	laser
later	5	48	4392	2	later
laver	8	50	3179	2	laver
laxer	12	54	2033	2	laxer
layer	8	46	2647	2	layer
lurer	5	46	2531	2	lurer
macer	9	121	2694	2	macer
maker	11	41	2781	2	maker
mare	6	47	5933	2	mare_
mares	7	64	5763	2	mares
marker	12	44	2039	2	marker
marrer	8	37	1667	2	marrer
maser	7	50	2997	2	maser
mater	7	44	3886	2	mater
mazer	16	57	2242	2	mazer
merer	7	51	2623	2	merer
namer	7	56	2210	2	namer
nares	5	55	4415	2	nares
nearer	6	46	1889	2	nearer
oared	6	50	3065	2	oared
oater	5	54	3373	2	oater
pacer	9	61	3161	2	pacer
pager	8	47	2820	2	pager
paler	7	54	3693	2	paler
paper	9	51	2866	2	paper
pare	6	67	6084	2	pare_
pared	8	69	4676	2	pared
pareo	7	46	3260	2	pareo
parers	8	55	3074	2	parers
pares	7	71	6448	2	pares
pareu	7	49	2874	2	pareu
parker	12	41	2137	2	parker
parr	6	57	3115	2	par_r
parser	8	48	2237	2	parser
pater	7	47	4072	2	pater
paver	10	42	2583	2	paver
pawer	10	44	2297	2	pawer
payer	10	51	2572	2	payer
purer	7	51	2790	2	purer
racer	7	52	3302	2	racer
raker	9	45	2979	2	raker
raper	7	49	3275	2	raper
rare	4	53	4843	2	rare_
rared	6	57	3832	2	rared
rares	5	52	4744	2	rares
raser	5	56	3341	2	raser
rater	5	49	4328	2	rater
raver	8	56	3149	2	raver
rawer	8	46	2373	2	rawer
razer	14	48	2427	2	razer
rearer	6	49	2891	2	rearer
roarer	6	39	1433	2	roarer
saber	7	53	3024	2	saber
safer	8	47	2181	2	safer
sager	6	54	3205	2	sager
saker	9	51	3202	2	saker
saner	5	43	3432	2	saner
saree	5	50	4466	2	saree
saver	8	48	3125	2	saver
sawer	8	50	2621	2	sawer
sayer	8	49	2655	2	sayer
scarer	8	45	2461	2	scarer
searer	6	54	3202	2	searer
serer	5	59	3551	2	serer
sharer	9	50	2548	2	sharer
snarer	6	46	2084	2	snarer
soarer	6	45	2224	2	soarer
sorer	5	62	3659	2	sorer
sparer	8	45	2496	2	sparer
starer	6	40	2736	2	starer
surer	5	48	3310	2	surer
taber	7	38	2582	2	taber
taker	9	52	2900	2	taker
taler	5	60	3486	2	taler
tamer	7	52	3010	2	tamer
taper	7	48	2977	2	taper
tare	4	59	5762	2	tare_
tared	6	93	4005	2	tared
tares	5	74	5656	2	tares
tarre	5	58	2563	2	tarre
tarter	6	40	2356	2	tarter
tater	5	41	3861	2	tater
tawer	8	52	2344	2	tawer
taxer	12	50	1936	2	taxer
tearer	6	48	2290	2	tearer
varier	9	46	1935	2	varier
wader	9	53	2536	2	wader
wafer	11	44	1764	2	wafer
wager	9	59	2505	2	wager
waker	12	55	2659	2	waker
waler	8	42	2926	2	waler
warder	10	40	2027	2	warder
ware	7	62	5472	2	ware_
wared	9	63	3987	2	wared
wares	8	82	5058	2	wares
warier	9	37	2289	2	warier
warmer	11	38	1673	2	warmer
warner	9	37	1722	2	warner
warper	11	40	1558	2	warper
water	8	47	3331	2	water
waver	11	50	2570	2	waver
waxer	15	43	1748	2	waxer
wearer	9	43	1940	2	wearer
wirer	8	51	2495	2	wirer
yager	9	56	1675	2	yager
yarder	10	38	1397	2	yarder
yare	7	56	3694	2	yare_
yarner	9	33	1306	2	yarner

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	53800	0.313	570897.8
2	DLD Change Limit	53800	345	1.640	32804.9
3	Display Results	345	345	0.110	3136.4
	(SQL Overall)	178691	345	2.063	86617.1