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

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

77 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
sukkahs	13	8	270	(None)
sukkah	12	12	373	1	sukkah_
punkahs	16	28	478	2	punkahs
subahs	11	45	1238	2	su_bahs
succahs	14	3	532	2	succahs
sunnahs	10	32	659	2	sunnahs
surahs	9	45	1554	2	su_rahs
burkas	12	45	1380	3	burka_s
chukkars	16	4	201	3	chukkars
chukkas	15	3	278	3	chukka_s
hookahs	17	44	666	3	hookahs
huppahs	17	4	333	3	huppahs
hurrahs	13	33	677	3	hurrahs
huzzahs	21	4	308	3	huzzahs
jubbahs	21	4	362	3	jubbahs
jubhahs	22	4	235	3	jubhahs
mikvahs	19	16	249	3	mikvahs
mullahs	12	38	873	3	mullahs
nullahs	10	31	699	3	nullahs
pujahs	18	40	494	3	pu_jahs
pukka	10	45	713	3	pukka__
punkah	15	34	709	3	punkah_
punkas	12	34	1067	3	punka_s
purdahs	13	28	548	3	purdahs
quokkas	19	4	206	3	quokka_s
rupiahs	12	5	333	3	rupiahs
selahs	9	3	1321	3	s_elahs
shahs	11	59	1951	3	s__hahs
shibahs	15	27	564	3	shibahs
shikars	14	3	618	3	shikars
shivahs	16	37	572	3	shivahs
sikas	9	46	1702	3	s_ika_s
sirrahs	10	37	730	3	sirrahs
skags	10	43	1607	3	s__kags
skas	8	53	2571	3	s__ka_s
skats	9	46	2154	3	s__kats
skeans	10	45	1291	3	s_keans
skoals	10	43	824	3	s_koals
skuas	9	56	1173	3	s_kua_s
subah	10	60	1521	3	su_bah_
subas	7	47	2407	3	su_ba_s
subbass	11	3	803	3	subbass
subways	15	3	616	3	subways
succah	13	3	664	3	succah_
suckers	13	37	1762	3	suckers
suckles	13	45	1674	3	suckles
sucks	11	45	2307	3	suck__s
sugars	7	3	1242	3	su_gars
sughs	9	53	1332	3	su__ghs
sukkot	9	3	664	3	sukk_ot
sukkoth	13	4	209	3	sukkoth
suks	8	59	2712	3	su_k__s
suldans	8	29	972	3	suldans
sulfas	9	3	1156	3	sulfa_s
sulkers	11	36	1334	3	sulkers
sulkies	11	43	1576	3	sulkies
sulks	9	48	1846	3	sulk__s
sulphas	12	3	624	3	sulphas
sultans	7	24	1183	3	sultans
sumachs	14	45	735	3	sumachs
sumacs	10	55	1210	3	su_macs
summas	10	43	1316	3	summa_s
sunbaths	13	4	438	3	sunbaths
sundaes	8	3	1309	3	sundaes
sunkets	11	35	1128	3	sunkets
sunnah	9	36	935	3	sunnah_
sunnas	6	39	1456	3	sunna_s
sunrays	10	3	708	3	sunrays
suntans	7	21	1173	3	suntans
surah	8	68	2325	3	su_rah_
suras	5	53	3633	3	su_ra_s
surpass	9	3	828	3	surpass
surras	6	59	1953	3	surra_s
sutras	6	48	1859	3	sutra_s
suttas	6	38	1379	3	sutta_s
tikkas	9	3	452	3	tikka_s
tussahs	10	33	511	3	tussahs

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.423	422437.4
2	DLD Change Limit	134027	77	6.420	20876.5
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	6.873	25999.0