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

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

64 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
kaiser	10	36	1037	(None)
kaisers	11	36	927	1	kaisers
raiser	6	66	2010	1	raiser
aider	6	54	3113	2	_aider
aimer	7	59	2682	2	_aimer
airer	5	49	2789	2	_airer
aiver	8	57	2516	2	_aiver
bailer	8	54	2525	2	bailer
baiter	8	44	2255	2	baiter
baser	7	48	2892	2	ba_ser
causer	8	41	1778	2	causer
daiker	11	51	1303	2	daiker
daises	7	43	1898	2	daises
easier	6	42	1846	2	easier
fainer	9	47	1724	2	fainer
fairer	9	52	1206	2	fairer
falser	9	39	1241	2	falser
gainer	7	41	1749	2	gainer
gaiter	7	38	1950	2	gaiter
gasser	7	50	1777	2	gasser
hailer	9	47	2034	2	hailer
hawser	12	59	1084	2	hawser
jailer	13	43	1668	2	jailer
kaiserin	12	4	502	2	kaiserin
kasher	13	49	1503	2	kasher
keister	11	30	1157	2	keister
kier	8	65	2681	2	k_i_er
kisser	10	42	1245	2	kisser
kiter	9	55	2321	2	k_iter
klister	11	34	1064	2	klister
knifer	13	59	856	2	knifer
krises	10	50	1608	2	krises
lapser	8	41	1314	2	lapser
laser	5	46	3332	2	la_ser
mailer	8	47	2418	2	mailer
maimer	10	45	1459	2	maimer
maser	7	50	2997	2	ma_ser
miser	7	54	3040	2	_miser
nailer	6	41	1936	2	nailer
naiver	9	43	1135	2	naiver
paise	7	50	2833	2	paise_
parser	8	48	2237	2	parser
passer	8	47	2103	2	passer
pauser	8	44	1596	2	pauser
paviser	12	48	909	2	paviser
poiser	8	42	1724	2	poiser
praiser	9	34	1394	2	praiser
raider	7	43	1874	2	raider
railer	6	45	2493	2	railer
raise	5	48	2805	2	raise_
raised	7	61	2033	2	raised
raisers	7	36	1739	2	raisers
raises	6	48	2654	2	raises
raser	5	56	3341	2	ra_ser
riser	5	54	3105	2	_riser
sailer	6	35	2610	2	sailer
seiser	6	53	1834	2	seiser
tailer	6	38	2373	2	tailer
vainer	9	37	1457	2	vainer
wailer	9	37	2032	2	wailer
waister	10	38	1238	2	waister
waiter	9	43	2125	2	waiter
waiver	12	42	1271	2	waiver
wiser	8	55	2280	2	_wiser

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.376	475242.0
2	DLD Change Limit	82551	64	2.326	35490.5
3	Display Results	64	64	0.033	1939.4
	(SQL Overall)	178691	64	2.735	65334.9