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

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

180 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
pinder	9	45	2345	(None)
binder	9	44	2287	1	binder
cinder	9	41	1912	1	cinder
finder	10	40	2023	1	finder
hinder	10	41	2006	1	hinder
kinder	11	37	1684	1	kinder
minder	9	48	2250	1	minder
pander	9	37	2552	1	pander
pincer	10	40	1917	1	pincer
pinders	10	37	2047	1	pinders
pinger	9	43	2409	1	pinger
pinier	8	40	2469	1	pinier
pinker	12	53	2244	1	pinker
pinner	8	45	2150	1	pinner
ponder	9	45	2169	1	ponder
tinder	7	38	2180	1	tinder
winder	10	40	2526	1	winder
aider	6	54	3113	2	ai_der
bander	9	39	2822	2	bander
bender	9	52	2330	2	bender
bidder	10	41	1486	2	bidder
bider	8	57	2837	2	bi_der
binders	10	39	2074	2	binders
bindery	13	45	983	2	bindery
biner	7	59	3069	2	bin_er
binger	9	49	2345	2	binger
birder	9	49	1549	2	birder
blinder	10	39	1298	2	blinder
bonder	9	53	2478	2	bonder
cider	8	47	2331	2	ci_der
cinders	10	46	1776	2	cinders
cindery	13	42	919	2	cindery
dander	8	112	2299	2	dander
diner	6	56	3290	2	din_er
dinger	8	53	2367	2	dinger
dinner	7	42	1716	2	dinner
eider	6	46	2474	2	ei_der
ender	6	43	2586	2	_ender
fender	10	37	1872	2	fender
finders	11	37	1787	2	finders
finer	8	54	3156	2	fin_er
finger	10	49	2033	2	finger
flinder	11	31	987	2	flinder
fonder	10	41	2006	2	fonder
funder	10	40	1608	2	funder
gander	8	43	2276	2	gander
gender	8	35	1793	2	gender
gilder	8	44	1553	2	gilder
ginger	8	49	2003	2	ginger
ginner	7	39	1582	2	ginner
girder	8	43	1206	2	girder
grinder	9	33	1239	2	grinder
hander	10	45	2643	2	hander
hider	9	50	2408	2	hi_der
hinders	11	37	1850	2	hinders
hinger	10	47	2333	2	hinger
hinter	9	40	2130	2	hinter
index	13	3	1098	2	_index
infer	8	42	1503	2	_infer
inker	9	44	2109	2	_inker
inner	5	49	2063	2	_inner
inter	5	50	2849	2	_inter
jinker	17	40	1354	2	jinker
joinder	15	33	759	2	joinder
kidder	12	38	1110	2	kidder
kindler	12	30	998	2	kindler
lander	7	40	2848	2	lander
lender	7	39	2127	2	lender
lieder	7	49	1232	2	lieder
linden	7	4	1145	2	linden
liner	5	59	3892	2	lin_er
linger	7	52	2600	2	linger
linier	6	44	2379	2	linier
linker	10	43	2147	2	linker
linter	6	46	2534	2	linter
mender	9	35	2079	2	mender
milder	9	38	1845	2	milder
mincer	10	40	1736	2	mincer
minded	10	38	1783	2	minded
minders	10	37	2012	2	minders
miner	7	69	3354	2	min_er
minter	8	44	2510	2	minter
padder	10	34	1549	2	padder
painter	9	38	1456	2	painter
panders	10	34	2373	2	panders
panier	8	44	2550	2	panier
panner	8	42	2476	2	panner
panzer	17	42	1323	2	panzer
pended	10	38	1901	2	pended
penner	8	46	1666	2	penner
picker	14	44	2217	2	picker
piddler	11	29	1152	2	piddler
piecer	10	52	1308	2	piecer
pier	6	60	3529	2	pi__er
piker	11	56	2284	2	pi_ker
pilfer	11	3	916	2	pilfer
pincers	11	39	1650	2	pincers
pincher	14	38	1271	2	pincher
pine	6	77	5571	2	pin_e_
pined	8	59	3532	2	pin_ed
pinery	11	52	1429	2	pin_ery
pines	7	60	4886	2	pin_es
piney	10	57	2750	2	pin_ey
pinged	10	43	2138	2	pinged
pingers	10	40	2074	2	pingers
pinked	13	48	1988	2	pinked
pinken	12	45	1328	2	pinken
pinkers	13	41	1860	2	pinkers
pinkey	15	43	1467	2	pinkey
pinned	9	48	1838	2	pinned
pinners	9	35	1860	2	pinners
pioneer	9	3	689	2	pioneer
piper	9	65	2319	2	pi_per
pipier	10	49	1398	2	pipier
pisher	11	43	1775	2	pisher
pisser	8	44	1638	2	pisser
pitier	8	40	1982	2	pitier
plinker	13	40	1096	2	plinker
plunder	10	38	1050	2	plunder
poinded	11	35	897	2	poinded
pointer	9	38	1493	2	pointer
polder	9	40	1925	2	polder
ponded	10	52	1877	2	ponded
ponders	10	36	1884	2	ponders
pounder	10	33	1400	2	pounder
powder	12	36	1190	2	powder
prinker	13	34	1274	2	prinker
printer	9	39	1730	2	printer
punier	8	45	1922	2	punier
punker	12	37	1882	2	punker
punner	8	49	1815	2	punner
punter	8	43	2002	2	punter
qindar	16	31	717	2	qindar
render	7	40	2414	2	render
ridder	8	40	1514	2	ridder
rider	6	52	3130	2	ri_der
rinded	8	44	1898	2	rinded
ringer	7	45	2606	2	ringer
rinser	6	43	1721	2	rinser
sander	7	48	2853	2	sander
sender	7	38	2441	2	sender
singer	7	42	2731	2	singer
sinker	10	36	2090	2	sinker
sinner	6	43	2060	2	sinner
sinter	6	36	2592	2	sinter
snider	7	44	1391	2	snider
sonder	7	36	2352	2	sonder
spender	10	37	1369	2	spender
spider	9	45	1680	2	spi_der
spindler	11	29	798	2	spindler
spinier	9	37	1516	2	spinier
spinner	9	39	1226	2	spinner
sunder	7	40	1982	2	sunder
tender	7	41	2184	2	tender
tinders	8	42	1917	2	tinders
tindery	11	38	936	2	tindery
tinier	6	36	2223	2	tinier
tinker	10	36	1992	2	tinker
tinner	6	41	1996	2	tinner
tinter	6	39	2364	2	tinter
under	6	46	2421	2	_under
vender	10	34	1842	2	vender
vinier	9	37	1674	2	vinier
wander	10	44	2371	2	wander
widder	11	29	1397	2	widder
wider	9	48	2635	2	wi_der
wilder	10	36	1647	2	wilder
wincer	11	50	1819	2	wincer
winded	11	49	1821	2	winded
winders	11	37	2126	2	winders
windier	11	34	1216	2	windier
winger	10	41	2544	2	winger
winier	9	45	2245	2	winier
winker	13	42	2029	2	winker
winner	9	42	1993	2	winner
winter	9	42	2280	2	winter
wonder	10	36	1781	2	wonder
yonder	10	32	1413	2	yonder
zander	16	34	1711	2	zander
zinger	16	38	1670	2	zinger

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.360	496363.9
2	DLD Change Limit	82551	180	2.156	38289.0
3	Display Results	180	180	0.063	2857.1
	(SQL Overall)	178691	180	2.579	69286.9