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

377 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
none4574317(None) 
bone65949321bone
cone67256961cone
done55747911done
gone55639041gone
hone77549321hone
lone45849131lone
nene45932061nene
nine45842171nine
node513036881node
nome66038421nome
nona46929061nona
nonce75719821nonce
nones55639131nones
nonet54540841nonet
nope65934191nope
nose46739361nose
note46239961note
one37050911_one
pone65747531pone
sone46649981sone
tone46953741tone
zone135231081zone
acne66625872acne
agone65924552agone
alone55732962alone
ancone83916952ancone
ane37866952_ane
anode65021042anode
anole55330382anole
anon46134852anon_
anyone94612732anyone
atone56527982atone
axone125918472axone
bane65250432bane
bene66439492bene
bine66650862bine
bode75838752bode
bole66448692bole
bond75334362bond
boned85133242boned
boner75133082boner
bones76446532bones
boney105227312boney
bong75633412bong
bonk105531712bonk
bonne75124712bonne
bony96732082bony
bonze165119352bonze
bore66051332bore
borne77926792borne
cane66653122cane
cine66242942cine
clone75728162clone
code77347732code
coke107038382coke
cole66956112cole
come87547702come
con510268022con_
coned86040052coned
cones76457422cones
coney105932882coney
conge85227592conge
coni65534802coni
conk106531442conk
conn66229132conn
cons66057692cons
conte76633202conte
cony96537832cony
cope86847382cope
core67263112core
cote66648732cote
cove95837072cove
crone75231332crone
dene56643412dene
dine55555332dine
doe47361952do_e
doge66233802doge
dole56550002dole
dome77240732dome
don46757652don_
dona55529632dona
donee66931012donee
dong66031652dong
donne65520462donne
dons56048702dons
dope76038892dope
dore56353302dore
dose56442432dose
dote55442882dote
dove85131562dove
doze145829082doze
drone65324982drone
dune56137582dune
dyne85320932dyne
eon36052082eon_
eons46638712eons
erne46727432erne
esne47018792esne
eyne76322462eyne
fane75343572fane
fine75147952fine
foe66350812fo_e
fon66352272fon_
fond86330952fond
fons76943892fons
font77143752font
fore78351472fore
gane55145302gane
gene56237222gene
gnome84213952gnome
gonef95221292gonef
goner66025162goner
gong66827192gong
gore55744962gore
hoe67562722ho_e
hoke115935932hoke
hole77553392hole
home98042442home
hon67759382hon_
honed95332262honed
honer85332092honer
hones88144492hones
honey115629912honey
hong85833952hong
honk116931192honk
hons77350782hons
hope96639672hope
hose76547242hose
hove107132222hove
howe106734102howe
inane52820342inane
intone61115432intone
ion36051022ion_
ionone6313442ionone
ions46737852ions
irone55126362irone
jane115031482jane
joe106642352jo_e
joke155926162joke
jole117233822jole
jones125028182jones
kane85133972kane
kine85643432kine
koine9516482koine
konk79320612konk
kore85834162kore
krone94018732krone
kune85424572kune
lane45153332lane
leone55018822leone
line46965572line
lobe65535362lobe
lode56240112lode
loge56837192loge
loner55431042loner
long56933342long
longe66626462longe
lope65941922lope
lore45850352lore
lose45144582lose
love75234762love
lowe75435312lowe
lune47140492lune
mane65052032mane
mine67256172mine
mode75840302mode
moke106234222moke
mole66251832mole
mome85239352mome
mon57561582mon_
monde85723142monde
money104826842money
monie75631652monie
monk105928522monk
mono66036722mono
mons68152262mons
monte75829772monte
mony96830012mony
mope86838042mope
more67154522more
mote67048082mote
moue65835572moue
move96630722move
nabe66029492nabe
nae35952742n_ae
name65637412name
nan37854882nan_
nana46632902nana
nance74721842nance
nans46139402nans
nape65230802nape
nave75732312nave
ne27045102__ne
nee36657782n_ee
nenes55329672nenes
neon47026422neon_
neoned7311482neoned
neons55818682neons
neve76224832neve
nice65534712nice
nide55535792nide
nines55937342nines
nite45943582nite
nixe115722022nixe
no29353242no__
nob58954422no_b
noble74420992noble
nobs66436902nobs
nock106127182nock
nod47549562no_d
nodes64633492nodes
nodi56626742nodi
nods55838222nods
noel45226552noel
noes45845392noes
nog46847312no_g
nogg65115942nogg
nogs56534612nogs
noh66640642no_h
noil46133242noil
noir46722432noir
noise55723732noise
nolo46229312nolo
nom510450642no_m
noma67529462noma
nomen75621622nomen
nomes74933122nomes
noms65636402noms
nonage7313682nonage
nonas55126652nonas
nonces84418832nonces
nonego737012nonego
nonets64118702nonets
nonmen8412832nonmen
nonuse63212252nonuse
nonyl849772nonyl
noo37154042no_o
nook85728492nook
noon47134622noon
noons54125282noons
noose55624062noose
nor38048822no_r
nori47133142nori
norm66429812norm
nos38859322no_s
nosed65524552nosed
noses55435642noses
nosey85619882nosey
nosh76223542nosh
nosy76322892nosy
not39474662no_t
nota46830772nota
noted65123842noted
noter55025642noter
notes55034582notes
noun45724182noun
nouns56717312nouns
nous46136982nous
nova76518952nova
novae85913122novae
novel85615992novel
now65950192no_w
nows75738232nows
nowt78833752nowt
nude56626272nude
nuke85920752nuke
nun35537742nun_
nuns45228232nuns
obe56638642_obe
ode47446582_ode
oe28473062_o_e
oke75839482_oke
ole37155212_ole
on28057182_on_
once65423082once
ones46146532_ones
ono36838032_ono
ons36148512_ons
ooze136420602ooze
ope56845242_ope
ore36661832_ore
ose38147342_ose
owe67041032_owe
ozone14310612ozone
pane64950292pane
phone105621932phone
pine67755712pine
poke105335362poke
pole65951302pole
pome85636692pome
ponce95222512ponce
pond75530492pond
pones74547042pones
pong76231142pong
pons65850602pons
pony96434052pony
pope85535612pope
pore66451262pore
pose66441732pose
prone75332622prone
robe65335642robe
rode55844302rode
roe36861082ro_e
role45851822role
rope65542912rope
rose46148902rose
rote46249022rote
roue45941742roue
rove75136982rove
rune45236302rune
sane45954342sane
scone74621832scone
sene46848052sene
shone83725982shone
sine46560622sine
snore55424952snore
soke85436262soke
sole46053672sole
some66040382some
son37761952son_
sonde64622832sonde
sones55444142sones
song55133672song
sons46049552sons
sore47059532sore
stone55431182stone
syne75725762syne
tine45855132tine
toe310166852to_e
toke86738492toke
tole46052902tole
tome67543192tome
ton310265102ton_
toned65435342toned
toner55336242toner
tones56048662tones
toney86027412toney
tong56434352tong
tonne54921432tonne
tons46553052tons
tony75635152tony
tope65946382tope
tore47359322tore
tote46643672tote
trone55131862trone
tune45635862tune
tyne76325052tyne
undone7914252undone
vane75534692vane
vine75643682vine
voe67739052vo_e
vole75236982vole
vote74728622vote
wane76344722wane
wine74953422wine
woe66651242wo_e
woke115527962woke
won66252062won_
wonk116125302wonk
wons74942042wons
wont75842502wont
wore77144672wore
wove105624312wove
yoke115626392yoke
yon67348952yon_
yond86122312yond
yoni77524392yoni
yore76335942yore
yowe106728742yowe
zine137036152zine
zona136321962zona
zonae145116442zonae
zoned154020262zoned
zoner144520342zoner
zones145528042zones
zonk175018622zonk

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.266671770.7
2DLD Change Limit298723770.93631914.5
3Display Results3773770.0934053.8
 (SQL Overall)1786913771.295137985.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.