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

Here are the results of your fuzzy-string dictionary search for “hexers” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

100 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
hexers	16	56	1275	(None)
heders	10	41	1976	1	heders
hewers	12	37	1527	1	hewers
hexer	15	51	1668	1	hexer_
hexes	15	51	2304	1	hexe_s
vexers	16	52	1040	1	vexers
beers	7	56	2839	2	be_ers
boxers	15	50	1348	2	boxers
ceders	9	38	1767	2	ceders
cheders	13	45	1239	2	cheders
cheers	11	45	1891	2	che_ers
chewers	15	41	1114	2	chewers
deers	6	49	3052	2	de_ers
defers	10	51	1694	2	defers
deters	7	47	2468	2	deters
dexes	13	52	2451	2	dexe_s
egers	6	51	2037	2	_egers
ewers	8	60	1882	2	_ewers
execs	14	53	972	2	_execs
exert	12	46	2414	2	_exert
exerts	13	37	1229	2	_exerts
exes	11	65	3081	2	_exe_s
eyers	8	65	2133	2	_eyers
fevers	12	54	1489	2	fevers
fixers	16	51	1298	2	fixers
halers	9	49	2691	2	halers
haters	9	49	3040	2	haters
havers	12	47	2148	2	havers
hayers	12	44	1594	2	hayers
hazers	18	46	1595	2	hazers
headers	11	38	1939	2	headers
healers	10	43	1946	2	healers
heapers	12	36	1667	2	heapers
hearers	10	43	1978	2	hearers
hears	8	67	3737	2	he_ars
heaters	10	42	2522	2	heaters
heavers	13	37	1719	2	heavers
hebes	10	55	2167	2	hebe_s
heder	9	56	2364	2	heder_
hedgers	12	43	1026	2	hedgers
heeders	11	42	1374	2	heeders
heeds	9	54	2042	2	he_eds
heelers	10	38	1562	2	heelers
heels	8	56	2553	2	he_els
hefters	13	43	1200	2	hefters
heifers	13	3	793	2	heifers
heirs	8	56	1856	2	he_irs
hellers	10	36	1983	2	hellers
helpers	12	33	1185	2	helpers
hemes	10	50	3108	2	heme_s
hemmers	14	33	1084	2	hemmers
herders	11	39	1412	2	herders
heres	8	62	4590	2	here_s
hers	7	58	4487	2	h__ers
hetero	9	3	1263	2	hetero
heteros	10	3	1268	2	heteros
hewer	11	57	1993	2	hewer_
hexads	17	46	819	2	hexads
hexed	16	56	1576	2	hexe_d
hexerei	17	6	416	2	hexerei
hexereis	18	9	480	2	hexereis
hexyls	19	3	343	2	hexyls
hiders	10	49	1965	2	hiders
hikers	13	50	1435	2	hikers
hirers	9	45	1806	2	hirers
hoaxers	17	32	713	2	hoaxers
hoers	8	57	2492	2	h_oers
homers	11	48	2197	2	homers
honers	9	43	2497	2	honers
hopers	11	42	2297	2	hopers
hosers	9	52	2396	2	hosers
hovers	12	43	2025	2	hovers
hypers	14	48	1191	2	hypers
jeers	12	48	1813	2	je_ers
kexes	16	62	1682	2	kexe_s
leers	5	48	2898	2	le_ers
legers	7	45	1831	2	legers
lepers	8	48	1732	2	lepers
levers	9	46	2132	2	levers
lexes	12	72	2526	2	lexe_s
meters	8	56	2583	2	meters
mixers	15	45	1356	2	mixers
peers	7	51	3027	2	pe_ers
peters	8	66	2459	2	peters
refers	9	39	2108	2	refers
revers	9	45	2963	2	revers
rexes	12	45	2695	2	rexe_s
seders	7	44	2028	2	seders
seers	5	51	3638	2	se_ers
severs	9	41	2112	2	severs
sewers	9	47	1972	2	sewers
sexes	12	61	2622	2	sexe_s
sheers	9	43	2240	2	she_ers
shewers	13	43	1205	2	shewers
taxers	13	40	1528	2	taxers
veers	8	45	2136	2	ve_ers
vexer	15	55	1352	2	vexer_
vexes	15	57	1912	2	vexe_s
waxers	16	40	1430	2	waxers
webers	11	3	1094	2	webers

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.343	520965.0
2	DLD Change Limit	82551	100	2.156	38289.0
3	Display Results	100	100	0.033	3030.3
	(SQL Overall)	178691	100	2.532	70573.1