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 “byssi” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

355 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
byssi1050799(None) 
bassi77019321bassi
abyss10669462abyss_
basis75429862basis
bass66146782bass_
basso76017282basso
bassy1012917102bassy
boss65938342boss_
bossy105515972bossy
buss65134912buss_
byes95230532byes_
bys85229462by_s_
byssal1134992byssal
byssus1133762byssus
lassi56316852lassi
lysis84511462lysis
lyssa835712lyssa
xysti15538152xysti
abyes105518533abyes_
abys97221883aby_s_
abysm12598143aby_sm
abysms13565653abysms
abyssal1243753abyssal
abysses1234863abysses
apsis75718293apsis
arsis55722423arsis
asci66519143_asci
ass37844063_ass_
assai5711543assai
ayes76543513ayes_
ays67050293ay_s_
baas66844673baas_
bads77048863bads_
bags76645503bags_
bals66354043bals_
balsa77920413balsa
bams87044453bams_
bani65334953b_ani
bans66555133bans_
baps86040843baps_
bars66564093bars_
bas58681753b_as_
basal75722283basal
base64847023b_ase
based85331583based
baser74828923baser
bases75644353bases
basest84720493basest
bash915240163b_ash
basic96220523basic
basil75122273basil
basin75026923basin
bask105131423b_ask
basks115621763basks
basses85428303basses
basset85225383basset
bassist9312733bassist
bassly114610073bassly
bassos85313703bassos
bast66362413b_ast
baste74829983baste
basts75936933basts
bats66962333bats_
bays97143913bays_
beast76338643beast
beds75937783beds_
bedsit9312843bedsit
beedi8711663beedi
bees65453383bees_
begs75733833begs_
bels66142493bels_
benni74715363benni
bens65945703bens_
bes56557433b_es_
beses75830723beses
beset76739133beset
besom95716973besom
besot76429713besot
best66355323b_est
bestir8311163bestir
bests75932613bests
bets67051443bets_
beys913829553beys_
bi48046463b___i
biali73419073biali
bias64738153bias_
bibs84830973bibs_
bidi78226563b_idi
bidis86721143bidis
bids75838423bids_
bigs76235013bigs_
bindi85617013bindi
bins66548243bins_
bios66335313bios_
birse74517403birse
bis56860653b_is_
bise66437093b_ise
bises75435623bises
bisk106523343b_isk
bisks115416803bisks
bison75716983bison
bits66148153bits_
bitsy104511303bitsy
blase75524233blase
blast76532573blast
bless75917813bless
blest76431723blest
blini75519273blini
bliss75616913bliss
blush105115313blush
boas66150833boas_
boast75935703boast
bobs86340643bobs_
bocci113512713bocci
bods76244713bods_
bogs75742753bogs_
bonsai838463bonsai
boos67955033boos_
boost75132473boost
bops86037983bops_
bos57966813b_os_
bosh96328973b_osh
bosk105825733b_osk
bosks115218853bosks
bosky145612393bosky
bosom95516923bosom
boson76019733boson
bossed94816533bossed
bosses85925403bosses
bossier93712423bossier
bossies94116833bossies
bossily1237563bossily
bossing103714603bossing
bossism1136063bossism
bosun75113593bosun
bots66453953bots_
bouse75931853bouse
bousy104917843bousy
bows96242863bows_
bowse105420633bowse
boyish142911233boyish
boyos105418283boyos_
boys96737333boys_
bras65746453bras_
brash106221563brash
brasil8713863brasil
brass75428023brass
brassie93411523brassie
brassy11509233brassy
bravi104715753bravi
bris65539613bris_
brisk115615983brisk
briss75824273briss
bros65635663bros_
brose75227033brose
brosy106115383brosy
brush105917473brush
brusk114912433brusk
bubs86235493bubs_
buds75235173buds_
buffi136112203buffi
bugs76035913bugs_
bums85934593bums_
buns66243723buns_
burs65847423burs_
bursa74921523bursa
burse75527253burse
burst75332243burst
bus56950973b_us_
busby126113293busby
bused85624493bused
buses75936013buses
bush96630713b_ush
bushy135416683bushy
busk105429223b_usk
buskin123811493buskin
busks115521373busks
bussed94717053bussed
busses85023383busses
bussing103614623bussing
bust65947783b_ust
bustic101012693bustic
busts75227693busts
busty105621013busty
busy94727173b_usy
buts67247693buts_
buys95726793buys_
by77529233by___
bye86134593by__e
bylaw13408603bylaw
bypass1345043bypass
bypast13117373bypast
byre95023853by_re
byres104421383byres
byrl95716013by_rl
byrls105711233byrls
byrnie11348573byrnie
byte96521813by_te
bytes105217493bytes
byway1647533byway
cassia83714763cassia
cassis84818853cassis
cess65326053cess_
cesti75217423cesti
cissy104811073cissy
coss66143493coss_
cuss65430613cuss_
cusso74912293cusso
cyesis1148573cyesis
cyst96322813cy_st
cystic132710653cystic
cysts105912773cysts
dashi95013113dashi
dassie74615573dassie
disci85815023disci
diss56434483diss_
doss56235043doss_
dossil75110903dossil
dyes85331893dyes_
ess36030883_ess_
eyas76427433eyas_
eyass84410783eyass
eyes75837883eyes_
fess76529163fess_
fesse86116333fesse
foss76431643foss_
fossa85812633fossa
fosse86119463fosse
fossil9379353fossil
fuss76027933fuss_
fussy115613953fussy
gassy95514023gassy
gesso649603gesso
gossip946433gossip
gussie72910153gussie
gussy95314323gussy
gyms107514593gyms_
gyps105115023gyps_
gypsy14636993gypsy
gyri85415153gy_ri
hiss75629213hiss_
hissy116112123hissy
hussy116812763hussy
hyps125418413hyps_
hyson1138693hyson
hyssop1443413hyssop
issei568573issei
jassid1467223jassid
jess116022033jess_
jesse126012833jesse
joss115925593joss_
kiss85227393kiss_
kissy125510313kissy
koss85224813koss_
kusso9398033kusso
kyes115124933kyes_
lass47444543lass_
lassie64917743lassie
lassis65216703lassis
lasso55015683lasso
less45635103less_
loss45337963loss_
lossy85214643lossy
lyase85512413lyase
lyes75530833lyes_
lyse76320593ly_se
lysed95011563lysed
lyses84518253lyses
lysin84512783lysin
lyssas935443lyssas
mass66044933mass_
massa75518923massa
masse75125293masse
massif11412533massif
massy104518963massy
mess65932433mess_
messy104913833messy
miss65339413miss_
missis84417503missis
missy105617563missy
moss67641033moss_
mosso74715183mosso
mossy105217063mossy
muss64933763muss_
mussy104117643mussy
myasis114010463myasis
mycs115314293mycs_
myosin113410763myosin
myosis114012553myosis
mysid11610683mysid
mysost1138263mysost
mystic132711643mystic
ness45526563ness_
nisei54214353nisei
nisi45823243_nisi
oasis56422553oasis
ossa43714163_ossa
ossia53710403_ossia
oyes74940133oyes_
pass65239953pass_
passe75525693passe
passim10410283passim
physis14359663physis
piss65033333piss_
posse74722273posse
psi56621623__psi
psis68120343_psis
psst66118403_psst
puss64830133puss_
pussy105614843pussy
pyas96225703pyas_
pyes95528993pyes_
pyosis114012123pyosis
pyxis17458633pyxis
quasi144015023quasi
rishi8311253rishi
roshi8310753roshi
ryas77224613ryas_
ryes75529353ryes_
sass45035623sass_
sassy85813813sassy
sei36048933__sei
si29149573___si
sis37360543__sis
sissy85812073sissy
ski74925683__ski
sri35634003__sri
sushi8310493sushi
suss45229303suss_
syli74318983sy_li
sylis84316023sylis
sysop1037193sysop
tarsi55222173tarsi
tass45640573tass_
tasse54821843tasse
tassie66017023tassie
thyrsi1234453thyrsi
torsi57423363torsi
toss45637973toss_
tussis6379953tussis
tyes76433373tyes_
wiss75630543wiss_
wuss75219333wuss_
wussy115810343wussy
wyes105727503wyes_
wyns105717033wyns_
xyst144714073xy_st
xystoi16365133xystoi
xysts15558123xysts
yagi86922243_yagi
yes66250613_yes_
yeti75823213_yeti
yogi86120423_yogi
yoni77524393_yoni
ywis105313103_ywis

Search took 4 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 Filter178691836670.1231452772.4
2DLD Change Limit836673553.40624564.6
3Display Results3553550.0933817.2
 (SQL Overall)1786913553.62249334.9
 
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.