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

249 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
bygone125617(None) 
begone9512131begone
bygones1335911bygones
agone65924552_agone
bizone1738602bizone
bone65949322b__one
byline11311642byline
gone55639042__gone
orgone71110912orgone
pyrone112714472pyrone
zygose19455552zygose
zygote19325482zygote
abalone938893abalone
agene65621583_agene
agon56531883_agon_
agones75719863_agones
agons66423783_agons
agony96415653_agony
alone55732963_alone
ancone83916953ancone
anyone94612733anyone
argon65520593argon_
argons75018203argons
atone56527983_atone
axone125918473_axone
bacon95620593bacon_
bacons104917583bacons
baggie102912193baggie
bagmen115412533bagmen
baloney1237483baloney
bane65250423b__ane
baron78131243baron_
baronet91022203baronet
barong96015823barong
baronne938263baronne
barons85025383barons
barony115915303barony
barytone1356023barytone
baton75822423baton_
batons85519423batons
bayonet121212213bayonet
become123312593become
before11410153before
began86319573began_
begaze1838333begaze
begin85117353begin_
begins94415303begins
begonia1047213begonia
begot84625953bego_t
beguine1068503beguine
begun85113443begun_
behove14207203behove
beigne9148613beigne
belon73924113belon_
belong93411043belong
belons84119413belons
bene66439493b__ene
benne76521123b_enne
beton76022063beton_
betons84919553betons
betony114211583betony
beyond1237073beyond
bicorne11297553bicorne
bigeye1236643bigeye
biggie103810933biggie
bigos85020013bigo_s
bigoses1039073bigoses
bigot84828323bigo_t
bigoted11258403bigoted
bigots95015133bigots
bine66650853b__ine
biogen9310253biogen
biome94916993b_iome
biont7727163b_iont
bison75716983bison_
bisons83914373bisons
bizones1837823bizones
bloke114316633b_loke
blond85618373b_lond
blonde94813293b_londe
blooie83913193blooie
bode75838753b__ode
bogan87519003bogan_
bogans95714813bogans
boggle104511943boggle
bogie89524103bog_ie
bogle85821683bog_le
bole66448693b__ole
boloney1247763boloney
bond75334363b__ond
boned85133243b__oned
boner75133083b__oner
bones76446533b__ones
boney105227313b__oney
bong75633413b__ong
bonk105531713b__onk
bonne75124713b_onne
bony96732083b__ony
bonze165119353b__onze
boogie93515993boogie
boon67142173b_oon_
boons75031913b_oons
booze164718913b_ooze
borane84620213borane
bore66051333b__ore
borne77926793b_orne
boron76727143boron_
borons85520543borons
boson76019733boson_
bosons85016653bosons
botonee9311833botonee
bourne83714093bourne
bovine11712433bovine
brine75132273b_rine
briony1149043briony
brogue94211033brogue
broke116019783b_roke
brome94421973b_rome
bronc91714343b_ronc
bronze173610923b_ronze
brose75227033b_rose
bryony1435833bryony
bugbane1255863bugbane
bugeye1236533bugeye
bugle84721943bug_le
bugout9311863bugout
burgonet1148103burgonet
butane8313653butane
butene8312623butene
bye86134593by___e
bylined1335853bylined
byliner1235723byliner
bylines1239243bylines
byname13256363byname
byre95023853by__re
byrnie11348573byrnie
byroad1236623byroad
byte96521813by__te
byword1535053byword
bywork1834863bywork
byzant2096813byzant
clone75728163_clone
cogon89120903cogon_
cogons96818113cogons
colone85425003colone
cone67256963__cone
crone75231333_crone
cyclone1437243cyclone
cygnet1237893cyg_net
cymene1377393cymene
cymose13429653cymose
cyton101511463cyton_
cytons111710183cytons
debone93714783debone
depone93616553depone
doggone1035683doggone
done55747913__done
drone65324983_drone
dugong934373dugong
dyne85320933dy__ne
dynode1135023dynode
engine71114863engine
epigone1057843epigone
evzone1894683evzone
eyne76322463ey__ne
forgone1139343forgone
gane55145293__gane
gene56237223__gene
gonef95221293__gonef
goner66025153__goner
gong66827193__gong
gore55744963__gore
gyrene10227243gyrene
gyron95314623gyron_
gyrons105511223gyrons
gyrose105310253gyrose
hexone16289233hexone
hone77549323__hone
hygiene1443473hygiene
hyponea1546453hyponea
hyson1138693hyson_
hysons1237633hysons
impone103011853impone
intone61115423intone
ionone6313443ionone
irone55126363_irone
isogone8237913isogone
ketone105014533ketone
krone94018733_krone
lagune7158633lagune
legong836963legong
leone55018823_leone
logon615922313logon_
logons79818173logons
lone45849133__lone
lysine94210553lysine
myope124010973my_ope
none45743173__none
nylon82910513nylon_
nylons9267973nylons
ochone11311293ochone
one37050913___one
orgones81010793orgones
outgone8311463outgone
oxytone1744203oxytone
ozone14310613_ozone
phone105621933_phone
pone65747533__pone
prone75332623_prone
pylon103614003pylon_
pylons113011233pylons
pyrene113210733pyrene
pyrones123113303pyrones
pyrope132810533pyrope
redone74820053redone
rezone153814783rezone
rugose737283rugose
scone74621833_scone
shone83725973_shone
sone46649983__sone
stone55431183_stone
syne75725763sy__ne
throne98517603throne
tigon63914443tigon_
tigons74112253tigons
tone46953743__tone
trone55131863_trone
tyne76325053ty__ne
undone7914253undone
wagon94312953wagon_
wagoned1256223wagoned
wagoner1136083wagoner
wagons103911213wagons
wobegone1443003wobegone
xylene1645793xylene
xylose1636763xylose
yogee9518063_yogee
yoke115626393_y_oke
yon67348953_y_on_
yond86122313_y_ond
yoni77524393_y_oni
yore76335943_y_ore
yowe106728743_y_owe
zone135231083__zone
zygoid2045933zygoid
zygoma2143493zygoma
zygoses20436783zygoses
zygotene2142523zygotene
zygotes20355163zygotes

Search took 8 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 Filter1786911127160.233766914.2
2DLD Change Limit1127162497.23315583.6
3Display Results2492490.1401778.6
 (SQL Overall)1786912497.60623493.4
 
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.