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

Here are the results of your fuzzy-string dictionary search for “helper” with Change Limit: [1] [2] [3]

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.

97 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
helper	11	43	1309	(None)
heaper	11	41	1952	1	heaper
heller	9	33	2251	1	heller
helped	12	47	1415	1	helped
helpers	12	33	1185	1	helpers
hepper	13	34	1266	1	hepper
yelper	11	45	878	1	yelper
beeper	10	37	1409	2	beeper
belier	8	44	2356	2	belier
belter	8	47	2096	2	belter
cheaper	14	40	1058	2	cheaper
cheeper	14	36	1074	2	cheeper
deeper	9	36	1350	2	deeper
delver	10	49	1349	2	delver
eelier	6	42	1646	2	eelier
elder	6	40	2002	2	_elder
eloper	8	54	1415	2	_eloper
elver	8	52	1624	2	_elver
feller	9	44	1955	2	feller
gelder	8	46	1371	2	gelder
gulper	9	34	1021	2	gulper
haler	8	50	3352	2	hal_er
halter	9	44	2088	2	halter
hamper	13	45	1865	2	hamper
harper	11	50	1840	2	harper
header	10	44	2254	2	header
healer	9	42	2180	2	healer
heaped	12	45	1690	2	heaped
heapers	12	36	1667	2	heapers
hearer	9	43	2364	2	hearer
heater	9	48	2830	2	heater
heaver	12	48	1967	2	heaver
heder	9	56	2364	2	he_der
hedger	11	49	1265	2	hedger
heeder	10	42	1604	2	heeder
heeler	9	39	1731	2	heeler
hefter	12	43	1392	2	hefter
heifer	12	3	820	2	heifer
helled	10	40	2470	2	helled
helleri	10	38	997	2	helleri
hellers	10	36	1983	2	hellers
hellery	13	32	921	2	hellery
helmed	12	45	1369	2	helmed
helmet	11	37	1893	2	helmet
help	9	53	2892	2	help__
helps	10	52	1934	2	help_s
helve	11	50	1809	2	helve_
helved	13	43	1370	2	helved
helves	12	43	1606	2	helves
hemmer	13	41	1264	2	hemmer
hempen	13	3	896	2	hempen
hempier	14	31	900	2	hempier
herder	10	45	1646	2	herder
herpes	11	55	1732	2	herpes
hewer	11	57	1993	2	he_wer
hexer	15	51	1668	2	he_xer
hiller	9	44	2163	2	hiller
hipper	13	38	1802	2	hipper
holder	10	46	1965	2	holder
holier	9	49	2162	2	holier
holler	9	35	2061	2	holler
holpen	11	29	941	2	holpen
hooper	11	45	1831	2	hooper
hoper	10	58	2914	2	h_oper
hopper	13	42	1848	2	hopper
huller	9	39	1910	2	huller
humper	13	41	1588	2	humper
hyper	13	52	1390	2	h_yper
keeper	12	38	1192	2	keeper
kelped	13	44	955	2	kelped
kelter	10	32	1438	2	kelter
leaper	8	81	1894	2	leaper
leper	7	48	2074	2	le_per
melder	9	39	1581	2	melder
melter	8	35	2011	2	melter
peeper	10	36	1480	2	peeper
pelter	8	33	2162	2	pelter
pepper	9	35	1294	2	pepper
pulper	10	35	1327	2	pulper
reaper	8	42	2314	2	reaper
relier	6	58	2618	2	relier
seller	6	38	2459	2	seller
sheller	10	35	1588	2	sheller
shelter	10	32	1496	2	shelter
shelver	13	42	1106	2	shelver
telfer	9	37	989	2	telfer
teller	6	35	1981	2	teller
telpher	12	3	556	2	telpher
temper	10	39	1409	2	temper
vesper	11	3	808	2	vesper
weeper	11	43	1330	2	weeper
welder	10	29	1441	2	welder
welter	9	34	1738	2	welter
whelped	16	35	563	2	whelped
yeller	9	42	1451	2	yeller
yelped	12	43	936	2	yelped
yelpers	12	34	820	2	yelpers

Search took 4 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	82551	0.356	501941.0
2	DLD Change Limit	82551	97	2.596	31799.3
3	Display Results	97	97	0.030	3233.3
	(SQL Overall)	178691	97	2.982	59923.2