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

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

200 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
hander	10	45	2643	(None)
bander	9	39	2822	1	bander
dander	8	112	2299	1	dander
gander	8	43	2276	1	gander
handed	11	49	1998	1	handed
handers	11	42	2433	1	handers
handier	11	38	1744	1	handier
handler	11	35	1616	1	handler
hanger	10	40	2326	1	hanger
hanker	13	46	2209	1	hanker
harder	10	50	2240	1	harder
hinder	10	41	2006	1	hinder
lander	7	40	2849	1	lander
pander	9	37	2553	1	pander
sander	7	48	2853	1	sander
wander	10	44	2371	1	wander
zander	16	34	1711	1	zander
adder	7	54	1959	2	_adder
aider	6	54	3114	2	_aider
alder	6	54	2191	2	_alder
anger	6	62	2588	2	_anger
badder	10	38	1751	2	badder
balder	9	53	1886	2	balder
banded	10	52	2317	2	banded
banders	10	43	2456	2	banders
banger	9	44	2364	2	banger
banker	12	42	2273	2	banker
banner	8	44	2150	2	banner
banter	8	48	2534	2	banter
bender	9	52	2330	2	bender
binder	9	44	2287	2	binder
blander	10	37	1517	2	blander
bonder	9	53	2478	2	bonder
brander	10	39	1582	2	brander
cancer	10	42	2092	2	cancer
candler	10	35	1659	2	candler
candor	9	45	1642	2	candor
caner	7	53	3477	2	can_er
canker	12	44	2252	2	canker
canner	8	46	2598	2	canner
canoer	8	51	2107	2	canoer
canter	8	52	3011	2	canter
carder	9	45	2418	2	carder
chancer	14	42	1563	2	chancer
chandler	14	35	837	2	chandler
changer	13	42	1554	2	changer
chanter	12	39	1973	2	chanter
cinder	9	41	1912	2	cinder
dancer	9	48	1761	2	dancer
danders	9	39	2118	2	danders
dandier	9	37	1457	2	dandier
dandler	9	44	1427	2	dandler
danger	8	37	2283	2	danger
danker	11	43	1966	2	danker
daunder	9	34	890	2	daunder
ender	6	43	2586	2	_ender
fader	9	44	2151	2	fa_der
fanner	9	42	1818	2	fanner
fender	10	37	1872	2	fender
finder	10	40	2023	2	finder
fonder	10	41	2006	2	fonder
funder	10	40	1609	2	funder
gadder	9	37	1471	2	gadder
ganders	9	35	2170	2	ganders
ganger	8	37	2147	2	ganger
gender	8	35	1793	2	gender
grander	9	33	1587	2	grander
hacker	15	48	2269	2	hacker
hade	8	54	4020	2	ha_de_
haded	10	52	2762	2	ha_ded
hades	9	60	3511	2	ha_des
hafter	12	48	1588	2	hafter
hailer	9	47	2034	2	hailer
haler	8	50	3353	2	ha_ler
halter	9	44	2088	2	halter
hammer	13	81	2003	2	hammer
hamper	13	45	1865	2	hamper
hanaper	12	3	713	2	hanaper
hance	10	54	2415	2	hance_
hances	11	56	2128	2	hances
hand	8	68	3371	2	hand__
handax	17	4	958	2	handax
handcar	13	3	737	2	handcar
handle	10	42	1929	2	handle
handled	12	41	1453	2	handled
handlers	12	40	1414	2	handlers
handles	11	40	2065	2	handles
handover	15	12	682	2	handover
hands	9	53	2738	2	hand_s
handsel	11	30	872	2	handsel
handset	11	30	1682	2	handset
handy	12	55	2087	2	hand_y
hangar	10	41	1452	2	hangar
hanged	11	42	2240	2	hanged
hangers	11	31	2081	2	hangers
hanked	14	42	2060	2	hanked
hankers	14	42	1813	2	hankers
hanse	8	57	2279	2	hanse_
hansel	9	52	1437	2	hansel
hanses	9	50	2263	2	hanses
hanted	10	41	2431	2	hanted
harden	10	57	1853	2	harden
hardier	11	47	2154	2	hardier
harmer	11	47	1956	2	harmer
harper	11	50	1840	2	harper
hater	8	50	3475	2	ha_ter
hatter	9	47	2487	2	hatter
hauler	9	50	1512	2	hauler
haunter	10	31	1115	2	haunter
haver	11	51	2446	2	ha_ver
hawker	16	48	1266	2	hawker
hawser	12	59	1084	2	hawser
hayer	11	46	2024	2	ha_yer
hazer	17	48	2023	2	ha_zer
hazier	18	47	1240	2	hazier
header	10	44	2254	2	header
heder	9	56	2364	2	h_eder
heeder	10	42	1604	2	heeder
herder	10	45	1646	2	herder
hider	9	50	2409	2	h_ider
hinders	11	37	1850	2	hinders
hinger	10	47	2333	2	hinger
hinter	9	40	2130	2	hinter
hoarder	11	32	923	2	hoarder
holder	10	46	1965	2	holder
honer	8	53	3209	2	hon_er
honker	13	41	1746	2	honker
hounder	11	34	1224	2	hounder
hunger	10	40	1520	2	hunger
hunker	13	39	1767	2	hunker
hunter	9	48	1777	2	hunter
kinder	11	37	1685	2	kinder
ladder	8	46	1762	2	ladder
lader	6	56	3372	2	la_der
lancer	8	43	1997	2	lancer
landed	8	46	1924	2	landed
landers	8	40	2622	2	landers
landler	8	41	1320	2	landler
lanker	10	41	2300	2	lanker
lanner	6	49	2060	2	lanner
larder	7	37	2097	2	larder
lauder	7	38	1501	2	lauder
launder	8	30	915	2	launder
lender	7	39	2128	2	lender
madder	10	35	1559	2	madder
manger	9	43	2501	2	manger
manner	8	40	2051	2	manner
maunder	10	32	869	2	maunder
meander	10	4	997	2	meander
mender	9	35	2079	2	mender
minder	9	48	2250	2	minder
padder	10	34	1549	2	padder
panders	10	34	2374	2	panders
panier	8	44	2550	2	panier
panner	8	42	2476	2	panner
panzer	17	42	1323	2	panzer
pinder	9	45	2346	2	pinder
ponder	9	45	2170	2	ponder
raider	7	43	1874	2	raider
randier	8	36	1847	2	randier
ranger	7	39	2553	2	ranger
ranker	10	50	2190	2	ranker
ranter	6	38	2682	2	ranter
render	7	40	2414	2	render
sadder	8	29	1697	2	sadder
sanded	8	49	2061	2	sanded
sanders	8	40	2594	2	sanders
sandier	8	40	1784	2	sandier
saner	5	43	3432	2	san_er
sanger	7	45	2457	2	sanger
sender	7	38	2441	2	sender
shader	10	42	1876	2	sha_der
slander	8	40	1545	2	slander
sonder	7	36	2352	2	sonder
stander	8	43	1616	2	stander
sunder	7	40	1983	2	sunder
tandem	9	3	1141	2	tandem
tanker	10	45	2113	2	tanker
tanner	6	37	2229	2	tanner
tender	7	41	2184	2	tender
thanker	14	30	959	2	thanker
thunder	11	3	697	2	thunder
tinder	7	38	2180	2	tinder
under	6	46	2422	2	_under
vanner	9	42	1584	2	vanner
vender	10	34	1842	2	vender
wadder	11	42	1548	2	wadder
wader	9	53	2537	2	wa_der
wanders	11	42	2133	2	wanders
wanier	9	39	2068	2	wanier
wanker	13	42	1997	2	wanker
wanner	9	40	1962	2	wanner
wanter	9	44	2305	2	wanter
warder	10	40	2027	2	warder
winder	10	40	2526	2	winder
wonder	10	36	1781	2	wonder
yarder	10	38	1397	2	yarder
yonder	10	32	1413	2	yonder
zanders	17	30	1579	2	zanders
zanier	15	43	1471	2	zanier

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	82551	0.373	479064.3
2	DLD Change Limit	82551	200	2.580	31996.5
3	Display Results	200	200	0.063	3174.6
	(SQL Overall)	178691	200	3.016	59247.7