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

192 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
beast7633864(None) 
bast66362411b_ast
beasts84519721beasts
beat66168301bea_t
beats76042241beats
beaut75135211beaut
best66355321be_st
blast76532571blast
boast75935701boast
breast8319631breast
east46659101_east
feast85932721feast
least56134881least
yeast85327941yeast
abreast9311272abreast
avast85519362avast
baas66844672baas_
baht96740012b_aht
bait66556002b_ait
bas58681752b_as_
base64847022b_ase
bash915240162b_ash
bask105131422b_ask
bass66146782b_ass
baste74829982b_aste
basts75936932b_asts
bat510988952b_a_t
bats66962332b_ats
batt65053872b_att
beach124623892beach
bead75937922bea_d
beads85429502beads
beady114719922beady
beak106534382bea_k
beaks115326622beaks
beaky146118022beaky
beam86939232bea_m
beams95328172beams
beamy126218572beamy
bean66443862bea_n
beano75421552beano
beans75734692beans
bear66844642bea_r
beard86024962beard
bears75739042bears
beastie92412432beastie
beastly1277562beastly
beau66137272bea_u
beaus75127112beaus
beauts86015282beauts
beauty115410162beauty
beaux146513212beaux
bedfast1346412bedfast
beds75937782beds_
bedsit9312842bedsit
bees65453382bees_
beet66457542be_et
beets76131442beets
befit105222662befit
begat86629722begat
beget85632552beget
begot84625952begot
begs75733832begs_
behest11314612behest
bels66142492bels_
belt65754032be_lt
belts75931162belts
bemas96424282bemas_
bemist105216952bemist
bens65945702bens_
bent67759912be_nt
bents76033692bents
beret74946362beret
bes56557432be_s_
beset76739132beset
besot76429712besot
bests75932612be_sts
bet58376672be__t
betas75528762betas_
bets67051442bets_
beys913829552beys_
bezant17814542bezant
bias64738162bias_
blase75524232blase
blasts85116772blasts
blasty115611052blasty
blat66550952bla_t
blats75132502blats
bleat75737002blea_t
bleats85518612bleats
blest76431722blest
boart78835932boart
boas66150832boas_
boasts85017922boasts
boat66360312boa_t
boats75635152boats
boost75132472boost
bract96332722bract
brant74742172brant
bras65746452bras_
brash106221562brash
brass75428022brass
brat66055542bra_t
brats75336012brats
breasts939702breasts
burst75332242burst
bust65947782b_ust
bypast13117372bypast
cast67159902_cast
cease75227652cease
clast76030582clast
coast75236262coast
dealt65234282dealt
deash95617242deash
deist64633592deist
demast9517062demast
ease45042332_ease
easts57530322_easts
easy76224492_easy
eat36989052_ea_t
eats47054872_eats
erst47436432_erst
fast77052312_fast
fease84824872fease
feasts95116092feasts
feat76458222fea_t
feats86432752feats
feist86230072feist
fest74949442fe_st
gast56052562_gast
geest64829612geest
gest56149132ge_st
ghast95621222ghast
hast76259482_hast
heart85440742heart
heat77061422hea_t
heats85838402heats
heist87030912heist
hest75950772he_st
jest116738502je_st
keas86337092keas_
last46260322_last
leant56737782leant
leapt75027472leapt
leas45954182leas_
lease55230262lease
leash85519212leash
leasts64616412leasts
lest46956322le_st
mast65959952_mast
meant76537202meant
meat66359602mea_t
meats75034052meats
neat46356782nea_t
neats55931902neats
neist54628442neist
nest45548732ne_st
oast47156322_oast
oblast8613662oblast
past65959012_past
peart76440752peart
peas65755062peas_
pease75231112pease
peat65967932pea_t
peats76140192peats
pest65555292pe_st
react74634332react
recast83422772recast
reest54938092reest
repast83520632repast
resat55139682resat
rest46459842re_st
roast56230142roast
seas45755272seas_
seat47575562sea_t
seats54844342seats
teas45851492teas_
tease55428712tease
teat45963632tea_t
teats55636812teats
test48651622te_st
toast55831012toast
vast75045122_vast
verst84429372verst
vest75743602ve_st
wast75655852_wast
weest85026772weest
west75748082we_st
yeas78638422yeas_
yeasts96413052yeasts
yeasty12438692yeasty
zest136035702ze_st

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 Filter178691538000.0931921408.6
2DLD Change Limit538001921.39038705.0
3Display Results1921920.0503840.0
 (SQL Overall)1786911921.533116562.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.