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

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

61 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
hexapod	20	4	365	(None)
hexapods	21	4	340	1	hexapods
hexapody	24	4	231	1	hexapody
decapod	13	3	543	2	decapod
heaped	12	45	1690	2	he_aped
hexad	16	49	1062	2	hexa__d
hexagon	18	4	382	2	hexagon
hexapla	19	4	334	2	hexapla
hexaploid	22	10	384	2	hexaploid
megapod	13	4	489	2	megapod
apod	7	81	2318	3	___apod
cheapo	13	48	1008	3	che_apo_
cheapos	14	41	851	3	che_apos
chenopod	16	4	394	3	chenopod
decapods	14	4	462	3	decapods
elapid	9	3	954	3	_elapid
exapted	17	3	607	3	_exapted
expand	16	23	657	3	_expand
expo	13	4	918	3	_ex_po_
expos	14	4	920	3	_ex_pos
head	8	71	3717	3	he_a__d
headed	11	40	2047	3	he_aded
healed	10	51	2144	3	he_aled
heap	9	64	3289	3	he_ap__
heaper	11	41	1952	3	he_aper
heaps	10	52	2322	3	he_ap_s
heapy	13	59	1498	3	he_ap_y
heard	9	52	2275	3	he_a_rd
heated	10	45	2559	3	he_ated
heaved	13	47	1786	3	he_aved
helipad	13	4	472	3	helipad
helped	12	47	1415	3	he_lped
hemagog	14	4	407	3	hemagog
hematoid	14	4	975	3	hematoid
herald	10	3	1134	3	hera_ld
hexachord	25	5	260	3	hexachord
hexade	17	43	890	3	hexa_de
hexades	18	37	870	3	hexades
hexadic	20	4	541	3	hexadic
hexads	17	46	819	3	hexa_ds
hexagons	19	4	394	3	hexagons
hexane	16	37	953	3	hexa_ne
hexanes	17	31	946	3	hexanes
hexaplar	20	4	225	3	hexaplar
hexaplas	20	4	352	3	hexaplas
hexaploids	23	12	337	3	hexaploids
hexaploidy	26	11	238	3	hexaploidy
hexapodies	23	5	282	3	hexapod~~ies~~
hexed	16	56	1576	3	hex__ed
leaped	9	43	1777	3	le_aped
megapode	14	4	430	3	megapode
megapods	14	4	490	3	megapods
reaped	9	41	2245	3	re_aped
retaped	10	38	1428	3	retaped
seedpod	11	4	401	3	seedpod
sexpot	15	3	954	3	sex_pot
teapot	8	4	1676	3	te_apot
teapoy	11	3	811	3	te_apoy
tetrapod	11	4	512	3	tetrapod
theropod	14	4	543	3	theropod
weapon	11	28	811	3	we_apon

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	134027	0.406	440125.6
2	DLD Change Limit	134027	61	8.796	15237.3
3	Display Results	61	61	0.033	1848.5
	(SQL Overall)	178691	61	9.235	19349.3