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

281 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
load5673060(None) 
goad66830981goad
lad48165701l_ad
lead56038851lead
loads65323371loads
loaf76734901loaf
loam65630481loam
loan47436451loan
loid55531491loid
lord55032081lord
loud55228041loud
road56332111road
toad55830181toad
woad85523941woad
ad311975032__ad
aloud65018072aloud
bad67763152_bad
bead75937922bead
bloat75229922bloat
blond85618372blond
blood85319522blood
boa56954032boa_
boar66134292boar
board85523002board
boas66150832boas
boat66360312boat
bod67055542bo_d
bold75432812bold
bond75334362bond
brad75234342brad
broad84817692broad
cad67456362_cad
chad105525502chad
clad76225822clad
cloak115214012cloak
clod76124612clo_d
cloud86716422cloud
coal66939252coal
coat67558352coat
coax136922982coax
cod69660122co_d
coda77029342coda
coed77140542coed
cold77338772cold
cord76740922cord
dad58456162_dad
dead65434242dead
doat56947672doat
duad66521412duad
dyad96415452dyad
egad64215412egad
fad77452412_fad
float85928572float
flood95215602flood
foal76630922foal
foam97127172foam
fold86528942fold
fond86330952fond
food86830572food
ford86835492ford
gad57556652_gad
glad65624012glad
gloam86015942gloam
gloat65427682gloat
goa47343802goa_
goads77022852goads
goal55829302goal
goas55239942goas
goat56250832goat
god57449792go_d
gold65430162gold
gonad75216052gonad
good66531802good
gowd96519982gowd
grad66829862grad
had77658762_had
head87137172head
hoar76729162hoar
hoard94918312hoard
hoax147718292hoax
hod76852462ho_d
hodad10311352hodad
hoed87837982hoed
hold86235062hold
hood85132332hood
iliad64613462iliad
koa76737772koa_
koan85425032koan
koas85635092koas
la219261632l_a_
lab58864782l_ab
lac510155822l_ac
lade56345982l_ade
lads56549132l_ads
lady86527152l_ady
lag47862122l_ag
laid56439142laid
lam57666712l_am
land56337312land
lap58565272l_ap
lar37967532l_ar
lard56742002lard
las37281472l_as
lat37593402l_at
laud56527722laud
lav66847342l_av
law68656642l_aw
lax107651522l_ax
lay68865352l_ay
lea37660182lea_
leads66028492leads
leady95618602leady
leaf76441032leaf
leak86233712leak
leal46043272leal
lean46345242lean
leap66032682leap
lear47045952lear
leas45954182leas
led46254552l_ed
lend56233672lend
leud57223422leud
lewd85716592lewd
liar47229682liar
liard65418592liard
lid47453522l_id
lied55838092lied
lo28053442lo__
loach105116362loach
loaded84616872loaded
loader74316312loader
loafed104011152loafed
loafs85616992loafs
loamed94414612loamed
loams75619862loams
loamy105913342loamy
loaned73816292loaned
loans56026462loans
loath84918602loath
lob57154462lo_b
lobar7313012lobar
lobe65535362lobe
lobed86022132lobed
lobo67229862lobo
lobs66441082lobs
loca65527682loca
local74820272local
loch95527132loch
loci66126282loci
lock106134362lock
loco67030742loco
lode56240112lode
loft76539142loft
log46252682lo_g
logan68123282logan
loge56837192loge
logo57931762logo
logs57343112logs
logy87025782logy
loids66220702loids
loin46838722loin
loll46128382loll
lone45849132lone
long56933342long
loo38359822lo_o
looed64626132looed
loof78141052loof
look87333472look
loom67035052loom
loon47344792loon
loop67835012loop
loos49051122loos
loot46955822loot
lop58255312lo_p
lope65941922lope
loped85128332loped
lops66043352lops
loral55927822loral
loran55925092loran
lords64923502lords
lore45850352lore
lorn46435252lorn
lory75931712lory
lose45144582lose
loss45337962loss
lost47951492lost
lot38179262lo_t
lota47233502lota
lotah85315852lotah
lotas55926302lotas
loth76132132loth
loti46431842loti
lots47652092lots
loup66028432loup
lour45430682lour
lout45952142lout
lovat8321042lovat
love75234762love
loved95021362loved
low66051872lo_w
lowe75435312lowe
lowed95233902lowed
lown76929292lown
lows75843012lows
lox108240962lo_x
loxed135017052loxed
loyal84513482loyal
luau44824162luau
lyard95113212lyard
mad68958712_mad
mead75531602mead
moa57249182moa_
moan65832022moan
moas65545342moas
moat66352032moat
mod69054402mo_d
mold76034332mold
monad85519472monad
mood76332062mood
nod47549562no_d
nomad86016182nomad
oaf65952882_oaf
oak76238652_oak
oar37057952_oar
oat39888262_oat
od39255242_o_d
oda48133042_oda
odd57725452_odd
old47033462_old
onload7268632onload
orad56031692orad
oud47439072_oud
pad68057322_pad
plead85818462plead
plod76723272plo_d
pod66351482po_d
pond75530492pond
pood75934322pood
quad144618702quad
rad47662002_rad
read55942532read
reload7413892reload
roads66523622roads
roam67132412roam
roan47234202roan
roar46328572roar
rod47953892ro_d
rood56733002rood
sad47459202_sad
scad75725772scad
shad86230912shad
sloid64619712sloid
slojd13378842slojd
sloyd9409682sloyd
soak87227662soak
soap65831132soap
soar46838672soar
sod46053702so_d
soda56329382soda
sold54837412sold
sord56237202sord
tad47959822_tad
toads65621072toads
toady96814342toady
tod49457072to_d
toed56137042toed
told56132202told
trad55630912trad
ulnad65611452ulnad
unload73010802unload
upload9257782upload
void86220562void
wad77053892_wad
woads94818442woads
woald94813072woald
wold85429072wold
wood85329382wood
word89832002word
yod77545502yo_d
yond86122312yond
zoa128529992zoa_

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.283631417.0
2DLD Change Limit298722810.92332364.0
3Display Results2812810.0604683.3
 (SQL Overall)1786912811.266141146.1
 
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.