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

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

79 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
surpasses	11	4	553	(None)
surpassed	12	4	413	1	surpassed
surpasser	11	4	386	1	surpasser
surpassers	12	4	308	1	surpassers
outpasses	11	4	661	2	outpasses
sourpusses	12	4	245	2	sourpusses
strasses	8	13	1143	2	str_asses
subbasses	13	4	522	2	subbasses
surbases	10	3	1000	2	surba_ses
surpass	9	3	828	2	surpa_s_s
surpluses	11	5	542	2	surpluses
surplusses	12	4	283	2	surplusses
surprises	11	3	743	2	surprises
brasses	9	38	1835	3	_br_asses
burgesses	12	4	550	3	burgesses
bypasses	15	3	383	3	_bypasses
carcasses	13	3	747	3	carcasses
compasses	15	4	739	3	compasses
cuirasses	11	4	437	3	cuirasses
cutlasses	11	4	510	3	cutlasses
duresses	9	3	917	3	dur_esses
frasses	10	43	1451	3	_fr_asses
grasses	8	41	1734	3	_gr_asses
harasses	11	3	1103	3	har_asses
hardasses	13	4	645	3	hardasses
impasses	12	25	752	3	_impasses
kurbashes	18	8	352	3	kurbashes
morasses	10	3	890	3	mor_asses
outgasses	10	3	666	3	outgasses
outpassed	12	4	580	3	outpassed
overpasses	15	4	659	3	overpasses
passes	8	60	3047	3	___passes
purposes	12	3	782	3	purp_oses
quasses	16	20	950	3	qu__asses
repasses	10	18	1037	3	_repasses
rubasses	10	3	548	3	ru_basses
sargassos	10	4	232	3	sargassos
sasses	6	41	2439	3	s___asses
smartasses	12	4	316	3	smartasses
sournesses	10	3	1001	3	sournesses
stresses	8	11	1249	3	str_esses
subbases	12	3	906	3	subba_ses
subcastes	13	8	748	3	subcastes
subcauses	13	4	620	3	subcauses
subclasses	14	4	474	3	subclasses
subphases	16	4	575	3	subphases
successes	13	4	564	3	successes
succusses	13	4	442	3	succusses
sucrases	10	3	1025	3	sucra_ses
sunglasses	11	4	385	3	sunglasses
supposes	12	3	820	3	su_pposes
suppresses	14	4	625	3	suppresses
surbase	9	3	979	3	surba_se_
surbased	11	3	661	3	surba_sed
surceases	11	5	747	3	surceases
surenesses	10	12	1220	3	surenesses
surfaces	13	3	867	3	surfa_ces
surmises	10	3	1064	3	sur_mises
surnames	10	3	727	3	surna_mes
surpassing	13	4	383	3	surpassing
surplices	13	4	604	3	surplices
surplused	12	4	351	3	surplused
surplussed	13	6	211	3	surplussed
surprise	10	3	767	3	surprise_
surprised	12	4	530	3	surprised
surpriser	11	4	460	3	surpriser
surprisers	12	4	363	3	surprisers
surprizes	20	4	558	3	surprizes
surtaxes	15	3	651	3	surta_xes
suspenses	11	10	641	3	suspenses
susses	6	42	2105	3	su___sses
syngasses	13	4	381	3	syngasses
trasses	7	48	1932	3	_tr_asses
unsurpassed	14	7	162	3	unsurpassed
upases	8	41	1290	3	_u_pa_ses
upraises	10	18	847	3	_upraises
urases	6	37	2356	3	_ur_a_ses
ureases	7	44	1672	3	_urea_ses
wrasses	10	38	1259	3	_wr_asses

Search took 10 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	148641	0.170	1051123.5
2	DLD Change Limit	148641	79	8.813	16866.1
3	Display Results	79	79	0.033	2393.9
	(SQL Overall)	178691	79	9.016	19819.3