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

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

88 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
huppahs	17	4	333	(None)
chuppahs	20	4	207	1	chuppahs
huppah	16	4	418	1	huppah_
chuppah	19	5	245	2	chuppah_
chuppas	16	4	412	2	chuppa_s
cuppas	12	45	859	2	cuppa_s
humphs	16	52	816	2	hump_hs
hurrahs	13	33	677	2	hurrahs
hutzpahs	25	4	144	2	hutzpahs
huzzahs	21	4	308	2	huzzahs
rupiahs	12	5	333	2	rupiahs
appals	10	48	1294	3	_appals
bumphs	15	46	710	3	bump_hs
buppies	13	30	1106	3	buppies
chuddahs	18	22	258	3	chuddahs
chuppa	15	4	397	3	chuppa__
chutzpahs	28	5	109	3	chutzpahs
coprahs	14	33	815	3	coprahs
cuppa	11	39	852	3	cuppa__
cuppers	13	37	1221	3	cuppers
ephahs	14	3	550	3	_ephahs
guppies	12	33	1052	3	guppies
hahs	10	83	3336	3	h___ahs
hallahs	13	39	1246	3	hallahs
halvahs	16	41	753	3	halvahs
hamzahs	24	13	437	3	hamzahs
happens	14	35	917	3	happens
hepcats	14	3	647	3	hepcats
heptads	13	3	587	3	heptads
hijrahs	20	4	344	3	hijrahs
hipparchs	21	5	245	3	hipparchs
hippies	14	28	1375	3	hippies
hippish	17	3	618	3	hippish
hippos	13	40	843	3	hipp_os
hookahs	17	44	665	3	hookahs
hoorahs	13	39	960	3	hoorahs
hoppers	14	31	1514	3	hoppers
hopples	14	28	1071	3	hopples
horahs	12	63	1387	3	h_orahs
houdahs	14	3	424	3	houdahs
howdahs	17	3	361	3	howdahs
hubcaps	16	4	354	3	hubcaps
huipils	12	4	353	3	huipils
hulas	8	49	2088	3	hu_la_s
humans	11	23	1243	3	hu_mans
humpers	14	27	1352	3	humpers
humph	15	57	1221	3	hump_h_
humps	12	63	2280	3	hump__s
hurrah	12	36	918	3	hurrah_
hurrays	13	38	615	3	hurrays
hussars	10	32	698	3	hussars
hutzpah	24	4	180	3	hutzpah_
hutzpas	21	4	269	3	hutzpa_s
huzzah	20	4	442	3	huzzah_
huzzas	17	3	586	3	huzza_s
jubbahs	21	4	362	3	jubbahs
jubhahs	22	4	235	3	jubhahs
kappas	14	44	1036	3	kappa_s
koppas	14	40	760	3	koppa_s
mullahs	12	38	873	3	mullahs
nappas	10	55	1161	3	nappa_s
nullahs	10	31	699	3	nullahs
oompahs	14	3	426	3	oompahs
opahs	10	54	1198	3	__opahs
ouphs	10	43	1127	3	ou_p_hs
outpass	9	3	971	3	outpass
poppas	9	37	1071	3	poppa_s
pujahs	18	40	494	3	pu_jahs
punkahs	16	28	478	3	punkahs
pupas	9	52	1928	3	pu_pa_s
puppets	10	31	701	3	puppets
puppies	10	32	1262	3	puppies
purdahs	13	28	548	3	purdahs
rupiah	11	4	621	3	rupiah_
subahs	11	45	1238	3	su_bahs
succahs	14	3	532	3	succahs
sukkahs	13	8	270	3	sukkahs
sulphas	12	3	624	3	sulphas
sunnahs	10	32	659	3	sunnahs
suppers	11	33	1470	3	suppers
supples	11	5	1128	3	supples
surahs	9	45	1554	3	su_rahs
surpass	9	3	828	3	surpass
tussahs	10	33	511	3	tussahs
upas	6	83	2238	3	_u_pa_s
uppers	10	29	1229	3	_uppers
uppish	13	3	663	3	_uppish
yuppies	14	33	926	3	yuppies

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.406	440125.6
2	DLD Change Limit	134027	88	6.423	20866.7
3	Display Results	88	88	0.030	2933.3
	(SQL Overall)	178691	88	6.859	26052.0