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

516 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
cone6725696(None) 
bone65949321bone
cane66653111cane
cine66242941cine
clone75728161clone
code77347731code
coke107038381coke
cole66956111cole
come87547701come
con510268021con_
coned86040051coned
cones76457421cones
coney105932881coney
conge85227591conge
coni65534801coni
conk106531441conk
conn66229131conn
cons66057691cons
conte76633201conte
cony96537831cony
cope86847381cope
core67263111core
cote66648731cote
cove95837071cove
crone75231331crone
done55747911done
gone55639041gone
hone77549321hone
lone45849131lone
none45743171none
one37050911_one
pone65747531pone
scone74621831scone
sone46649981sone
tone46953741tone
zone135231081zone
acne66625872acne
agone65924552agone
alone55732962alone
ancone83916952ancone
ane37866942_ane
atone56527982atone
axone125918472axone
bane65250422bane
bene66439492bene
bine66650852bine
bode75838752bode
bole66448692bole
bond75334362bond
boned85133242boned
boner75133082boner
bones76446532bones
boney105227312boney
bong75633412bong
bonk105531712bonk
bonne75124712bonne
bony96732082bony
bonze165119352bonze
bore66051332bore
borne77926792borne
cade76443912cade
cafe95230322cafe
cage75339062cage
cake105439962cake
came87648752came
can57760132can_
caned85838092caned
caner75334772caner
canes75350372canes
canoe75627252canoe
cans65050842cans
cant66362022cant
cape87242782cape
care66968372care
case65848082case
cate66254592cate
cave95941262cave
cede74928762cede
cee55952702c_ee
cense75121402cense
cent67451012cent
cepe84926652cepe
cere66741472cere
cete64934782cete
chine105231722chine
choke145118022choke
chon96627792chon_
chore105126762chore
chose105925402chose
cines75239682cines
cion613330912cion_
cions75222852cions
cire65836372cire
cite65640342cite
cline76428532cline
clon66232482clon_
cloned94518802cloned
cloner84418092cloner
clones84526562clones
clonk114417442clonk
clons75228132clons
close76425222close
clove105619442clove
cloze165517542cloze
clue65324532clue
coal66939252coal
coat67558342coat
coax136922972coax
cob710258752co_b
cobb106421992cobb
coble94823172coble
cobs87043142cobs
coca88030642coca
cock126332902cock
coco87330602coco
cod69660122co_d
coda77029342coda
codec107120342codec
coded95433182coded
coden86128542coden
coder86134212coder
codes86247292codes
codex155817572codex
cods76848102cods
coed77140542coed
coff126930782coff
coft97939682coft
cog69552902co_g
cogs77340032cogs
coho97524492coho
cohune1189422cohune
coif96337902coif
coigne94612192coigne
coil66439652coil
coin66645352coin
coined94523602coined
coiner84323782coiner
coins75834552coins
coir66327242coir
coked124730692coked
cokes115537192cokes
coky137526822coky
col59360352co_l
cola66541392cola
cold77338772cold
coled85540752coled
coles76055062coles
colone85425002colone
cols66553082cols
colt67158242colt
coly96940532coly
coma87134852coma
comae97128422comae
comb106632112comb
combe116223542combe
comer95832692comer
comes97246992comes
comet95946072comet
comp106731252comp
comte96125472comte
conch124620072conch
condo85322592condo
coneys115218422coneys
confer114018682confer
conga85419872conga
congee96024462congee
conger95024272conger
conges94928172conges
congo85623132congo
conic95329792conic
conies84338592conies
conin76232722conin
conine84528552conine
conked135019112conked
conker124721552conker
conks115525702conks
conky145818742conky
conned95119702conned
conner84423962conner
conns75024232conns
contes84432912contes
conto76027172conto
conus76726532conus
convex18367742convex
convey144610222convey
coo59566362co_o
cooed84534342cooed
cooee74531022cooee
cooer74831012cooer
cooey105828222cooey
coof96643272coof
cook107236932cook
cool66940492cool
coon67248942coon
coons76737282coons
coop87238652coop
coos67456492coos
coot67860382coot
cop711162372co_p
coped105036842coped
copen94826432copen
coper95336092coper
copes97747102copes
cops86751372cops
copse95623922copse
copy116229802copy
cor59960942co_r
cord76740922cord
cored85044222cored
corer75538872corer
cores76361852cores
corf95941482corf
cork106635692cork
corm85735372corm
corn69945812corn
cornea84018922cornea
corned95224522corned
cornel84020052cornel
corner84625622corner
cornet84436732cornet
corns76034762corns
cornu75921322cornu
corny106023272corny
cors66656442cors
corse75036182corse
cory96941512cory
cos510270392co_s
cosec96320182cosec
coses76949492coses
coset75748842coset
cosey106226712cosey
cosh96127622cosh
cosie74728262cosie
cosine83823512cosine
coss66143492coss
cost68057942cost
cosy97232702cosy
cot510483222co_t
coted85033852coted
cotes76347842cotes
cots68054842cots
coude85022632coude
count74932052count
coup86729792coup
coupe96023482coupe
coved115027372coved
coven106925042coven
cover105430772cover
coves105539172coves
covet105638942covet
covey136121782covey
cow89856712co_w
cowed115637842cowed
cower104531772cower
cowl97530812cowl
cows97046642cows
cowy126427362cowy
cox1210346782co_x
coxa136922962coxa
coxae146115182coxae
coxed154322812coxed
coxes145430862coxes
coy810557552co_y
coyed114623802coyed
coyer105222842coyer
coys97537242coys
coz149345362co_z
cozen165019702cozen
cozes166033242cozes
cozey196718542cozey
cozie163519122cozie
cozy185823802cozy
crane75331602crane
crones84729242crones
crony105918672crony
crore74922862crore
croze164719452croze
cube85830212cube
cue57544182c_ue
cuke105824982cuke
cunt66243672cunt
cure66149122cure
cute66440452cute
cyme119420372cyme
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
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
icon66922042icon_
icones84616382icones
icons76516492icons
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
ochone11311292ochone
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
ozone14310612ozone
pane64950282pane
phone105621932phone
pine67755712pine
poke105335362poke
pole65951302pole
pome85636692pome
ponce95222512ponce
pond75530492pond
pones74547042pones
pong76231142pong
pons65850602pons
pony96434052pony
pope85535612pope
pore66451262pore
pose66441732pose
prone75332622prone
robe65335642robe
rode55844302rode
roe36861072ro_e
role45851822role
rope65542912rope
rose46148902rose
rote46249022rote
roue45941742roue
rove75136982rove
rune45236292rune
sane45954332sane
scene77220572scene
sconce104711722sconce
scones84521302scones
scope94821482scope
score75526732score
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
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.0802233637.5
2DLD Change Limit298725160.95331345.2
3Display Results5165160.1403685.7
 (SQL Overall)1786915161.173152336.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.