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

358 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
box121014234(None) 
bo410957571bo_
boa56954031boa
bob76755671bob
bod67055541bod
bog67852411bog
boo58163661boo
bop77549481bop
bos57966811bos
bot59680401bot
bow87051901bow
boxy166420731boxy
boy87753561boy
cox1210346781cox
fox136737861fox
gox117137181gox
lox108240961lox
ox98242381_ox
pox126140691pox
sox106444191sox
vox136628151vox
abo59045962abo_
abos67734412abos
ax911057782_ax
ba49962342b_a
baa510650422baa
bad67763152bad
bag67059222bag
bah87755352bah
bal56662722bal
bam78560142bam
ban58366842ban
bap76455842bap
bar58070552bar
bas58681752bas
bat510988952bat
bay89661642bay
be47948942b_e
bed67950622bed
bee56262402bee
beg65944132beg
bel57148462bel
ben56554922ben
bes56557432bes
bet58376672bet
bey86645422bey
bi48046472b_i
bib77045942bib
bid67751812bid
big67345722big
bin56658642bin
bio57846082bio
biog76122322biog
bios66335322bios
bis56860662bis
bit57070902bit
biz147939362biz
blob86027092blob
bloc85023272bloc
blog75723822blog
blot65842322blot
blow95827192blow
boar66134292boar
boas66150832boas
boat66360312boat
bobs86340652bobs
bock126032512bock
bode75838752bode
bods76244712bods
body107425672body
boff124727332boff
bogs75742752bogs
bogy106426192bogy
boho96923322boho
boil66335182boil
bola66035562bola
bold75432812bold
bole66448692bole
boll65634752boll
bolo65535952bolo
bolt66254172bolt
bomb106927422bomb
bond75334362bond
bone65949322bone
bong75633412bong
bonk105531712bonk
bony96732082bony
boob85932582boob
book106836332book
boom87435672boom
boon67142172boon
boor66130682boor
boos67955032boos
boot67759372boot
bops86037982bops
bora66141632bora
borax145918722borax
bore66051332bore
bork106933822bork
born67338412born
bort65960962bort
bosh96328972bosh
bosk105825732bosk
boss65938342boss
bota66236502bota
both96533432both
bots66453952bots
bott66548572bott
bout66353292bout
bowl96827702bowl
bows96242862bows
boxed154318612boxed
boxer145016522boxer
boxes145625072boxes
boyo96923842boyo
boys96737332boys
bozo156821412bozo
bra56339462bra
bro56236602bro
broo65129822broo
bros65635662bros
brow97228442brow
brr56921922brr
brux136315272brux
bub76343982bub
bud67041272bud
bug65340742bug
bum75342692bum
bun56348142bun
buoy95921782buoy
bur55744692bur
bus56950972bus
but55963022but
buy86436542buy
by77529232b_y
bye86134592bye
bys85229462bys
coax136922982coax
cob710258752cob
cod69660122cod
cog69552902cog
col59360352col
con510268022con
coo59566362coo
cop711162372cop
cor59960942cor
cos510270392cos
cot510483222cot
cow89856712cow
coxa136922962coxa
coy810557552coy
coz149345362coz
dex116936882dex
do310155252do_
doc66841512doc
doe47361952doe
dog57449752dog
dol47150652dol
dom69752442dom
don46757652don
dor47253922dor
dos48062312dos
dot47573182dot
doux125817982doux
dow76749972dow
doxy156419952doxy
ebon66821102ebon
eon36052082eon
ex98835642_ex
fax138143312fax
fix136236102fix
fob86748332fob
foe66350812foe
fog76945562fog
foh98135892foh
fon66352272fon
fop86743702fop
for66952072for
fou66743782fou
foxy176517752foxy
foy96044262foy
go38748742go_
goa47343802goa
gob68950892gob
god57449792god
goo47754772goo
gor47848262gor
gos47155132gos
got49870442got
goy77844552goy
hex137436172hex
ho510258272ho_
hoax147718292hoax
hob87550922hob
hod76852462hod
hoe67562722hoe
hog78049062hog
hon67759382hon
hop87554592hop
hos68364192hos
hot67776062hot
how97252432how
hoy97447912hoy
ibex133813482ibex
ion36051022ion
jo99539602jo_
job128041772job
joe106642352joe
jog117438312jog
jot108259022jot
jow137639302jow
joy137036362joy
kex146029582kex
koa76737772koa
kob99442382kob
koi77534752koi
kop97440202kop
kor76538892kor
kos76944822kos
lax107651522lax
lex107943822lex
lo28053442lo_
lob57154462lob
log46252682log
loo38359822loo
lop58255312lop
lot38179262lot
low66051872low
lux106528772lux
max129045452max
mix126138182mix
mo49158482mo_
moa57249182moa
mob78651922mob
moc77845082moc
mod69054402mod
mog66949672mog
mol56654592mol
mom78853162mom
mon57561582mon
moo58460512moo
mop76950822mop
mor56855002mor
mos57067122mos
mot57279422mot
mow86650352mow
moxa136917742moxa
nix106932832nix
no29353242no_
nob58954422nob
nod47549562nod
nog46847312nog
noh66640642noh
nom510450642nom
noo37154042noo
nor38048822nor
nos38859322nos
not39474662not
now65950192now
oba57531552oba
obe56638642obe
obi57127732obi
oboe66822942oboe
obol65220612obol
od39255242_od
oe28473062_oe
of58247772_of
oh57447002_oh
oi29061482_oi
om48553002_om
on28057182_on
ooh67637092ooh
oot311274692oot
op45850162_op
or27354732_or
os211359882_os
ow58950172_ow
oxo107322962_oxo
oxy136320982_oxy
oy58950132_oy
pax127346852pax
pix126437932pix
pod66351482pod
poh86740532poh
poi57244662poi
pol56449382pol
pom78249912pom
poo57757112poo
pop76252252pop
pot58078432pot
pow87147282pow
poxy166820892poxy
pyx157817012pyx
rax108445722rax
rex105740992rex
rob56754302rob
roc520243252roc
rod47953892rod
roe36861082roe
rom59855632rom
rot37282952rot
roux117419362roux
row67453672row
sax107447642sax
sex107043222sex
six105339742six
so28855442so_
sob57857942sob
sod46053702sod
sol37256622sol
som59153812som
son37761952son
sop57557862sop
sos37761602sos
sot310384302sot
sou37853692sou
sow66554762sow
soy67851452soy
tax109449152tax
to218858982to_
tod49457072tod
toe310166852toe
tog410255042tog
tom514358052tom
ton310265102ton
too38965422too
top510560682top
tor39261682tor
tot38884772tot
tow610557362tow
toy69655192toy
tux105426572tux
unbox1438752unbox
vex136429172vex
voe67739052voe
vow96136312vow
wax137041182wax
wo510447762wo_
woe66651242woe
wog76242732wog
wok106334172wok
won66252062won
woo66949802woo
wop87145132wop
wos66953532wos
wot610467482wot
wow96643472wow
yo59748552yo_
yob87945272yob
yod77545502yod
yok107335242yok
yom88043442yom
yon67348952yon
you66641822you
yow96945292yow
zax197630632zax
zoa128529992zoa
zoo126238912zoo

Search took 1 second 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 Filter178691140840.280638182.1
2DLD Change Limit140843580.37637457.4
3Display Results3583580.0764710.5
 (SQL Overall)1786913580.732244113.4
 
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.