Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

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

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

175 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
exed12542059(None) 
axed128829611axed
eked96718031eked
exec135313941exec
exes116530811exes
eyed86623231eyed
hexed165615761hexed
sexed136618541sexed
vexed165713111vexed
abed79734132abed
aced79540882aced
aged67334252aged
ahed89536252ahed
aped78538152aped
awed88436032awed
axe108239492axe_
axel115222072axel
axes117337852axes
axled135315812axled
bed67950632_bed
bled75729312bled
boxed154318612boxed
bred75130972bred
ceded96118562ceded
cered85227442cered
coed77140542coed
coxed154322812coxed
cred76530882cred
cued76329562cued
deed65340902deed
deked115718532deked
deled75326542deled
dewed105020302dewed
dexes135224512dexes
died66137862died
dyed96720762dyed
eared65139502eared
eased65430402eased
eaved95924502eaved
ebbed104111002ebbed
eched116919222eched
ed38645192__ed
edged85514532edged
eek77935102e_ek
eel37946842e_el
egad64215412egad
eger55923572eger
egged85114392egged
eide55832252eide
eke75630092eke_
ekes86726602ekes
eld46733802e_ld
embed105014302embed
eme55837182eme_
emend86214892emend
emes65434662emes
emeu66723432emeu
emyd1047072emyd
end46834362e_nd
ended74421262ended
epee64628502epee
ere36352772ere_
erred65915672erred
eses45336102eses
eve66331162eve_
even75222272even
ever77027692ever
eves76230462eves
ewe66630982ewe_
ewer77523982ewer
ewes76328702ewes
ex98835642ex__
exam132514622exam
exceed1636172exceed
excel1437742excel
execs14539722execs
exedra1434502exedra
exert124624142exert
exiled144712462exiled
exit114428672exit
exited144712522exited
exon117116802exon
expel1448232expel
expend16247502expend
expo1349182expo
extend14267522extend
exude134010292exude
exuded15317682exuded
eye65539772eye_
eyen76223662eyen
eyer76127282eyer
eyes75837882eyes
faxed166220532faxed
fed76548362_fed
feed84538902feed
feted94420932feted
feued94715662feued
fixed165416952fixed
fled85429772fled
flexed17419092flexed
foxed165115212foxed
gaed66031512gaed
ged57044542_ged
geed65435502geed
gied64631992gied
gled65631142gled
haed86338582haed
heed86437602heed
hewed125619432hewed
hexad164910622hexad
hexer155116682hexer
hexes155123042hexes
hied85434052hied
hoed87837982hoed
hued86925852hued
iced78721892iced
ired55131872ired
jeed125428502jeed
jewed165114832jewed
kexes166216822kexes
keyed1369392keyed
led46254562_led
lexes127225262lexes
lied55838102lied
loxed135017052loxed
maxed155821192maxed
med66146752_med
meed74934702meed
meted85424432meted
mewed115218012mewed
mixed155717252mixed
need54934152need
nixed135714222nixed
ohed87825182ohed
oped76230152oped
owed86833872owed
oxen116218592oxen
oxes116530722oxes
oxid12815492oxid
ped66751532_ped
peed76239182peed
pied75035372pied
pled75231432pled
poxed154817862poxed
raxed135622662raxed
red46755812_red
reded74829122reded
reed55549622reed
refed93921922refed
rewed95425452rewed
rexes124526952rexes
rued55729792rued
seed55549482seed
sered65737292sered
sewed95325162sewed
sexes126126222sexes
shed86536152shed
sled55334372sled
sned56026052sned
sped76031492sped
sued56537932sued
taxed135620292taxed
ted46446572_ted
teed55439262teed
tewed94718532tewed
tied55535222tied
toed56137042toed
used55722822used
vexer155513522vexer
vexes155719122vexes
vied86328642vied
waxed166018482waxed
wed75843632_wed
weed85637512weed
zed135431182_zed

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691298720.296603685.8
2DLD Change Limit298721750.81336742.9
3Display Results1751750.0305833.3
 (SQL Overall)1786911751.139156884.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.