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

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

26 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
haikus	13	53	829	(None)
haiks	12	51	2093	1	haik_s
haiku	12	61	1369	1	haiku_
hakus	12	51	1411	1	ha_kus
ankus	9	14	1068	2	_ankus
habitus	12	33	817	2	habitus
habus	10	63	1714	2	ha_bus
hacks	14	49	2871	2	hack_s
haik	11	55	2698	2	haik__
haika	12	53	1379	2	haik_a
hails	8	52	3164	2	hai_ls
haints	9	44	1758	2	haints
hairs	8	62	2517	2	hai_rs
hakes	12	60	3430	2	ha_kes
hakims	15	3	730	2	hakims
haku	11	69	2389	2	ha_ku_
halitus	10	33	996	2	halitus
hanks	12	62	2686	2	hank_s
harks	12	63	3343	2	hark_s
hawks	15	54	1570	2	hawk_s
hiatus	9	3	822	2	hiatus
hikes	12	54	2698	2	h_ikes
hilus	8	48	1764	2	h_ilus
nairus	6	3	914	2	nairus
paiks	11	47	1985	2	paik_s
rakus	9	44	1367	2	ra_kus

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.373	479064.3
2	DLD Change Limit	82551	26	2.580	31996.5
3	Display Results	26	26	0.013	2000.0
	(SQL Overall)	178691	26	2.966	60246.5