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 “need” 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.

313 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
need5493415(None) 
deed65340901deed
feed84538901feed
geed65435501geed
heed86437601heed
jeed125428501jeed
kneed104612051kneed
meed74934701meed
nee36657781nee_
needs65719631needs
needy94614691needy
neem67328081neem
neep65728311neep
nerd56624941nerd
peed76239181peed
reed55549621reed
seed55549481seed
teed55439261teed
weed85637511weed
abed79734132abed
aced79540882aced
aged67334252aged
ahed89536252ahed
aneled74719272aneled
anted66328242anted
anteed75616112anteed
aped78538152aped
awed88436032awed
axed128829612axed
bead75937922bead
bed67950622_bed
bee56262402bee_
beedi8711662beedi
beef96233682beef
been65335782been
beep85931212beep
beer65635992beer
bees65453382bees
beet66457542beet
bend76435262bend
bled75729312bled
bleed85019802bleed
bred75130972bred
breed85526692breed
cede74928762cede
ceded96118552ceded
cee55952702cee_
cees65941592cees
cered85227442cered
coed77140542coed
cred76530882cred
creed85727392creed
cued76329562cued
dead65434242dead
dee47665822dee_
deeds75423762deeds
deedy104315892deedy
deem75432892deem
deep76031882deep
deer56739022deer
dees56356632dees
deet57356582deet
deked115718532deked
deled75326542deled
dewed105020302dewed
died66137852died
dreed75222842dreed
dyed96720762dyed
ed38645182__ed
eek77935102_eek
eel37946842_eel
eked96718022eked
eld46733792_eld
end46834352_end
ended74421262ended
exed125420592exed
eyed86623232eyed
fed76548352_fed
fee66862012fee_
feeb96924542feeb
feeds94921142feeds
feel75233842feel
fees76450602fees
feet75352212feet
fend84832972fend
feod815523002feod
feted94420932feted
feud86523022feud
feued94715662feued
fled85429772fled
freed95223542freed
gaed66031512gaed
ged57044532_ged
gee45359202gee_
geek95327022geek
gees55647882gees
geez146424862geez
geld65828432geld
gied64631982gied
gled65631142gled
gleed75320572gleed
greed75125692greed
haed86338582haed
head87137172head
heeds95420422heeds
heel75034222heel
held85330402held
herd84933062herd
hewed125619432hewed
hexed165615762hexed
hied85434042hied
hoed87837982hoed
hued86925852hued
iced78721892iced
indeed83913562indeed
inked104218522inked
inned64118422inned
ired55131872ired
jee106648642jee_
jeep135624842jeep
jeer115426462jeer
jees115938542jees
jeez205622032jeez
jewed165114832jewed
keef115829992keef
keek75624962keek
keel85729462keel
keen84830402keen
keep106329812keep
keet85347332keet
keyed1369382keyed
knead10429662knead
knee85323602knee_
kneel95012032kneel
knees95114872knees
lead56038852lead
led46254552_led
lee36068142lee_
leek85331732leek
leer46239352leer
lees45455882lees
leet45957902leet
lend56233672lend
leud57223422leud
lewd85716592lewd
lied55838092lied
mead75531602mead
med66146742_med
meeds84920272meeds
meek105624832meek
meet65350552meet
meld75830472meld
mend75334022mend
meted85424432meted
mewed115218012mewed
nae35952742nae_
naked105320852naked
naled65525052naled
named85223062named
nard56634452nard
ne27045102n_e_
neap66927012neap
near45236502near
neared75119802neared
neat46356782neat
neb57238622n_eb
nebs66124982nebs
neck105423662neck
necked134715062necked
neddy10479872neddy
needed84114442needed
needer73614952needer
needle73310612needle
neems77316292neems
neeps75617882neeps
neg47237342n_eg
negs55727362negs
neif75429492neif
nema65522522nema
nene45932062nene
nenes55329672nenes
neon47026422neon
neoned7311482neoned
nerds65719252nerds
nerdy95014702nerdy
nereid7312922nereid
nerved104111682nerved
ness45526562ness
nest45548732nest
nested74720062nested
net36670292n_et
nets45941532nets
nett46643232nett
netted74118712netted
neuk87416602neuk
neum66723082neum
neve76224832neve
never86218642never
neves87021872neves
nevi75116422nevi
new66237092n_ew
newel86114132newel
newer85717462newer
news76127372news
newt76933742newt
next116631082next
nide55535782nide
nided75920872nided
nixed135714222nixed
nod47549562n_od
node513036882node
noel45226552noel
noes45845392noes
nosed65524552nosed
noted65123842noted
nude56626272nude
nuked104014182nuked
nurd56224342nurd
ohed87825182ohed
oped76230152oped
owed86833872owed
ped66751522_ped
pee56066512pee_
peek106031432peek
peel65535612peel
peen65938082peen
peep85833692peep
peer66238352peer
pees65257372pees
pend75934532pend
pied75035362pied
pled75231432pled
preed85128112preed
read55942532read
red46755802_red
redd66323172redd
rede55037662rede
reded74829112reded
ree37974072ree_
reeds65430902reeds
reedy910020282reedy
reef74938212reef
reek85232522reek
reel45240532reel
rees45364192rees
refed93921922refed
rend56136572rend
rewed95425452rewed
rued55729792rued
see35772262see_
seeds64330062seeds
seedy94821532seedy
seek85935482seek
seel45042982seel
seem65438562seem
seen46943122seen
seep66540342seep
seer45547042seer
sees45361052sees
send55237292send
sered65737292sered
sewed95325162sewed
sexed136618542sexed
shed86536152shed
skeed105018982skeed
sled55334372sled
sned56026052sned
sneer54919952sneer
sped76031492sped
speed85526622speed
steed66024942steed
sued56537932sued
ted46446562_ted
tee38366872tee_
teel46335802teel
teem66132602teem
teen45938202teen
tees45353582tees
tend56433772tend
tewed94718532tewed
tied55535212tied
toed56137042toed
treed65626732treed
tweed94915092tweed
unfed94614222unfed
unled64021072unled
unwed94114872unwed
used55722822used
vee65750182vee_
veep95325092veep
veer76229572veer
vees75439432vees
veld85323202veld
vend86626422vend
vexed165713112vexed
vied86328632vied
wed75843622_wed
wee66760812wee_
weeds95222212weeds
weedy125115002weedy
week116428152week
weel75834082weel
ween75835462ween
weep95131652weep
weer75535092weer
wees76249122wees
weet75254152weet
weld84727732weld
wend85330452wend
yeld811423872yeld
zed135431172_zed
zee126143232zee_
zees136331892zees

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.0762351197.4
2DLD Change Limit298723131.09627255.5
3Display Results3133130.0764118.4
 (SQL Overall)1786913131.248143181.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.