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

Here are the results of your fuzzy-string dictionary search for “shikari” with Change Limit: [1] [2] [3] [4]

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.

85 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
shikari	14	4	449	(None)
shikar	13	3	680	1	shikar_
shikaris	15	4	490	1	shikaris
shikars	14	3	618	1	shikars
chivari	15	3	603	2	chivari
shikaree	15	4	483	2	shikaree
chimar	13	39	1146	3	chimar_
chimars	14	40	1057	3	chimars
chukar	15	3	463	3	chukar_
chukars	16	3	427	3	chukars
hegari	10	3	951	3	_hegari
hiker	12	51	1939	3	_hiker_
hikers	13	50	1435	3	_hikers
hilar	8	54	1814	3	_hilar_
safari	9	11	1022	3	s_afari
sari	4	54	4404	3	s___ari
shaker	13	43	1946	3	shaker_
shakers	14	40	1556	3	shakers
shard	9	61	2596	3	sh__ard
share	8	64	3708	3	sh__are
sharia	9	31	1672	3	sh__aria
sharif	12	29	1711	3	sh__arif
shark	12	62	2502	3	sh__ark
sharn	8	48	2370	3	sh__arn
sharp	10	49	2253	3	sh__arp
shear	8	54	2483	3	sh_ear_
shears	9	38	2090	3	sh_ears
shekalim	17	4	251	3	shekalim
shibah	14	38	746	3	shiba_h
shibahs	15	27	564	3	shibahs
shicker	16	39	1482	3	shicker_
shickers	17	30	1282	3	shickers
shier	8	54	2894	3	shi_er_
shiers	9	49	2175	3	shi_ers
shikarees	16	4	307	3	shikarees
shikarred	17	4	176	3	shikarred
shikarring	18	8	170	3	shikarring
shikker	13	27	702	3	shikker
shikkers	14	32	652	3	shikkers
shiksa	13	9	465	3	shik_sa
shiksas	14	8	464	3	shiksas
shikse	13	8	607	3	shik_se
shikseh	17	10	260	3	shikseh
shikses	14	11	657	3	shikses
shiner	9	38	2087	3	shiner_
shiners	10	40	1594	3	shiners
shipyard	17	4	334	3	shipyard
shire	8	47	2713	3	shi__re
shirk	12	48	1784	3	shi__rk
shirker	14	37	1134	3	shirker_
shirkers	15	31	958	3	shirkers
shirr	8	47	1692	3	shi__rr
shirrs	9	44	1317	3	shi_rrs
shirt	8	45	3389	3	shi__rt
shitake	14	5	561	3	shitake
shiva	11	59	1500	3	shiva__
shivah	15	48	853	3	shiva_h
shivahs	16	37	572	3	shivahs
shivaree	14	4	566	3	shivaree
shivas	12	45	1241	3	shiva_s
shiver	12	45	1737	3	shiver_
shivers	13	37	1483	3	shivers
shivery	16	31	702	3	shivery
shiviti	13	4	485	3	shiviti
shmear	11	7	693	3	shmear_
shmears	12	7	707	3	shmears
shofar	12	3	630	3	shofar_
shofars	13	3	581	3	shofars
shri	7	60	2169	3	sh___ri
sika	8	60	2132	3	s_ika__
sikas	9	46	1702	3	s_ika_s
siker	9	53	2603	3	s_iker_
simar	7	49	2081	3	s_imar_
simars	8	49	1693	3	s_imars
sitar	5	48	2054	3	s_itar_
sitars	6	54	1759	3	s_itars
sizar	14	52	1499	3	s_izar_
sizars	15	48	1262	3	s_izars
souari	6	3	1137	3	s_ouari
spiker	12	43	1566	3	spiker_
spikers	13	53	1199	3	spikers
stinkard	13	4	432	3	stinkard
suffari	13	4	550	3	suffari
uakari	10	4	686	3	_uakari
zaikai	19	4	371	3	zaika_i

Search took 7 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	134027	0.156	1145455.1
2	DLD Change Limit	134027	85	6.470	20715.1
3	Display Results	85	85	0.030	2833.3
	(SQL Overall)	178691	85	6.656	26846.6