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

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

205 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
hanked	14	42	2060	(None)
banked	13	50	2144	1	banked
hacked	16	49	2351	1	hacked
handed	11	49	1998	1	handed
hanged	11	42	2239	1	hanged
hanker	13	46	2209	1	hanker
hanted	10	41	2431	1	hanted
harked	14	54	2255	1	harked
hawked	17	47	1267	1	hawked
honked	14	45	1791	1	honked
ranked	11	46	2074	1	ranked
shanked	15	32	1212	1	shanked
tanked	11	39	1929	1	tanked
thanked	15	46	915	1	thanked
wanked	14	45	1715	1	wanked
yanked	14	43	1224	1	yanked
ankled	11	43	1347	2	_ankled
anted	6	63	2824	2	_anted
asked	10	69	1931	2	_asked
backed	15	57	2572	2	backed
baked	12	61	3077	2	ba_ked
balked	13	52	1941	2	balked
banded	10	52	2317	2	banded
baned	8	54	3635	2	ban_ed
banged	10	49	2372	2	banged
banker	12	42	2273	2	banker
banned	9	47	2134	2	banned
barked	13	50	2731	2	barked
basked	13	52	1860	2	basked
blanked	14	40	1122	2	blanked
bonked	13	55	1731	2	bonked
bunked	13	51	1837	2	bunked
caked	12	61	2862	2	ca_ked
calked	13	46	1740	2	calked
caned	8	58	3809	2	can_ed
canker	12	44	2252	2	canker
canned	9	50	2206	2	canned
canoed	9	46	1895	2	canoed
canted	9	48	2578	2	canted
carked	13	40	2482	2	carked
casked	13	48	1551	2	casked
chalked	17	44	986	2	chalked
chanced	15	41	1321	2	chanced
changed	14	42	1414	2	changed
chanted	13	40	1595	2	chanted
charked	17	48	1401	2	charked
chinked	17	40	1102	2	chinked
chunked	17	42	821	2	chunked
clanked	14	38	1225	2	clanked
conked	13	50	1911	2	conked
cranked	14	38	1284	2	cranked
danced	10	53	1525	2	danced
danged	9	48	1948	2	danged
danker	11	43	1966	2	danker
darked	12	39	1963	2	darked
dinked	12	48	1835	2	dinked
dunked	12	43	1528	2	dunked
faked	13	52	2548	2	fa_ked
fanged	11	43	1822	2	fanged
fanned	10	41	1747	2	fanned
finked	14	42	1462	2	finked
flanked	15	37	1064	2	flanked
franked	15	36	1005	2	franked
funked	14	42	1411	2	funked
ganged	9	46	1919	2	ganged
gawked	15	46	876	2	gawked
hackee	15	49	2183	2	hackee
hacker	15	48	2269	2	hacker
hackled	17	33	1248	2	hackled
haded	10	52	2762	2	ha_ded
haed	8	63	3858	2	ha__ed
hafted	13	47	1383	2	hafted
hagged	12	43	1770	2	hagged
hailed	10	41	2274	2	hailed
haired	10	51	1717	2	haired
hake	11	56	3784	2	ha_ke_
hakes	12	60	3430	2	ha_kes
haled	9	53	3582	2	ha_led
haloed	10	47	1760	2	haloed
halted	10	50	1960	2	halted
halved	13	48	1390	2	halved
hammed	14	41	1697	2	hammed
hance	10	54	2415	2	hance_
hances	11	56	2128	2	hances
hand	8	68	3370	2	han__d
hander	10	45	2643	2	hander
handled	12	41	1453	2	handled
hanger	10	40	2325	2	hanger
hank	11	51	3413	2	hank__
hankered	16	28	944	2	hankered
hankers	14	42	1813	2	hankers
hankie	13	39	1571	2	hankie
hankies	14	36	1776	2	hankies
hanks	12	62	2686	2	hank_s
hanky	15	54	1829	2	hank_y
hanse	8	57	2279	2	hanse_
hansel	9	52	1437	2	hansel
hanses	9	50	2263	2	hanses
happed	14	48	2010	2	happed
hared	9	57	4218	2	ha_red
harken	13	51	1634	2	harken
harmed	12	52	1883	2	harmed
harped	12	44	1840	2	harped
hashed	13	60	2194	2	hashed
hasped	12	50	1444	2	hasped
hasted	10	51	2528	2	hasted
hated	9	57	3402	2	ha_ted
hatred	10	48	1433	2	hatred
hatted	10	49	2151	2	hatted
hauled	10	44	1521	2	hauled
haunted	11	39	973	2	haunted
hawed	12	60	2542	2	ha_wed
hawker	16	48	1266	2	hawker
hawkey	19	50	763	2	hawkey
hayed	12	58	2201	2	ha_yed
hazed	18	52	2220	2	ha_zed
hented	10	42	1875	2	hented
hiked	13	59	1920	2	h_iked
hinged	11	46	1892	2	hinged
hinted	10	43	1832	2	hinted
hocked	16	55	2130	2	hocked
hoked	13	53	2699	2	h_oked
holked	14	49	1366	2	holked
honed	9	53	3226	2	hon_ed
honied	10	48	1839	2	honied
honker	13	41	1746	2	honker
honkey	16	51	1382	2	honkey
hooked	14	53	2055	2	hooked
howked	17	73	1234	2	howked
hulked	14	46	1130	2	hulked
hunker	13	39	1767	2	hunker
hunkey	16	42	1088	2	hunkey
hunted	10	44	1701	2	hunted
husked	14	42	1222	2	husked
inked	10	42	1852	2	_inked
jacked	20	48	1752	2	jacked
jauked	18	48	901	2	jauked
jinked	18	40	1314	2	jinked
junked	18	43	1169	2	junked
kinked	10	40	1475	2	kinked
konked	10	40	1058	2	konked
lacked	13	53	2465	2	lacked
laked	10	57	3112	2	la_ked
lanced	9	37	1772	2	lanced
landed	8	46	1924	2	landed
lanker	10	41	2300	2	lanker
larked	11	45	1947	2	larked
linked	11	45	1821	2	linked
maned	8	66	3409	2	man_ed
manned	9	44	1864	2	manned
marked	13	39	2162	2	marked
masked	13	43	1652	2	masked
naked	10	53	2085	2	na_ked
narked	11	41	1674	2	narked
oinked	11	42	1328	2	oinked
packed	15	48	2260	2	packed
paiked	13	51	1343	2	paiked
paned	8	54	3718	2	pan_ed
panged	10	47	2233	2	panged
panned	9	41	2343	2	panned
panted	9	50	2482	2	panted
parked	13	44	2513	2	parked
pinked	13	48	1988	2	pinked
planked	14	35	1228	2	planked
pranked	14	37	1209	2	pranked
racked	13	45	2608	2	racked
raked	10	58	3142	2	ra_ked
ranged	8	48	2431	2	ranged
ranker	10	50	2190	2	ranker
rankled	12	39	1065	2	rankled
ranted	7	43	2470	2	ranted
sacked	13	55	2521	2	sacked
sanded	8	49	2061	2	sanded
saned	6	56	3627	2	san_ed
shacked	17	40	1539	2	shacked
sharked	15	36	1390	2	sharked
skanked	11	33	810	2	skanked
snaked	11	50	1759	2	snaked
spanked	14	31	1172	2	spanked
swanked	15	35	954	2	swanked
tacked	13	47	2394	2	tacked
talked	11	40	1540	2	talked
tanged	8	46	2249	2	tanged
tanker	10	45	2112	2	tanker
tanned	7	52	1995	2	tanned
tasked	11	47	1464	2	tasked
thacked	17	38	1020	2	thacked
thanker	14	30	959	2	thanker
thunked	15	38	685	2	thunked
vaned	9	46	2242	2	van_ed
vanned	10	46	1448	2	vanned
waked	13	56	2675	2	wa_ked
walked	14	53	1378	2	walked
waned	9	58	3178	2	wan_ed
wanker	13	42	1997	2	wanker
wanned	10	43	1801	2	wanned
wanted	10	43	1972	2	wanted
warked	14	44	2121	2	warked
wauked	14	42	1057	2	wauked
whacked	20	45	862	2	whacked
whanged	15	44	761	2	whanged
winked	14	40	1860	2	winked
yacked	16	45	1679	2	yacked
yakked	13	36	609	2	yakked
zonked	20	42	947	2	zonked

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	82551	0.123	1452772.4
2	DLD Change Limit	82551	205	2.360	34979.2
3	Display Results	205	205	0.063	3254.0
	(SQL Overall)	178691	205	2.546	70185.0