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

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

66 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
gheraoed	13	4	334	(None)
gheraoes	12	4	481	1	gheraoes
gherao	10	3	675	2	gherao__
ghettoed	13	4	208	2	ghettoed
acerated	11	31	1398	3	acerated
aerated	8	53	2237	3	_aerated
averaged	13	5	621	3	averaged
beraked	14	43	1243	3	_beraked
berated	10	44	2213	3	_berated
cerated	10	39	2247	3	_cerated
cheated	13	44	1634	3	che_ated
chelated	14	26	1048	3	chelated
derated	9	36	2350	3	_derated
erased	7	48	1675	3	__erased
garaged	10	3	925	3	g_araged
geared	8	53	1774	3	g_e_ared
gelated	9	36	1563	3	g_elated
generated	11	3	1020	3	generated
gessoed	9	3	574	3	g_essoed
gheraoing	14	4	352	3	gheraoing
ghettoes	12	4	349	3	ghettoes
gleamed	11	32	793	3	gle_amed
gleaned	9	34	942	3	gle_aned
graced	10	52	1790	3	g__raced
graded	9	49	1955	3	g__raded
grated	8	45	2392	3	g__rated
graved	11	48	1881	3	g__raved
grayed	11	54	1564	3	g__rayed
grazed	17	41	1591	3	g__razed
greased	9	38	1239	3	gre_ased
greaved	12	40	891	3	gre_aved
guerdoned	12	4	192	3	guerdoned
gyrated	12	42	841	3	g_yrated
headed	11	40	2047	3	_he_aded
healed	10	51	2144	3	_he_aled
heaped	12	45	1690	3	_he_aped
hearsed	11	38	1140	3	_hearsed
hearted	11	33	1402	3	_hearted
heated	10	45	2559	3	_he_ated
heaved	13	47	1786	3	_he_aved
helloed	11	35	1242	3	_helloed
herald	10	3	1134	3	_hera_ld
heralded	13	3	544	3	_heralded
herbaged	15	5	452	3	_herbaged
herbed	12	35	1345	3	_her_bed
herded	11	42	1564	3	_her_ded
heroes	9	49	2382	3	_her_oes
herried	11	35	1445	3	_herried
iterated	9	12	1382	3	iterated
operated	11	5	1222	3	operated
overaged	13	5	1167	3	overaged
overawed	15	7	997	3	overawed
phrased	13	8	738	3	ph_rased
phreaked	18	3	449	3	phreaked
sheafed	14	38	897	3	she_afed
sheared	11	45	1600	3	she_ared
sheaved	14	34	1163	3	she_aved
stereoed	9	3	788	3	stereoed
theroid	11	3	1340	3	ther_oid
thrawed	14	3	558	3	th_rawed
threaded	13	6	632	3	threaded
threaped	14	5	486	3	threaped
threated	12	5	920	3	threated
unerased	9	3	1277	3	unerased
wherried	15	17	501	3	wherried
zeroed	16	40	941	3	_zer_oed

Search took 8 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	146162	0.406	440125.6
2	DLD Change Limit	146162	66	7.263	20124.2
3	Display Results	66	66	0.033	2000.0
	(SQL Overall)	178691	66	7.702	23200.6