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

297 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
bys8522946(None) 
abys97221881abys
ays67050291ays
bas58681751bas
bays97143911bays
bes56557431bes
beys913829551beys
bis56860661bis
bos57966811bos
boys96737331boys
bus56950971bus
buys95726791buys
by77529231by_
bye86134591bye
byes95230531byes
aas310975392aas
abas68642082abas
abos67734412abos
abs59356072abs
aby810238062aby_
abye97921002abye
abyes105518532abyes
abysm12598142abysm
abyss10669462abyss
ads49755732ads
ags47551662ags
ahs68644822ahs
ais39083572ais
als36663022als
ars37670932ars
as211083072_as
ass37844062ass
ay511773892ay_
aye67151762aye
ayes76543512ayes
ba49962342b_a
baa510650422baa
baas66844672baas
bad67763152bad
bads77048862bads
bag67059222bag
bags76645502bags
bah87755352bah
bal56662722bal
bals66354042bals
bam78560142bam
bams87044452bams
ban58366842ban
bans66555142bans
bap76455842bap
baps86040842baps
bar58070552bar
bars66564092bars
base64847022base
bash915240162bash
bask105131422bask
bass66146782bass
bast66362412bast
bat510988952bat
bats66962332bats
bay89661642bay
be47948942b_e
bed67950622bed
beds75937782beds
bee56262402bee
bees65453382bees
beg65944132beg
begs75733832begs
bel57148462bel
bels66142492bels
ben56554922ben
bens65945702bens
best66355322best
bet58376672bet
bets67051442bets
bey86645422bey
bi48046472b_i
bias64738162bias
bib77045942bib
bibs84830992bibs
bid67751792bid
bids75838432bids
big67345722big
bigs76235022bigs
bin56658642bin
bins66548252bins
bio57846082bio
bios66335322bios
bise66437102bise
bisk106523352bisk
bit57070902bit
bits66148162bits
biz147939362biz
bo410957572b_o
boa56954032boa
boas66150832boas
bob76755672bob
bobs86340652bobs
bod67055542bod
bods76244712bods
bog67852412bog
bogs75742752bogs
boo58163662boo
boos67955032boos
bop77549482bop
bops86037982bops
bosh96328972bosh
bosk105825732bosk
boss65938342boss
bot59680402bot
bots66453952bots
bow87051902bow
bows96242862bows
box1210142342box
boy87753562boy
boyo96923842boyo
boyos105418282boyos
bra56339462bra
bras65746452bras
brays106723112brays
bris65539612bris
bro56236602bro
bros65635662bros
brr56921922brr
bub76343982bub
bubs86235502bubs
bud67041272bud
buds75235172buds
bug65340742bug
bugs76035912bugs
bum75342692bum
bums85934592bums
bun56348142bun
buns66243722buns
buoys104810632buoys
bur55744692bur
burs65847422burs
bush96630712bush
busk105429222busk
buss65134912buss
bust65947782bust
busy94727172busy
but55963022but
buts67247692buts
buy86436542buy
byre95023852byre
byres104421382byres
byrl95716012byrl
byrls105711232byrls
byssi10507992byssi
byte96521812byte
bytes105217492bytes
cays95437672cays
cis57748032cis
cos510270392cos
coys97537242coys
cyst96322812cyst
days87637132days
deys85027472deys
dis46459892dis
dos48062312dos
drys86314802drys
dye75334842dye
dyes85331892dyes
ebbs82411992ebbs
eds46638922eds
efs66829602efs
els37645722els
ems56435492ems
ens37245922ens
ers36046282ers
es29048222_es
ess36030882ess
eyas76427432eyas
eye65539772eye
eyes75837882eyes
fas68262932fas
fays108535362fays
fes66551672fes
foys105628292foys
gas48870252gas
gays87338022gays
gos47155132gos
goys86328412goys
guys85019642guys
gym95719062gym
gyms107514592gyms
gyp98319012gyp
gyps105115022gyps
has67372652has
hays106138072hays
hes66654202hes
his66359502his
hos68364192hos
hoys107733932hoys
hyp117822462hyp
hyps125418412hyps
ibis66519582ibis
ids47535462ids
ifs67124242ifs
ins35945602ins
is27048212_is
its35538832its
jays146328342jays
joys146624662joys
jus106930222jus
kas77058582kas
kays116032192kays
keys116322162keys
kis78051472kis
kos76944822kos
kye107327272kye
kyes115124932kyes
las37281472las
lays76043252lays
les35663072les
leys76430182leys
lis37162272lis
lye66533412lye
lyes75530832lyes
lyse76320592lyse
mas58175822mas
mays96940032mays
mis58162622mis
mos57067122mos
mus55946752mus
my78125652my_
myc106519502myc
mycs115314292mycs
nays75931592nays
nos38859322nos
nus37939392nus
obas65730932obas
obes66036832obes
obeys107010642obeys
obis66226842obis
ods47546212ods
oes35866192oes
ohs66232312ohs
oms56337512oms
ons36148512ons
ops56641252ops
ors35750112ors
os211359882_os
oy58950132oy_
oyes74940132oyes
pas58775742pas
pays95940222pays
pes57259782pes
pis56362032pis
pus55547842pus
pya87023752pya
pyas96225702pyas
pye86432502pye
pyes95528992pyes
pyx157817012pyx
qis126934382qis
ras37575392ras
rays77642352rays
res35565042res
rya67622012rya
ryas77224612ryas
rye66032542rye
ryes75529352ryes
says75942102says
sis37360542sis
sos37761602sos
soys75233932soys
syn67024122syn
tas38477102tas
tis37056642tis
toys78036342toys
tye65837442tye
tyes76433372tyes
uns35936752uns
ups55629052ups
us26937432_us
uts35534372uts
vas67755772vas
vis66747612vis
was68767562was
ways107737952ways
whys137011662whys
wis66552332wis
wos66953532wos
wye96331972wye
wyes105727502wyes
wyn95921442wyn
wyns105717032wyns
xis106935332xis
xyst144714072xyst
ya510251502_ya
yays105728912yays
ye57650062_ye
yes66250612yes
yo59748552_yo
zas126946832zas

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.250714764.0
2DLD Change Limit140842970.39335837.2
3Display Results2972970.0604950.0
 (SQL Overall)1786912970.703254183.5
 
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.