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

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

285 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
kier	8	65	2680	(None)
bier	6	55	3183	1	bier
keir	8	62	1787	1	keir
kief	11	71	2840	1	kief
kiers	9	53	2009	1	kiers
kir	7	65	3567	1	ki_r
kiter	9	55	2321	1	kiter
lier	4	59	4246	1	lier
pier	6	60	3529	1	pier
skier	9	51	1959	1	skier
tier	4	49	3614	1	tier
vier	7	54	2815	1	vier
ager	5	59	3584	2	ager
aider	6	54	3113	2	aider
aimer	7	59	2682	2	aimer
air	3	80	5839	2	ai_r
airer	5	49	2789	2	airer
aiver	8	57	2516	2	aiver
aper	6	63	3623	2	aper
aver	7	59	3188	2	aver
beer	6	56	3599	2	beer
bider	8	57	2837	2	bider
biers	7	62	2522	2	biers
biker	11	60	2256	2	biker
biner	7	59	3069	2	biner
birr	6	60	2236	2	birr
biter	7	50	3003	2	biter
brier	7	45	2740	2	brier
cakier	12	31	1524	2	cakier
cider	8	47	2331	2	cider
cire	6	58	3637	2	cire
citer	7	48	2733	2	citer
crier	7	47	2446	2	crier
deer	5	67	3902	2	deer
dicer	8	54	2642	2	dicer
die	4	67	5965	2	die_
died	6	61	3785	2	died
diel	5	90	3460	2	diel
dies	5	56	5352	2	dies
diet	5	73	5753	2	diet
diker	10	55	2455	2	diker
dimer	8	56	2560	2	dimer
diner	6	56	3290	2	diner
dire	5	66	4414	2	dire
direr	6	49	2707	2	direr
diver	9	48	2780	2	diver
doer	5	77	3470	2	doer
drier	6	44	2396	2	drier
dyer	8	55	2211	2	dyer
eger	5	59	2357	2	eger
eider	6	46	2474	2	eider
er	2	83	4514	2	__er
ever	7	70	2769	2	ever
ewer	7	75	2398	2	ewer
eyer	7	61	2728	2	eyer
fer	6	66	4612	2	_fer
fiar	7	64	2733	2	fiar
fiber	10	49	2113	2	fiber
fie	6	71	5244	2	fie_
fief	10	73	3136	2	fief
fiery	11	47	1479	2	fiery
fifer	11	55	1997	2	fifer
filer	8	54	3300	2	filer
finer	8	54	3156	2	finer
fir	6	67	4489	2	fi_r
fire	7	62	4559	2	fire
firer	8	112	2925	2	firer
fiver	11	60	2494	2	fiver
fixer	15	47	1783	2	fixer
flier	8	60	2340	2	flier
frier	8	52	2584	2	frier
giber	8	54	1770	2	giber
gie	4	71	4954	2	gie_
gied	6	46	3198	2	gied
gien	5	63	3002	2	gien
gies	5	56	4142	2	gies
giver	9	49	2120	2	giver
goer	5	68	2710	2	goer
heir	7	75	2380	2	heir
her	6	65	4781	2	_her
hider	9	50	2408	2	hider
hie	6	76	5270	2	hie_
hied	8	54	3404	2	hied
hies	7	48	4283	2	hies
hiker	12	51	1939	2	hiker
hire	7	55	3896	2	hire
hirer	8	54	2312	2	hirer
hoer	7	65	3398	2	hoer
hokier	13	42	1403	2	hokier
icier	7	43	1375	2	icier
ickier	12	43	992	2	ickier
inkier	10	40	1378	2	inkier
ire	3	69	4317	2	_ire
jeer	11	54	2646	2	jeer
jiber	14	51	1570	2	jiber
jiver	15	51	1905	2	jiver
jokier	17	61	875	2	jokier
kae	7	67	4454	2	kae_
kaes	8	57	3406	2	kaes
kaiser	10	36	1037	2	kaiser
kbar	10	65	1465	2	kbar
kea	7	65	4091	2	k_ea
keef	11	58	3000	2	keef
keek	7	56	2497	2	keek
keel	8	57	2947	2	keel
keen	8	48	3041	2	keen
keep	10	63	2982	2	keep
keet	8	53	4734	2	keet
kef	10	56	3966	2	k_ef
keg	8	64	3254	2	k_eg
keirs	9	53	1367	2	keirs
ken	7	63	4398	2	k_en
kep	9	64	3720	2	k_ep
kerb	10	43	2271	2	k_erb
kerf	11	58	2746	2	k_erf
kern	8	53	2621	2	k_ern
kex	14	60	2958	2	k_ex
key	10	58	3333	2	k_ey
khet	11	63	2862	2	khet
ki	6	75	3795	2	ki__
kibe	10	65	2344	2	kibe
kibei	11	43	1153	2	kibei
kibes	11	55	2111	2	kibes
kick	9	60	2606	2	kick
kicker	11	41	1618	2	kicker
kid	8	65	4061	2	ki_d
kidder	12	38	1110	2	kidder
kids	9	60	2963	2	kids
kiefs	12	61	1220	2	kiefs
kif	10	59	4118	2	ki_f
kifs	11	60	2350	2	kifs
kike	7	65	2478	2	kike
kikes	8	51	2255	2	kikes
kill	8	55	3317	2	kill
killer	10	49	1795	2	killer
kiln	8	56	2097	2	kiln
kilo	8	60	2866	2	kilo
kilt	8	61	4441	2	kilt
kilter	10	37	1434	2	kilter
kin	7	63	5396	2	ki_n
kina	8	56	3199	2	kina
kind	9	61	2855	2	kind
kinder	11	37	1684	2	kinder
kine	8	56	4342	2	kine
kines	9	50	3913	2	kines
king	9	59	3365	2	king
kink	7	60	3439	2	kink
kino	8	62	3361	2	kino
kins	8	57	4790	2	kins
kip	9	70	4213	2	ki_p
kipper	14	34	1421	2	kipper
kips	10	64	3051	2	kips
kirk	7	62	2156	2	kirk
kirn	8	71	2343	2	kirn
kirs	8	58	3173	2	kirs
kis	7	80	5147	2	ki_s
kiss	8	52	2739	2	kiss
kisser	10	42	1245	2	kisser
kist	8	65	4079	2	kist
kit	7	85	5987	2	ki_t
kite	8	53	3823	2	kite
kited	10	51	2009	2	kited
kiters	10	52	1859	2	kiters
kites	9	54	3254	2	kites
kith	11	58	2635	2	kith
kits	8	64	4176	2	kits
kiva	11	65	1640	2	kiva
kiwi	11	32	1179	2	kiwi
knar	8	58	1872	2	knar
knee	8	53	2360	2	knee
knew	11	59	1212	2	knew
knifer	13	59	856	2	knifer
knur	8	53	1197	2	knur
koel	8	45	1994	2	koel
kor	7	65	3889	2	k_or
kore	8	58	3416	2	kore
kue	7	66	3186	2	kue_
kues	8	64	2677	2	kues
kyar	11	69	1684	2	kyar
kye	10	73	2727	2	kye_
kyes	11	51	2493	2	kyes
lakier	10	47	1627	2	lakier
leer	4	62	3935	2	leer
liar	4	72	2968	2	liar
liber	7	47	2362	2	liber
lie	3	82	6452	2	lie_
lied	5	58	3809	2	lied
lief	7	60	3699	2	lief
lien	4	53	3980	2	lien
liers	5	51	3040	2	liers
lies	4	64	5419	2	lies
lieu	4	65	3436	2	lieu
lifer	8	58	2215	2	lifer
liger	6	50	2447	2	liger
liker	9	56	2706	2	liker
liner	5	59	3892	2	liner
lire	4	78	4529	2	lire
liter	5	47	3634	2	liter
liver	8	51	3296	2	liver
mien	6	50	2836	2	mien
miler	7	57	3306	2	miler
mimer	9	48	2576	2	mimer
miner	7	69	3354	2	miner
mir	5	70	4677	2	mi_r
mire	6	67	4823	2	mire
miser	7	54	3040	2	miser
miter	7	57	3479	2	miter
mixer	14	50	1764	2	mixer
nicer	7	46	1829	2	nicer
niter	5	50	2897	2	niter
oakier	10	40	1139	2	oakier
oiler	5	46	2828	2	oiler
omer	6	70	2839	2	omer
osier	5	35	1801	2	osier
over	7	72	2734	2	over
oyer	7	59	2765	2	oyer
peer	6	62	3835	2	peer
per	5	63	5309	2	_per
pie	5	54	5740	2	pie_
pied	7	50	3536	2	pied
piers	7	59	2633	2	piers
pies	6	69	4960	2	pies
piker	11	56	2284	2	piker
piper	9	65	2319	2	piper
plier	7	52	2128	2	plier
pokier	12	49	1463	2	pokier
prier	7	50	2776	2	prier
ricer	7	47	2661	2	ricer
rider	6	52	3130	2	rider
riel	4	64	3238	2	riel
rifer	8	47	2198	2	rifer
rimer	7	54	2924	2	rimer
riper	7	43	2840	2	riper
riser	5	54	3105	2	riser
river	8	57	3169	2	river
ruer	4	61	2756	2	ruer
seer	4	55	4704	2	seer
ser	3	67	5240	2	_ser
shier	8	54	2894	2	shier
sieur	5	9	1189	2	sieur
siker	9	53	2603	2	siker
sir	3	57	4667	2	si_r
sire	4	61	5041	2	sire
siver	8	57	2861	2	siver
sizer	14	55	2181	2	sizer
skied	10	44	1775	2	skied
skiers	10	47	1370	2	skiers
skies	9	50	2683	2	skies
skiey	12	50	1289	2	skiey
skirr	9	48	1054	2	skirr
skiver	13	46	1210	2	skiver
slier	5	48	2724	2	slier
spier	7	57	2803	2	spier
suer	4	53	3403	2	suer
tie	3	65	5753	2	tie_
tied	5	55	3521	2	tied
tiers	5	55	2652	2	tiers
ties	4	52	4831	2	ties
tiger	6	57	1863	2	tiger
tiler	5	61	3102	2	tiler
timer	7	56	2604	2	timer
tire	4	61	4335	2	tire
titer	5	54	3061	2	titer
trier	5	43	2853	2	trier
twier	8	47	1329	2	twier
tyer	7	53	2339	2	tyer
user	4	50	2300	2	user
veer	7	62	2957	2	veer
vie	6	54	4763	2	vie_
vied	8	63	2863	2	vied
viers	8	56	2195	2	viers
vies	7	52	3862	2	vies
view	10	59	1767	2	view
viler	8	63	2416	2	viler
viper	10	50	1730	2	viper
weer	7	55	3509	2	weer
weir	7	60	1992	2	weir
wider	9	48	2635	2	wider
wiper	10	54	2129	2	wiper
wire	7	58	3981	2	wire
wirer	8	51	2495	2	wirer
wiser	8	55	2280	2	wiser
wiver	11	59	2451	2	wiver
wrier	8	45	2175	2	wrier
yirr	7	65	1357	2	yirr

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	29872	0.280	638182.1
2	DLD Change Limit	29872	285	0.766	38997.4
3	Display Results	285	285	0.063	4523.8
	(SQL Overall)	178691	285	1.109	161128.0