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

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

75 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
ransomer	10	4	788	(None)
ransomed	11	4	693	1	ransomed
ransomers	11	4	687	1	ransomers
capsomer	14	4	577	2	capsomer
handsomer	15	4	545	2	handsomer
ransom	8	24	1094	2	ransom__
ransoms	9	24	1016	2	ransom_s
winsomer	13	4	577	2	winsomer
annoyer	10	9	560	3	_annoyer
answer	9	3	689	3	_ans_wer
assumer	9	6	536	3	_assumer
canoer	8	51	2107	3	can_o_er
capsomere	15	4	336	3	capsomere
capsomers	15	4	475	3	capsomers
consoler	10	28	1261	3	consoler
consumer	12	3	850	3	consumer
fathomer	16	4	529	3	fathomer
gladsomer	13	4	300	3	gladsomer
grewsomer	15	4	249	3	grewsomer
gruesomer	12	4	300	3	gruesomer
handover	15	12	682	3	handover
handsome	14	4	760	3	handsome_
hangover	15	13	443	3	hangover
hansom	11	21	915	3	hansom__
hansoms	12	23	852	3	hansom_s
incomer	11	6	994	3	_incomer
ionomer	9	3	983	3	ion_omer
isomer	8	3	1015	3	__isomer
lassoer	7	37	938	3	lasso_er
manpower	15	4	470	3	manpower
misnomer	12	4	714	3	misnomer
monomer	11	3	1189	3	mon_omer
passover	13	13	553	3	passover
radiomen	11	4	663	3	radiomen
radome	9	5	1187	3	ra_dome_
radomes	10	3	1105	3	ra_domes
raiser	6	66	2010	3	rais__er
rammer	10	35	1965	3	ra__mmer
rancher	12	30	1363	3	ran_cher
ranchmen	15	4	583	3	ranchmen
rancor	8	8	1037	3	ranco__r
rancored	11	3	722	3	rancored
rancour	9	8	713	3	ranco_ur
randier	8	36	1847	3	ran_dier
random	9	25	1355	3	random__
randomizer	22	5	308	3	randomizer
randomly	14	4	379	3	randomly
randoms	10	21	1243	3	random_s
ranger	7	39	2552	3	ran__ger
rangier	8	37	1435	3	ran_gier
ranker	10	50	2190	3	ran__ker
ransacker	15	4	396	3	ransacker
ransoming	12	5	651	3	ransoming
ranter	6	38	2682	3	ran__ter
raser	5	56	3341	3	ra_s__er
rasher	9	50	2412	3	ra_s_her
rasper	8	39	1733	3	ra_s_per
raspier	9	31	1064	3	ra_spier
raster	6	47	3144	3	ra_s_ter
ratooner	8	8	700	3	ratooner
reasoner	8	4	934	3	reasoner
resumer	9	4	1011	3	r_esumer
rinser	6	43	1721	3	rins__er
roomer	8	47	1863	3	r__oomer
runover	10	3	466	3	run_over
tautomer	10	4	459	3	tautomer
transfer	11	3	843	3	trans_fer
transformer	16	5	487	3	transformer
transom	9	4	882	3	transom__
transoms	10	4	893	3	transom_s
unsober	9	6	764	3	_unsober
venomer	12	3	758	3	ven_omer
wagsome	13	4	521	3	wagsome_
wantoner	11	8	756	3	wantoner
winsome	12	3	746	3	winsome_

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.156	1145455.1
2	DLD Change Limit	146162	75	7.783	18779.6
3	Display Results	75	75	0.030	2500.0
	(SQL Overall)	178691	75	7.969	22423.3