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

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

125 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
hashing	14	50	2016	(None)
ashing	10	78	2409	1	_ashing
bashing	13	54	2258	1	bashing
cashing	13	50	2255	1	cashing
dashing	12	59	1789	1	dashing
fashing	14	49	1879	1	fashing
gashing	12	51	1923	1	gashing
hasping	13	44	1490	1	hasping
hasting	11	47	2519	1	hasting
hushing	14	45	1447	1	hushing
lashing	11	44	2289	1	lashing
mashing	13	44	2224	1	mashing
pashing	13	51	2051	1	pashing
sashing	11	46	2147	1	sashing
washing	14	51	1928	1	washing
aahing	10	190	1576	2	_aahing
abashing	14	6	662	2	abashing
aching	12	65	2197	2	_aching
ahing	9	89	2835	2	_a_hing
asking	11	60	1723	2	_asking
baching	15	60	1775	2	baching
bashings	14	43	1124	2	bashings
basing	9	54	2766	2	bas_ing
basking	14	47	1861	2	basking
basting	10	42	2720	2	basting
bathing	13	48	1624	2	bathing
bushing	13	40	1858	2	bushing
caching	15	63	1750	2	caching
casing	9	48	2910	2	cas_ing
casking	14	43	1735	2	casking
casting	10	46	2834	2	casting
chasing	13	37	1589	2	chas_ing
clashing	14	38	1219	2	clashing
coshing	13	43	1643	2	coshing
crashing	14	35	1263	2	crashing
deashing	13	42	1095	2	deashing
dishing	12	40	1710	2	dishing
easing	7	49	2646	2	eas_ing
easting	8	49	2430	2	easting
fasting	11	45	2283	2	fasting
fishing	14	39	1386	2	fishing
flashing	15	37	1155	2	flashing
gasking	13	44	1591	2	gasking
gasping	11	37	1436	2	gasping
gassing	9	42	1633	2	gassing
gasting	9	50	2276	2	gasting
gnashing	13	3	642	2	gnashing
gushing	12	40	1422	2	gushing
hacking	17	37	2061	2	hacking
hading	11	39	2294	2	ha_ding
haeing	10	41	1892	2	ha_eing
hafting	14	40	1417	2	hafting
hagging	13	31	1468	2	hagging
hailing	11	38	2069	2	hailing
haling	10	42	2978	2	ha_ling
haloing	11	38	1413	2	haloing
halting	11	44	1907	2	halting
halving	14	35	1154	2	halving
hamming	15	30	1409	2	hamming
handing	12	35	1889	2	handing
hanging	12	35	1870	2	hanging
hanking	15	46	1910	2	hanking
hanting	11	41	2448	2	hanting
happing	15	38	1723	2	happing
haring	10	42	3300	2	ha_ring
harking	15	41	2094	2	harking
harming	13	37	1793	2	harming
harping	13	41	1838	2	harping
hashish	12	3	835	2	hashish
hassling	12	3	680	2	hassling
hatching	17	33	1221	2	hatching
hating	10	49	2971	2	ha_ting
hatting	11	39	2023	2	hatting
hauling	11	37	1443	2	hauling
having	13	42	2037	2	ha_ving
hawing	13	43	2235	2	ha_wing
hawking	18	37	1142	2	hawking
haying	13	44	2061	2	ha_ying
hazing	19	42	1855	2	ha_zing
hissing	11	42	1314	2	hissing
histing	11	37	2037	2	histing
hosing	10	34	2110	2	hos_ing
hosting	11	43	1838	2	hosting
husking	15	43	1205	2	husking
joshing	18	51	941	2	joshing
lashings	12	44	1225	2	lashings
lashins	10	39	1515	2	lashins
lasing	7	47	2798	2	las_ing
lasting	8	47	2524	2	lasting
lathing	11	43	1569	2	lathing
leashing	12	33	1031	2	leashing
lushing	11	43	1611	2	lushing
masking	14	51	1661	2	masking
massing	10	43	1802	2	massing
masting	10	43	2582	2	masting
meshing	13	45	1381	2	meshing
moshing	13	42	1488	2	moshing
mushing	13	42	1763	2	mushing
noshing	11	46	1277	2	noshing
passing	10	43	1842	2	passing
pasting	10	38	2655	2	pasting
phasing	13	32	1167	2	phas_ing
pishing	13	43	1437	2	pishing
plashing	14	33	1106	2	plashing
pushing	13	36	1545	2	pushing
quashing	21	3	709	2	quashing
rasing	7	43	3083	2	ras_ing
rasping	10	43	1625	2	rasping
rehashing	16	4	711	2	rehashing
rushing	11	38	1770	2	rushing
sassing	8	46	1555	2	sassing
shushing	15	31	774	2	shushing
slashing	12	37	1341	2	slashing
smashing	14	33	1024	2	smashing
stashing	12	35	1158	2	stashing
swashing	15	36	974	2	swashing
tasking	12	46	1632	2	tasking
tasting	8	46	2421	2	tasting
thrashing	16	3	568	2	thrashing
trashing	12	26	1322	2	trashing
tushing	11	42	1401	2	tushing
washings	15	41	927	2	washings
wasting	11	44	2284	2	wasting
whishing	18	28	718	2	whishing
wishing	14	41	1489	2	wishing

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	125	3.050	35302.0
3	Display Results	125	125	0.043	2907.0
	(SQL Overall)	178691	125	3.466	51555.4