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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

253 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
desorb	9	52	1020	(None)
desorbs	10	43	771	1	desorbs
resorb	8	49	1434	1	resorb
absorb	10	3	801	2	absorb
adsorb	9	4	695	2	adsorb
decor	8	47	1757	2	decor_
decors	9	40	1777	2	decors
deform	12	5	961	2	deform
dehorn	10	43	965	2	dehorn
dehort	10	46	1810	2	dehort
demob	10	49	1350	2	demo_b
deport	9	49	2239	2	deport
descry	12	5	618	2	descry
desert	7	27	2549	2	desert
desire	7	4	1530	2	desire
desorbed	12	3	644	2	desorbed
desoxy	17	4	462	2	desoxy
deworm	12	4	952	2	deworm
resorbs	9	50	1052	2	resorbs
resort	6	57	2861	2	resort
sorb	6	83	3304	2	__sorb
absorbs	11	3	561	3	absorbs
adsorbs	10	4	471	3	adsorbs
assort	6	49	1638	3	assort
bedsore	10	5	780	3	bedsore
before	11	4	1015	3	before
besom	9	57	1697	3	beso_m
besoms	10	57	1273	3	besoms
besot	7	64	2971	3	beso_t
besots	8	64	1545	3	besots
bevor	10	15	1081	3	bevor_
bevors	11	16	1034	3	bevors
beworm	13	3	998	3	beworm
censor	8	40	1128	3	censor_
censors	9	36	1183	3	censors
ceorl	7	4	1091	3	ce_orl
cesura	8	3	876	3	cesura
darb	7	60	3353	3	d__arb
deair	6	58	1719	3	deair_
deairs	7	40	1378	3	deairs
dear	5	53	4360	3	de_ar_
dears	6	57	3688	3	de_ars
deary	9	58	2684	3	de_ary
deb	6	63	4269	3	de___b
debar	8	55	1786	3	debar_
debark	13	42	1094	3	debark
debars	9	42	1804	3	debars
debone	9	37	1478	3	debone
debtor	9	3	833	3	debtor_
debtors	10	3	853	3	debtors
decare	9	39	1915	3	decare
decern	9	13	1095	3	decern
deco	7	61	2597	3	deco__
decoct	11	3	1378	3	decoct
decode	10	44	1474	3	decode
decorum	12	4	694	3	decorum
decos	8	55	2212	3	deco_s
decoy	11	57	1631	3	deco_y
decoys	12	39	1128	3	decoys
decry	11	55	1435	3	de_cry
decury	12	7	796	3	decury
deer	5	67	3902	3	de_er_
deers	6	49	3052	3	de_ers
defer	9	46	1975	3	defer_
defers	10	51	1694	3	defers
defoam	12	3	856	3	defoam
defog	10	4	852	3	defo_g
defogs	11	5	668	3	defogs
deforce	13	26	724	3	deforce
deforms	13	3	780	3	deforms
degerm	10	3	789	3	degerm
dehorns	11	42	836	3	dehorns
dehorts	11	37	977	3	dehorts
deiform	13	3	668	3	deiform
dekare	11	28	1156	3	dekare
delusory	12	7	300	3	delusory
demark	13	42	1102	3	demark
demo	7	74	2755	3	demo__
demobs	11	42	948	3	demobs
demode	10	40	1346	3	demode
demoed	10	37	1344	3	demoed
demon	8	65	2031	3	demo_n
demons	9	49	1772	3	demons
demos	8	60	2299	3	demo_s
demote	9	48	1780	3	demote
demur	8	3	1116	3	demur_
demure	9	3	1153	3	demure
demurs	9	3	977	3	demurs
denar	6	52	2329	3	denar_
denari	7	109	1735	3	denari
denars	7	46	2143	3	denars
denary	10	53	1686	3	denary
denote	7	41	1804	3	denote
denser	7	41	1519	3	denser_
deorbit	10	4	817	3	de_orbit
deoxy	16	4	888	3	de_oxy
depart	9	47	2056	3	depart
deperm	11	3	936	3	deperm
deplore	10	3	948	3	deplore
depone	9	36	1655	3	depone
deports	10	50	1288	3	deports
depose	9	42	1576	3	depose
depot	8	57	2792	3	depo_t
depots	9	47	1634	3	depots
derby	11	47	1534	3	de__rby
dere	5	68	4590	3	de__re
derisory	12	4	516	3	derisory
derm	7	60	3189	3	de__rm
derry	9	47	2137	3	de_rry
desalt	7	5	1831	3	desalt
desand	8	48	1263	3	desand
describe	13	4	624	3	describe
deserts	8	25	1305	3	deserts
deserve	11	10	870	3	deserve
desex	13	3	1198	3	des_ex
design	8	40	893	3	design
desired	9	3	1198	3	desired
desirer	8	3	1078	3	desirer
desires	8	13	1613	3	desires
desist	7	48	1881	3	desist
desk	9	56	1890	3	des__k
desks	10	59	1307	3	des_ks
desman	9	3	1169	3	desman
desmid	10	4	836	3	desmid
desmoid	11	3	710	3	desmoid
desorbing	13	4	636	3	desorb~~ing~~
despoil	10	4	652	3	despoil
despond	11	3	751	3	despond
despot	9	34	1329	3	despot
despots	10	31	968	3	despots
dessert	8	29	1645	3	dessert
destroy	11	3	815	3	destroy
deter	6	50	2804	3	deter_
deters	7	47	2468	3	deters
detour	7	7	819	3	detour
detours	8	5	804	3	detours
detox	13	3	1095	3	deto_x
devisor	11	35	704	3	devisor_
devisors	12	34	725	3	devisors
devoid	11	8	936	3	devoid
devoir	10	7	603	3	devoir
devoirs	11	7	578	3	devoirs
devon	9	51	1368	3	devo_n
devons	10	45	1225	3	devons
devote	10	45	1378	3	devote
devour	10	7	670	3	devour
devours	11	6	664	3	devours
devout	10	7	1299	3	devout
dewar	9	58	1773	3	dewar_
dewars	10	51	1707	3	dewars
dewool	10	4	740	3	dewool
deworms	13	3	802	3	deworms
dextro	14	3	612	3	dextro
dhoora	10	3	565	3	dhoora
disarm	9	3	1047	3	disarm
discord	11	3	999	3	discord
disown	10	3	695	3	disown
disport	10	10	1595	3	disport
disrobe	10	3	899	3	disrobe
distort	8	11	2033	3	distort
disturb	10	4	623	3	disturb
dolor	6	76	1796	3	dolor_
dolors	7	51	1531	3	dolors
donor	6	44	1819	3	donor_
donors	7	51	1579	3	donors
door	5	69	2851	3	d_oor_
doors	6	50	2213	3	d_oors
dor	4	72	5392	3	d__or_
dore	5	63	5330	3	d__ore
dork	9	65	3146	3	d__ork
dorm	7	68	3463	3	d__orm
dorp	7	60	2805	3	d__orp
dorr	5	66	2772	3	d__orr
dors	5	67	4760	3	d__ors
dory	8	58	3623	3	d__ory
doser	6	62	2856	3	doser_
dosers	7	57	2363	3	dosers
enorm	7	44	1563	3	_enorm
escort	8	46	1648	3	_escort
exurb	14	5	770	3	_exurb
eyesore	10	4	617	3	eyesore
fedora	10	3	859	3	fedora
femora	11	4	958	3	femora
fetor	8	12	1453	3	fetor_
fetors	9	10	1447	3	fetors
forb	9	71	3133	3	__forb
herb	9	47	3096	3	he__rb
kebob	13	51	1092	3	kebo_b
kerb	10	43	2271	3	ke__rb
lessor	6	40	1060	3	lessor_
lessors	7	36	1052	3	lessors
memory	13	3	880	3	memory
meson	7	41	1831	3	meso_n
mesons	8	32	1584	3	mesons
nestor	6	37	1342	3	nestor_
nestors	7	36	1497	3	nestors
orb	5	57	3686	3	___orb
peso	6	69	2582	3	peso__
pesos	7	72	2162	3	peso_s
presort	9	52	1953	3	presort
reabsorb	12	4	335	3	reabsorb
rebore	8	66	2564	3	rebore
reborn	8	100	1695	3	reborn
recomb	12	3	887	3	recomb
record	9	61	1742	3	record
recork	12	63	1548	3	recork
reform	11	3	1270	3	reform
remora	8	4	1458	3	remora
report	8	53	2601	3	report
rescore	9	56	1619	3	rescore
resoak	10	3	1109	3	resoak
resod	6	47	2005	3	reso_d
resods	7	41	1630	3	resods
resold	7	39	1536	3	resold
resole	6	46	2418	3	resole
resorbed	11	3	853	3	resorbed
resorts	7	48	1719	3	resorts
resow	8	82	1724	3	reso_w
resown	9	41	1292	3	resown
resows	9	39	1535	3	resows
restore	7	58	2297	3	restore
retore	6	76	3076	3	retore
retorn	6	109	2342	3	retorn
retort	6	68	3114	3	retort
reverb	11	39	1257	3	reverb
reword	10	63	2140	3	reword
rewore	9	380	3015	3	rewore
rework	13	66	1978	3	rework
reworn	9	81	2219	3	reworn
seisor	6	37	1233	3	seisor_
seisors	7	32	1283	3	seisors
senor	5	38	2279	3	senor_
senora	6	32	1615	3	senora
senors	6	36	2078	3	senors
sensor	6	38	1383	3	sensor_
sensors	7	35	1463	3	sensors
sensory	10	32	908	3	sensory
sob	5	78	5794	3	__so_b
sora	4	57	4691	3	__sora
sorbs	7	50	2210	3	__sorbs
sord	5	62	3720	3	__sord
sore	4	70	5953	3	__sore
sori	4	60	3984	3	__sori
sorn	4	66	4106	3	__sorn
sort	4	62	6481	3	__sort
tenor	5	36	2025	3	tenor_
tenors	6	32	1775	3	tenors
tensor	6	38	1267	3	tensor_
tensors	7	27	1237	3	tensors
verb	9	62	2487	3	ve__rb
vestry	12	3	862	3	vestry
visor	8	25	1283	3	visor_
visors	9	29	1222	3	visors

Search took 7 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	112716	0.220	812231.8
2	DLD Change Limit	112716	253	6.266	17988.5
3	Display Results	253	253	0.093	2720.4
	(SQL Overall)	178691	253	6.579	27160.8