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

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

134 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
pharmings	17	25	472	(None)
pharming	16	24	814	1	pharming_
armings	10	38	1150	2	__armings
charming	16	30	1203	2	charming_
farmings	14	29	822	2	_farmings
harmines	13	27	1514	2	_harmines
harming	13	37	1793	2	_harming_
harmins	12	37	1672	2	_harmin_s
harpings	14	37	977	2	_harpings
pargings	12	34	1016	2	p_argings
parings	10	42	1921	2	p_ar_ings
parkings	15	36	1068	2	p_arkings
partings	11	35	1373	2	p_artings
phrasings	15	4	433	2	phrasings
alarming	11	3	858	3	alarming_
arming	9	47	1980	3	__arming_
bearings	11	39	1225	3	bear_ings
boardings	13	29	606	3	boardings
cardings	12	38	1263	3	_cardings
carlings	11	40	1585	3	_carlings
carmines	12	36	1786	3	_carmines
carpings	13	38	1238	3	_carpings
carvings	14	38	1020	3	_carvings
charging	15	29	1077	3	charging_
charing	13	37	2132	3	char_ing_
charking	18	35	1261	3	charking_
charminger	18	4	308	3	charminger
charmingest	19	5	311	3	charmingest
charmingly	21	4	341	3	charmingly
charring	14	29	1316	3	charring_
charting	14	26	1419	3	charting_
chasings	14	31	825	3	cha_sings
chirming	16	31	864	3	chirming_
chromings	17	28	609	3	chromings
churnings	15	23	340	3	churnings
coamings	13	34	929	3	coa_mings
darings	9	37	1365	3	_dar_ings
darlings	10	37	1038	3	_darlings
darnings	10	37	855	3	_darnings
earings	8	45	1771	3	_ear_ings
earnings	9	41	933	3	_earnings
earrings	9	29	963	3	_earrings
farming	13	35	1508	3	_farming_
framings	14	33	813	3	fra_mings
gamings	11	46	1091	3	_ga_mings
gearings	10	35	950	3	gear_ings
haemins	12	28	1140	3	_haemin_s
hamming	15	30	1409	3	_hamming_
hangings	13	25	858	3	_hangings
haring	10	42	3300	3	_har_ing_
harking	15	41	2094	3	_harking_
harmin	11	31	1739	3	_harmin__
harmine	12	28	1619	3	_harmin_e
harping	13	41	1838	3	_harping_
harpins	12	36	1570	3	_harpin_s
hawkings	19	33	613	3	_hawkings
hayings	14	37	939	3	_ha_yings
hazings	20	37	834	3	_ha_zings
hearings	12	36	1185	3	hear_ings
herrings	12	37	953	3	_herrings
hoardings	14	31	511	3	hoardings
hornings	12	23	836	3	_hornings
hurlings	12	38	821	3	_hurlings
inarming	11	3	834	3	inarming_
kartings	13	41	852	3	_kartings
learnings	10	9	432	3	learnings
markings	15	34	1024	3	_markings
marlings	11	37	1349	3	_marlings
packings	17	43	1006	3	p_ackings
paddings	13	29	701	3	p_addings
pagings	11	44	1106	3	p_a_gings
pairings	11	39	831	3	p_airings
palings	10	39	1582	3	p_a_lings
palming	12	39	1401	3	p_alming_
parangs	10	43	1437	3	p_ar_angs
parawings	15	3	582	3	p_arawings
parging	11	33	1860	3	p_arging_
paring	9	42	3649	3	p_ar_ing_
parking	14	34	2304	3	p_arking_
parling	10	38	2376	3	p_arling_
parring	10	32	2206	3	p_arring_
parsing	10	38	1955	3	p_arsing_
parting	10	35	2738	3	p_arting_
passings	11	40	987	3	p_assings
pavings	13	40	1163	3	p_a_vings
pearling	11	9	1201	3	pearling_
pearmains	13	4	526	3	pearmain_s
perming	12	34	1609	3	p_erming_
pharynges	18	4	288	3	phar_ynges
phasing	13	32	1167	3	pha_sing_
phasmids	16	19	518	3	phasmi_ds
phrasing	14	3	801	3	phrasing_
piercings	14	5	326	3	piercings
plaitings	12	29	624	3	plaitings
plankings	16	32	611	3	plankings
plannings	12	32	545	3	plannings
plantings	12	34	840	3	plantings
plasmins	12	19	941	3	plasmin_s
platings	11	36	1136	3	pla_tings
prearming	14	13	922	3	prearming_
primings	13	33	814	3	p_rimings
psalming	13	7	547	3	psalming_
purgings	12	34	729	3	p_urgings
purlings	11	39	1028	3	p_urlings
rearming	11	14	1361	3	rearming_
roarings	9	24	829	3	roar_ings
shadings	13	32	743	3	sha_dings
shaftings	16	22	418	3	shaftings
shaming	13	30	1674	3	sha_ming_
shamming	16	28	941	3	shamming_
sharing	11	37	2324	3	shar_ing_
sharking	16	39	1297	3	sharking_
sharping	14	30	1137	3	sharping_
shavings	15	35	633	3	sha_vings
shearings	13	33	756	3	shear_ings
shearlings	14	4	353	3	shearlings
shirrings	13	24	532	3	shirrings
shirtings	13	27	660	3	shirtings
shorings	12	26	948	3	shor_ings
slammings	14	23	412	3	slammings
soarings	9	32	1039	3	soar_ings
sparlings	12	25	715	3	sparlings
spearmints	14	4	300	3	spearmints
starlings	10	23	792	3	starlings
swarming	14	5	822	3	swarming_
unarming	11	3	862	3	unarming_
varmints	13	3	564	3	_varmints
warming	13	35	1508	3	_warming_
warnings	12	35	845	3	_warnings
whalings	15	25	676	3	wha_lings
whamming	19	27	522	3	whamming_
wharfing	18	3	468	3	wharfing_
yearlings	13	8	420	3	yearlings
yearnings	13	9	355	3	yearnings

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	148641	0.423	422437.4
2	DLD Change Limit	148641	134	6.296	23608.8
3	Display Results	134	134	0.063	2127.0
	(SQL Overall)	178691	134	6.782	26347.8