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

Here are the results of your fuzzy-string dictionary search for “tiger” 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
tiger	6	57	1863	(None)
liger	6	50	2446	1	liger
tier	4	49	3614	1	ti_er
tigers	7	56	1650	1	tigers
tiler	5	61	3102	1	tiler
timer	7	56	2604	1	timer
titer	5	54	3061	1	titer
ager	5	59	3584	2	_ager
agger	7	64	2089	2	agger
aider	6	54	3113	2	aider
aimer	7	59	2682	2	aimer
airer	5	49	2789	2	airer
aiver	8	57	2516	2	aiver
anger	6	62	2587	2	anger
auger	6	49	2247	2	auger
bider	8	57	2837	2	bider
bier	6	55	3182	2	bi_er
bigger	10	43	1506	2	bigger
biker	11	60	2256	2	biker
biner	7	59	3069	2	biner
binger	9	49	2344	2	binger
biter	7	50	3003	2	biter
cager	8	52	2922	2	cager
cider	8	47	2331	2	cider
cigar	8	9	1179	2	cigar
citer	7	48	2732	2	citer
dicer	8	54	2642	2	dicer
digger	9	46	1608	2	digger
diker	10	55	2455	2	diker
dimer	8	56	2560	2	dimer
diner	6	56	3290	2	diner
dinger	8	53	2366	2	dinger
direr	6	49	2707	2	direr
diver	9	48	2780	2	diver
eager	6	55	2696	2	eager
edger	7	52	1593	2	edger
eger	5	59	2356	2	_eger
egger	7	44	1440	2	egger
eider	6	46	2474	2	eider
fiber	10	49	2113	2	fiber
fifer	11	55	1997	2	fifer
filer	8	54	3300	2	filer
finer	8	54	3156	2	finer
finger	10	49	2032	2	finger
firer	8	112	2925	2	firer
fiver	11	60	2494	2	fiver
fixer	15	47	1783	2	fixer
gager	7	47	2629	2	gager
giber	8	54	1770	2	giber
ginger	8	49	2002	2	ginger
giver	9	49	2120	2	giver
hider	9	50	2408	2	hider
higher	13	46	1089	2	higher
hiker	12	51	1939	2	hiker
hinger	10	47	2331	2	hinger
hirer	8	54	2312	2	hirer
huger	9	49	1487	2	huger
ither	8	46	1760	2	ither
jager	13	43	1813	2	jager
jiber	14	51	1570	2	jiber
jigger	15	53	1305	2	jigger
jiver	15	51	1905	2	jiver
kier	8	65	2680	2	ki_er
kiter	9	55	2321	2	kiter
lager	6	51	3286	2	lager
leger	6	57	2150	2	leger
liber	7	47	2361	2	liber
lier	4	59	4246	2	li_er
lifer	8	58	2215	2	lifer
ligers	7	50	2202	2	ligers
liker	9	56	2706	2	liker
liner	5	59	3891	2	liner
linger	7	52	2599	2	linger
liter	5	47	3634	2	liter
liver	8	51	3296	2	liver
luger	6	53	2208	2	luger
miler	7	57	3306	2	miler
mimer	9	48	2576	2	mimer
miner	7	69	3354	2	miner
miser	7	54	3040	2	miser
miter	7	57	3479	2	miter
mixer	14	50	1764	2	mixer
nicer	7	46	1829	2	nicer
nigger	8	97	1357	2	nigger
nigher	10	36	1275	2	nigher
niter	5	50	2897	2	niter
oiler	5	46	2828	2	oiler
pager	8	47	2820	2	pager
pier	6	60	3529	2	pi_er
piker	11	56	2284	2	piker
pinger	9	43	2408	2	pinger
piper	9	65	2319	2	piper
ricer	7	47	2661	2	ricer
rider	6	52	3130	2	rider
rifer	8	47	2198	2	rifer
rigger	8	56	1671	2	rigger
rigor	6	27	1405	2	rigor
rimer	7	54	2924	2	rimer
ringer	7	45	2605	2	ringer
riper	7	43	2840	2	riper
riser	5	54	3105	2	riser
river	8	57	3169	2	river
roger	6	45	2141	2	roger
sager	6	54	3205	2	sager
sigher	10	38	1370	2	sigher
signer	7	40	1562	2	signer
siker	9	53	2603	2	siker
singer	7	42	2730	2	singer
siver	8	57	2861	2	siver
sizer	14	55	2181	2	sizer
stager	7	48	2134	2	stager
stinger	8	43	1468	2	stinger
stiver	9	39	1573	2	stiver
taber	7	38	2582	2	taber
tagger	8	40	1769	2	tagger
tailer	6	38	2373	2	tailer
taker	9	52	2900	2	taker
taler	5	60	3486	2	taler
tamer	7	52	3010	2	tamer
taper	7	48	2977	2	taper
tater	5	41	3861	2	tater
tawer	8	52	2344	2	tawer
taxer	12	50	1936	2	taxer
ticker	12	43	2150	2	ticker
tide	5	52	3737	2	tide_
tided	7	63	2251	2	tided
tides	6	48	3015	2	tides
tidier	7	35	1511	2	tidier
tie	3	65	5753	2	ti_e_
tied	5	55	3521	2	ti_ed
tiers	5	55	2652	2	ti_ers
ties	4	52	4831	2	ti_es
tight	9	36	2650	2	tight
tighter	11	29	1068	2	tighter
tigon	6	39	1444	2	tigon
tike	8	55	3448	2	tike_
tikes	9	56	2890	2	tikes
tile	4	54	5144	2	tile_
tiled	6	48	3294	2	tiled
tilers	6	35	2349	2	tilers
tiles	5	55	4210	2	tiles
tiller	6	42	2253	2	tiller
tilter	6	34	1769	2	tilter
timber	10	40	1267	2	timber
time	6	62	3501	2	time_
timed	8	52	2361	2	timed
timers	8	44	2099	2	timers
times	7	56	3082	2	times
tinder	7	38	2180	2	tinder
tine	4	58	5513	2	tine_
tinea	5	49	2315	2	tinea
tined	6	54	3453	2	tined
tines	5	48	4842	2	tines
tinge	6	46	2661	2	tinge_
tinged	8	42	2079	2	tinged
tinges	7	47	2232	2	tinges
tingler	8	36	1332	2	tingler
tinier	6	36	2223	2	tinier
tinker	10	36	1992	2	tinker
tinner	6	41	1995	2	tinner
tinter	6	39	2364	2	tinter
tipper	10	39	1841	2	tipper
tire	4	61	4335	2	tire_
tired	6	52	2890	2	tired
tires	5	54	3749	2	tires
titers	6	45	2640	2	titers
titfer	9	40	952	2	titfer
tither	9	49	2028	2	tither
titre	5	46	1939	2	titre
titter	6	34	2116	2	titter
toiler	6	39	1828	2	toiler
toker	9	59	2491	2	toker
toner	5	53	3624	2	toner
tonger	7	47	1968	2	tonger
toper	7	52	3102	2	toper
toter	5	59	3213	2	toter
tower	8	57	2920	2	tower
toyer	8	45	2155	2	toyer
trier	5	43	2853	2	trier
trigger	9	32	915	2	trigger
trimer	8	57	1715	2	trimer
triter	6	51	2059	2	triter
truer	5	49	1664	2	truer
tuber	7	54	2068	2	tuber
tugger	8	40	1310	2	tugger
tuner	5	60	2268	2	tuner
tuyer	8	54	1429	2	tuyer
twier	8	47	1329	2	twier
twiner	9	40	1259	2	twiner
twyer	11	55	852	2	twyer
tyer	7	53	2339	2	t_yer
urger	6	41	1647	2	urger
vier	7	54	2815	2	vi_er
vigor	9	26	1242	2	vigor
viler	8	63	2416	2	viler
viper	10	50	1730	2	viper
wager	9	59	2505	2	wager
wider	9	48	2635	2	wider
winger	10	41	2543	2	winger
wiper	10	54	2129	2	wiper
wirer	8	51	2495	2	wirer
wiser	8	55	2280	2	wiser
wiver	11	59	2451	2	wiver
yager	9	56	1675	2	yager
zinger	16	38	1669	2	zinger

Search took 2 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	53800	0.096	1861364.6
2	DLD Change Limit	53800	205	1.763	30516.2
3	Display Results	205	205	0.063	3254.0
	(SQL Overall)	178691	205	1.922	92971.4