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

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

113 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
harmers	12	41	1659	(None)
armers	8	55	2027	1	_armers
charmers	15	42	1133	1	charmers
farmers	12	43	1526	1	farmers
hammers	14	42	1606	1	hammers
harmer	11	47	1955	1	harmer_
harpers	12	49	1620	1	harpers
warmers	12	45	1429	1	warmers
aimers	8	46	2191	2	_aimers
armer	7	69	2444	2	_armer_
armets	8	49	1835	2	_armets
armors	8	50	1781	2	_armors
barbers	11	43	1750	2	barbers
barkers	13	43	1851	2	barkers
barters	9	42	2303	2	barters
carders	10	48	2035	2	carders
careers	9	52	1878	2	careers
carers	8	51	3396	2	car_ers
carpers	11	45	2125	2	carpers
carters	9	53	2725	2	carters
carvers	12	48	1754	2	carvers
chargers	14	40	1132	2	chargers
charmer	14	49	1366	2	charmer_
charters	13	41	1558	2	charters
dammers	12	32	1427	2	dammers
darers	7	59	2187	2	dar_ers
darners	8	38	1577	2	darners
darters	8	40	1760	2	darters
dormers	10	43	1392	2	dormers
earners	7	40	1645	2	earners
farcers	12	47	1344	2	farcers
farers	9	59	2405	2	far_ers
farmer	11	50	1737	2	farmer_
firmers	12	47	1144	2	firmers
formers	12	82	1795	2	formers
framers	12	51	1382	2	framers
gamers	9	44	2083	2	ga_mers
gammers	12	32	1456	2	gammers
garners	8	38	1598	2	garners
garters	8	42	1823	2	garters
hackers	16	46	1904	2	hackers
hafters	13	46	1433	2	hafters
hailers	10	40	1726	2	hailers
halers	9	49	2691	2	ha_lers
halters	10	46	1980	2	halters
halvers	13	33	1142	2	halvers
hames	10	61	3870	2	ha_me_s
hammer	13	81	2003	2	hammer_
hampers	14	36	1695	2	hampers
handers	11	42	2433	2	handers
hangers	11	31	2081	2	hangers
hankers	14	42	1813	2	hankers
harbors	12	4	1241	2	harbors
hardens	11	38	1502	2	hardens
harder	10	50	2240	2	harder_
hareems	12	42	820	2	hareems
harems	11	55	1382	2	har_ems
hares	8	62	5554	2	har_e_s
harkens	14	41	1286	2	harkens
harmed	12	52	1883	2	harme_d
harmins	12	37	1672	2	harmins
harmless	13	3	740	2	harmless
harms	10	68	2901	2	harm__s
harness	10	24	1393	2	harness
harper	11	50	1840	2	harper_
harriers	11	37	1243	2	harriers
haters	9	49	3040	2	ha_ters
hatters	10	42	2152	2	hatters
haulers	10	40	1244	2	haulers
havers	12	47	2148	2	ha_vers
hawkers	17	42	1033	2	hawkers
hawsers	13	40	948	2	hawsers
hayers	12	44	1594	2	ha_yers
hazers	18	46	1595	2	ha_zers
hearers	10	43	1978	2	hear_ers
hemmers	14	33	1084	2	hemmers
herders	11	39	1412	2	herders
hirers	9	45	1806	2	hir_ers
hoarders	12	30	743	2	hoarders
homers	11	48	2197	2	h_omers
hummers	14	38	1306	2	hummers
hurlers	10	37	1432	2	hurlers
hurters	10	34	1364	2	hurters
jammers	18	37	1070	2	jammers
larders	8	35	1694	2	larders
larkers	11	30	1451	2	larkers
maimers	11	38	1304	2	maimers
mammers	10	46	1569	2	mammers
markers	13	35	1610	2	markers
marrers	9	34	1431	2	marrers
namers	8	45	1733	2	na_mers
ormers	8	43	1614	2	_ormers
palmers	11	35	1362	2	palmers
parers	8	55	3074	2	par_ers
parkers	13	38	1687	2	parkers
parsers	9	41	1815	2	parsers
rammers	11	37	1504	2	rammers
shammers	15	37	1084	2	shammers
sharers	10	47	2062	2	shar_ers
sharkers	15	40	1105	2	sharkers
sharpers	13	38	1094	2	sharpers
swarmers	13	4	632	2	swarmers
tamers	8	42	2403	2	ta_mers
termers	9	54	1450	2	termers
variers	10	37	1266	2	variers
warders	11	34	1681	2	warders
warmer	11	38	1673	2	warmer_
warners	10	33	1556	2	warners
warpers	12	34	1358	2	warpers
wormers	12	40	1257	2	wormers
yammers	14	34	1032	2	yammers
yarders	11	32	1159	2	yarders
yarners	10	43	1220	2	yarners

Search took 4 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	107671	0.373	479064.3
2	DLD Change Limit	107671	113	3.283	32796.5
3	Display Results	113	113	0.030	3766.7
	(SQL Overall)	178691	113	3.686	48478.3