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

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

145 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
farthings	16	3	523	(None)
farthing	15	3	807	1	farthing_
archings	14	49	986	2	_archings
birthings	15	25	462	2	birthings
earthing	12	3	1033	2	earthing_
earthlings	14	4	361	2	earthlings
faithing	15	3	715	2	faithing_
farmings	14	29	822	2	far_mings
farting	11	41	2075	2	fart_ing_
fastings	12	40	1194	2	fast_ings
fatlings	12	35	930	2	fa_tlings
kartings	13	41	852	2	kart_ings
lathings	12	46	985	2	la_things
naethings	13	4	387	2	naethings
northings	13	18	557	2	northings
partings	11	35	1373	2	part_ings
actings	10	45	1246	3	_act_ings
airthing	12	29	795	3	airthing_
antings	8	50	1558	3	_ant_ings
anythings	16	4	259	3	anythings
archines	13	38	1525	3	_archines
arching	13	62	1669	3	_arching_
armings	10	38	1150	3	_ar_mings
arshins	10	3	1257	3	_arshin_s
bantlings	12	21	660	3	bantlings
bashings	14	43	1124	3	ba_shings
bastings	11	42	1469	3	bast_ings
bathing	13	48	1624	3	ba_thing_
battings	11	40	1057	3	ba_ttings
berthing	14	20	960	3	berthing_
birthing	14	33	843	3	birthing_
cardings	12	38	1264	3	car_dings
carlings	11	40	1586	3	car_lings
carpings	13	38	1239	3	car_pings
carting	10	42	2828	3	cart_ing_
carvings	14	38	1021	3	car_vings
castings	11	36	1405	3	cast_ings
catlings	11	37	1204	3	ca_tlings
clothings	15	26	443	3	clothings
darings	9	37	1365	3	dar__ings
darklings	15	3	398	3	darklings
darlings	10	37	1038	3	dar_lings
darnings	10	37	855	3	dar_nings
darting	9	40	2066	3	dart_ing_
dartling	10	3	956	3	dartling_
earings	8	45	1771	3	ear__ings
earnings	9	41	933	3	ear_nings
earrings	9	29	963	3	ear_rings
earthiness	13	7	724	3	earthiness
earthling	13	4	619	3	earthling_
eastings	9	34	1295	3	east_ings
eatings	8	46	1644	3	ea_t_ings
facings	13	45	1126	3	fa__cings
fadings	12	46	930	3	fa__dings
fagotings	14	4	315	3	fagotings
failings	12	38	1101	3	fa_ilings
fairings	12	38	819	3	fa_irings
farcing	13	35	1400	3	far_cing_
farding	12	37	1674	3	far_ding_
farinas	10	32	1524	3	far__inas
faring	10	52	3128	3	far__ing_
farmhands	18	4	335	3	farmhands
farming	13	35	1508	3	far_ming_
farthingale	18	5	101	3	farthingale
farthingales	19	6	108	3	farthing~~ale~~s
fashing	14	49	1879	3	fa_shing_
fastenings	14	27	390	3	fastenings
fasting	11	45	2283	3	fast_ing_
fating	10	53	2867	3	fa_t_ing_
fatling	11	38	1568	3	fa_tling_
fatting	11	38	1870	3	fa_tting_
feltings	12	31	790	3	felt_ings
fettlings	13	5	375	3	fettlings
fightings	17	27	650	3	fightings
firings	11	41	1233	3	fir__ings
firstlings	14	4	252	3	firstlings
fishings	15	30	769	3	f_ishings
fittings	12	31	820	3	f_ittings
flashings	16	31	666	3	flashings
flatlings	13	31	582	3	flatlings
fleshings	16	33	538	3	fleshings
fletchings	19	28	286	3	fletchings
flutings	12	35	737	3	flut_ings
flytings	15	30	479	3	flyt_ings
footings	12	24	883	3	foot_ings
forewings	16	4	511	3	forewings
forgings	13	28	770	3	for_gings
fraggings	15	32	424	3	fraggings
framings	14	33	813	3	f_ramings
frayings	15	32	599	3	f_rayings
frothing	15	20	853	3	frothing_
furrings	12	31	714	3	fur_rings
gatings	9	52	1282	3	ga_t_ings
girthing	13	25	608	3	girthing_
gratings	10	39	1076	3	grat_ings
harpings	14	37	977	3	har_pings
hatchings	18	22	567	3	hatchings
karting	12	37	1606	3	kart_ing_
lashings	12	44	1225	3	la_shings
lastings	9	42	1442	3	last_ings
lathing	11	43	1569	3	la_thing_
laughings	14	4	348	3	laughings
loathings	13	4	421	3	loathings
mantlings	12	20	723	3	mantlings
marblings	14	22	554	3	marblings
marching	16	43	1219	3	marching_
markings	15	34	1024	3	mar_kings
marlings	11	37	1349	3	mar_lings
marting	10	33	2501	3	mart_ing_
martinis	10	33	1161	3	mart_inis
martins	9	33	2206	3	mart_in_s
matings	10	45	1621	3	ma_t_ings
mattings	11	36	967	3	ma_ttings
morphings	17	4	468	3	morphings
naething	12	3	607	3	naething_
northing	12	19	906	3	northing_
nothings	12	26	668	3	_nothings
parawings	15	3	582	3	parawings
parching	16	43	1305	3	parching_
pargings	12	34	1016	3	par_gings
parings	10	42	1921	3	par__ings
parkings	15	36	1068	3	par_kings
parting	10	35	2738	3	part_ing_
partying	14	16	889	3	partying_
playthings	19	4	236	3	playthings
ratings	8	42	1741	3	ra_t_ings
rattlings	10	23	551	3	rattlings
saltings	9	28	1125	3	salt_ings
southings	13	24	623	3	southings
tarting	8	42	2265	3	tart_ing_
tattings	9	40	882	3	ta_ttings
teethings	13	4	423	3	teethings
things	10	49	1430	3	___things
tithings	12	32	769	3	_tithings
trithings	13	24	660	3	trithings
turtlings	10	18	487	3	turtlings
waitings	12	34	1374	3	wait_ings
warnings	12	35	845	3	war_nings
warthogs	15	4	483	3	warth_ogs
washings	15	41	927	3	wa_shings
worthing	15	17	805	3	worthing_
wrathing	15	24	892	3	wrathing_
xanthines	19	6	672	3	xanthines
xanthins	18	4	694	3	xanthin_s
yachtings	18	4	266	3	yachtings

Search took 8 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	148641	0.423	422437.4
2	DLD Change Limit	148641	145	6.530	22762.8
3	Display Results	145	145	0.063	2301.6
	(SQL Overall)	178691	145	7.016	25469.1