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

283 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
long5693334(None) 
along65419491along
bong75633411bong
dong66031651dong
flong95815681flong
gong66827191gong
hong85833951hong
klong105310401klong
lang56637371lang
ling57447961ling
log46252681lo_g
lone45849131lone
longe66626461longe
longs65527061longs
lung55732491lung
pong76231141pong
song55133671song
tong56434351tong
alang66023512alang
alone55732962alone
among85813302among
bang74836992bang
belong93411042belong
blog75723822blo_g
blond85618372blond
bog67852412bo_g
boing84725552boing
bond75334362bond
bone65949322bone
bongo85720942bongo
bongs87828422bongs
bonk105531712bonk
bony96732082bony
bung75730632bung
clang86019312clang
cling86424672cling
clog76123242clo_g
clon66232482clon_
clone75728162clone
clonk114417442clonk
clons75228132clons
clung86013602clung
cog69552902co_g
con510268022con_
cone67256962cone
conga85419872conga
conge85227592conge
congo85623132congo
coni65534802coni
conk106531442conk
conn66229132conn
cons66057692cons
cony96537832cony
dang65131532dang
ding66940952ding
dog57449752do_g
doing74923582doing
don46757652don_
dona55529632dona
done55747912done
donga76718422donga
dongs76525812dongs
dons56048702dons
dung66328432dung
eng46726782_eng
eon36052082eon_
eons46638712eons
fang85432542fang
fling97023512fling
flog85523892flo_g
flongs105010492flongs
flung95114582flung
fog76945562fo_g
fon66352272fon_
fond86330952fond
fons76943892fons
font77143752font
gang66031962gang
glogg837352glogg
going75218492going
gone55639042gone
gongs74921612gongs
hang85535542hang
hog78049062ho_g
hogg96617532hogg
hon67759382hon_
hone77549322hone
hongi96715852hongi
hongs95126202hongs
honk116931192honk
hons77350782hons
hung86126352hung
ion36051022ion_
ions46737852ions
jog117438312jo_g
kalong1177702kalong
king95933652king
klongs11436602klongs
konk79320612konk
lag47862122l_ag
land56337302land
lane45153322lane
lank84734442lank
leg46446112l_eg
legong836962legong
lend56233672lend
leno47331392leno
lens46146492lens
lent46360532lent
leone55018822leone
liang64914412liang
lin37967372lin_
line46965572line
linga66820812linga
lingo66022102lingo
lings67135772lings
lingy96925132lingy
link86943442link
linn46034592linn
lino46343372lino
lins47059052lins
lint416266232lint
liny78141322liny
lion46334442lion_
lions55923212lions
lo28053442lo__
load56730602load
loaf76734902loaf
loam65630482loam
loan47436452loan
loans56026462loans
lob57154462lo_b
lobe65535362lobe
lobo67229862lobo
lobs66441082lobs
loca65527682loca
loch95527132loch
loci66126282loci
lock106134362lock
loco67030742loco
lode56240112lode
lodge76520082lodge
loft76539142loft
loge56837192loge
loggy105714192loggy
logo57931762logo
logs57343112logs
logy87025782logy
loid55531482loid
loin46838722loin
loins56728422loins
loll46128382loll
loner55431032loner
longan75612362longan
longed87121372longed
longer75823192longer
longes75925572longes
longly10279602longly
loo38359822lo_o
loof78141052loof
looing73621042looing
look87333472look
loom67035052loom
loon47344792loon
loons55731722loons
loony86918962loony
loop67835012loop
loos49051122loos
loot46955822loot
lop58255312lo_p
lope65941922lope
loping93921412loping
lops66043352lops
lord55032082lord
lore45850352lore
lorn46435252lorn
lory75931712lory
lose45144582lose
losing74022872losing
loss45337962loss
lost47951492lost
lot38179262lo_t
lota47233502lota
loth76132132loth
loti46431832loti
lots47652092lots
loud55228042loud
lough95118482lough
lounge75211212lounge
loungy10476832loungy
loup66028432loup
lour45430682lour
lout45952142lout
love75234762love
loving104416722loving
low66051872lo_w
lowe75435312lowe
lowing104623272lowing
lown76929292lown
lows75843012lows
lox108240962lo_x
loxing143615272loxing
lug46138062l_ug
luna46229852luna
lune47140492lune
lunge65323802lunge
lungi65516052lungi
lungs65223882lungs
lunk86030722lunk
lunt46148842lunt
luny77324132luny
lying95717452lying
lynx1437422lynx
mog66949672mo_g
mon57561572mon_
mongo810122412mongo
monk105928512monk
mono66036712mono
mons68152252mons
mony96830002mony
nog46847312no_g
nogg65115942nogg
nona46929062nona
none45743172none
oblong935382oblong
on28057182_on_
one37050912_one
ono36838032_ono
ons36148512_ons
oolong738072oolong
pang75336282pang
ping75943592ping
plonk114613982plonk
pond75530492pond
pone65747532pone
pongs85526342pongs
pons65850602pons
pony96434052pony
prong85218112prong
pung75429632pung
rang56939152rang
ring56541152ring
rung56429972rung
sang55441222sang
sing57544172sing
slang66324022slang
sling66028802sling
slog56728272slo_g
slung65117832slung
snog55623632snog
son37761952son_
sone46649982sone
songs67725552songs
sons46049552sons
sung55832172sung
tang56138662tang
thong95014172thong
ting56139892ting
tog410255042to_g
ton310265102ton_
tone46953742tone
tonga65619682tonga
tongs65928462tongs
tons46553052tons
tony75635152tony
tung55328162tung
vang84926032vang
wing86339222wing
wog76242732wo_g
won66252062won_
wonk116125302wonk
wons74942042wons
wont75842502wont
wrong94712322wrong
yang85626062yang
yon67348952yon_
yond86122312yond
yoni77524392yoni
young977742young
zing145728612zing
zona136321962zona
zone135231082zone
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.0602978183.3
2DLD Change Limit298722831.01629401.6
3Display Results2832830.0763723.7
 (SQL Overall)1786912831.152155113.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.