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

473 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
lone4584913(None) 
alone55732961alone
bone65949321bone
clone75728161clone
cone67256961cone
done55747911done
gone55639041gone
hone77549321hone
lane45153321lane
leone55018821leone
line46965571line
lobe65535361lobe
lode56240111lode
loge56837191loge
loner55431031loner
long56933341long
longe66626461longe
lope65941921lope
lore45850351lore
lose45144581lose
love75234761love
lowe75435311lowe
lune47140491lune
none45743171none
one37050911_one
pone65747531pone
sone46649981sone
tone46953741tone
zone135231081zone
acne66625872acne
agone65924552agone
alane56135612alane
aline57243152aline
aloe45540192alo_e
along65419492along
ane37866942_ane
atone56527982atone
axone125918472axone
bane65250422bane
bene66439492bene
bine66650852bine
bloke114316632bloke
blond85618372blond
blonde94813292blonde
bode75838752bode
bole66448692bole
bond75334362bond
boned85133242boned
boner75133082boner
bones76446532bones
boney105227312boney
bong75633412bong
bonk105531712bonk
bonne75124712bonne
bony96732082bony
bonze165119352bonze
bore66051332bore
borne77926792borne
cane66653112cane
cine66242942cine
cline76428532cline
clon66232482clon_
cloned94518802cloned
cloner84418092cloner
clones84526562clones
clonk114417442clonk
clons75228132clons
close76425222close
clove105619442clove
cloze165517542cloze
code77347732code
coke107038382coke
cole66956112cole
colone85425002colone
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
elope75219342elope
eon36052082eon_
eons46638712eons
erne46727422erne
esne47018792esne
eyne76322462eyne
fane75343562fane
fine75147952fine
floe76129772flo_e
flong95815682flong
foe66350812fo_e
fon66352272fon_
fond86330952fond
fons76943892fons
font77143752font
fore78351472fore
gane55145292gane
gene56237222gene
globe84917012globe
glove94516292glove
gloze154815982gloze
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
klong105310402klong
koine9516482koine
konk79320612konk
kore85834162kore
krone94018732krone
kune85424572kune
lace66848472lace
lade56345982lade
lake85741602lake
lame66849292lame
lance75126722lance
land56337302land
lanes54946792lanes
lang56637372lang
lank84734442lank
lase46148512lase
late47560482late
lave75642142lave
laze136235052laze
lee36068142l_ee
leke85527402leke
lend56233672lend
lenes54738522lenes
leno47331392leno
lens46146492lens
lense54523432lense
lent46360532lent
leones64417722leones
liane54720662liane
lice66045062lice
lie38264522l_ie
lien45339802lien
life75433732life
like86040842like
lime66244932lime
lin37967372lin_
lined64934642lined
linen55728722linen
liner55938912liner
lines57054572lines
liney87029622liney
ling57447962ling
link86943442link
linn46034592linn
lino46343372lino
lins47059052lins
lint416266232lint
liny78141322liny
lion46334442lion_
lions55923212lions
lipe66839732lipe
lire47845292lire
lite47054542lite
live76540992live
lo28053442lo__
load56730602load
loaf76734902loaf
loam65630482loam
loan47436452loan
loaned73816292loaned
loaner64416502loaner
loans56026462loans
lob57154462lo_b
lobed86022132lobed
lobes75331002lobes
lobo67229862lobo
lobs66441082lobs
loca65527682loca
loch95527132loch
loci66126282loci
lock106134362lock
loco67030742loco
loden66621142loden
lodes66436912lodes
lodge76520082lodge
loft76539142loft
log46252682lo_g
loges66534202loges
logo57931762logo
logs57343112logs
logy87025782logy
loid55531482loid
loin46838722loin
loins56728422loins
loll46128382loll
lonely92912462lonely
loners64225802loners
longed87121372longed
longer75823192longer
longes75925572longes
longs65527062longs
loo38359822lo_o
looed64626132looed
looey84822912looey
loof78141052loof
looie55624242looie
look87333472look
loom67035052loom
loon47344792loon
looney94712402looney
loonie64216452loonie
loons55731722loons
loony86918962loony
loop67835012loop
loos49051122loos
loose56627682loose
loot46955822loot
lop58255312lo_p
loped85128332loped
loper75129232loper
lopes76437342lopes
lops66043352lops
lord55032082lord
lores55045402lores
lorn46435252lorn
lory75931712lory
losel54419422losel
loser54728672loser
loses56742012loses
loss45337962loss
lost47951492lost
lot38179262lo_t
lota47233502lota
loth76132132loth
loti46431832loti
lots47652092lots
lotte54923852lotte
loud55228042loud
louie55023512louie
lounge75211212lounge
loup66028432loup
loupe75319512loupe
lour45430682lour
louse56131012louse
lout45952142lout
loved95021362loved
lover85526452lover
loves85332012loves
low66051872lo_w
lowed95233902lowed
lower85830412lower
lowes85732462lowes
lown76929292lown
lows75843012lows
lowse87219902lowse
lox108240962lo_x
loxed135017052loxed
loxes125227472loxes
lube64731562lube
luce65132572luce
lude55331642lude
luge55531642luge
luna46229852luna
lunes55337772lunes
lunet56835422lunet
lung55732492lung
lunge65323802lunge
lunk86030722lunk
lunt46148842lunt
luny77324132luny
lure45142462lure
lute46341012lute
luxe115222692luxe
lye66533412l_ye
lynx1437422lynx
lyre75623792lyre
lyse76320592lyse
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
ozone14310612ozone
pane64950282pane
phone105621932phone
pine67755712pine
plane74929142plane
plonk114613982plonk
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
scone74621832scone
sene46848052sene
shone83725972shone
sine46560622sine
sloe45534952slo_e
slope75823562slope
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
zlote143912942zlote
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.1401276364.3
2DLD Change Limit298724731.25023897.6
3Display Results4734730.1104300.0
 (SQL Overall)1786914731.500119127.3
 
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.