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

321 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
zone13523108(None) 
bone65949321bone
cone67256961cone
done55747911done
gone55639041gone
hone77549321hone
lone45849131lone
none45743171none
one37050911_one
ozone14310611ozone
pone65747531pone
sone46649981sone
tone46953741tone
zine137036151zine
zona136321961zona
zonae145116441zonae
zoned154020261zoned
zoner144520341zoner
zones145528041zones
zonk175018621zonk
acne66625872acne
agone65924552agone
alone55732962alone
ane37866942_ane
atone56527982atone
axone125918472axone
azine146721412azine
azole145118032azole
azon135725052azon_
azons146518252azons
azote144416342azote
bane65250422bane
bene66439492bene
bine66650852bine
bizone1738602bizone
bode75838752bode
bole66448692bole
bond75334362bond
boned85133242boned
boner75133082boner
bones76446532bones
boney105227312boney
bong75633412bong
bonk105531712bonk
bonne75124712bonne
bony96732082bony
bonze165119352bonze
bore66051332bore
borne77926792borne
cane66653112cane
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
erne46727422erne
esne47018792esne
evzone1894682evzone
eyne76322462eyne
fane75343562fane
fine75147952fine
foe66350812fo_e
fon66352272fon_
fond86330952fond
fons76943892fons
font77143752font
fore78351472fore
gane55145292gane
gene56237222gene
gonef95221292gonef
goner66025152goner
gong66827192gong
gore55744962gore
hoe67562722ho_e
hoke115935932hoke
hole77553392hole
home98042442home
hon67759382hon_
honed95332262honed
honer85332092honer
hones88144492hones
honey115629912honey
hong85833952hong
honk116931192honk
hons77350782hons
hope96639672hope
hose76547242hose
hove107132222hove
howe106734102howe
ion36051022ion_
ions46737852ions
irone55126362irone
jane115031472jane
joe106642352jo_e
joke155926162joke
jole117233822jole
jones125028182jones
kane85133962kane
kine85643422kine
koine9516482koine
konk79320612konk
kore85834162kore
krone94018732krone
kune85424572kune
lane45153322lane
leone55018822leone
line46965572line
lobe65535362lobe
lode56240112lode
loge56837192loge
loner55431032loner
long56933342long
longe66626462longe
lope65941922lope
lore45850352lore
lose45144582lose
love75234762love
lowe75435312lowe
lune47140492lune
mane65052012mane
mine67256152mine
mode75840302mode
moke106234222moke
mole66251832mole
mome85239352mome
mon57561572mon_
monde85723142monde
money104826842money
monie75631652monie
monk105928512monk
mono66036712mono
mons68152252mons
monte75829772monte
mony96830002mony
mope86838042mope
more67154522more
mote67048082mote
moue65835572moue
move96630722move
ne27045102__ne
nene45932062nene
nine45842172nine
node513036882node
nome66038422nome
nona46929062nona
nonce75719822nonce
nones55639132nones
nonet54540842nonet
nope65934192nope
nose46739362nose
note46239962note
obe56638642_obe
ode47446582_ode
oe28473062_o_e
oke75839482_oke
ole37155212_ole
on28057182_on_
once65423082_once
ones46146532_ones
ono36838032_ono
ons36148512_ons
ooze136420602ooze
ope56845242_ope
ore36661832_ore
ose38147342_ose
owe67041032_owe
ozones1539392ozones
pane64950282pane
phone105621932phone
pine67755712pine
poke105335362poke
pole65951302pole
pome85636692pome
ponce95222512ponce
pond75530492pond
pones74547042pones
pong76231142pong
pons65850602pons
pony96434052pony
pope85535612pope
pore66451262pore
pose66441732pose
prone75332622prone
rezone153814782rezone
robe65335642robe
rode55844302rode
roe36861072ro_e
role45851822role
rope65542912rope
rose46148902rose
rote46249022rote
roue45941742roue
rove75136982rove
rune45236292rune
sane45954332sane
scone74621832scone
sene46848052sene
shone83725972shone
sine46560622sine
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
vane75534682vane
vine75643682vine
voe67739052vo_e
vole75236982vole
vote74728622vote
wane76344712wane
wine74953422wine
woe66651242wo_e
woke115527962woke
won66252062won_
wonk116125302wonk
wons74942042wons
wont75842502wont
wore77144672wore
wove105624312wove
yoke115626392yoke
yon67348952yon_
yond86122312yond
yoni77524392yoni
yore76335942yore
yowe106728742yowe
zany167316982zany
zee126143232z_ee
zin125643772zin_
zinc156819092zinc
zineb165614142zineb
zines145232652zines
zing145728612zing
zins135735002zins
zlote143912942zlote
zoa128529992zo_a
zoea137118422zoea
zoeae144412482zoeae
zoic152316072zoic
zonal145116852zonal
zonate154114922zonate
zoners155115992zoners
zonked20429472zonked
zonks184815172zonks
zonule1577482zonule
zoo126238912zo_o
zooey173914802zooey
zoom156722102zoom
zoon137326982zoon
zooned164011082zooned
zoons144919692zoons
zoos135828802zoos
zori137722922zori
zouk174413542zouk
zowie174313842zowie
zyme1819114942zyme

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.0602978183.3
2DLD Change Limit298723210.94031778.7
3Display Results3213210.0764223.7
 (SQL Overall)1786913211.076166069.7
 
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.