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

200 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
beaus7512711(None) 
beads85429501beads
beaks115326621beaks
beams95328171beams
beans75734691beans
bears75739041bears
beats76042241beats
beau66137271beau_
beaut75135211beaut
beauts86015281beauts
beaux146513211beaux
baals76122702baals
baas66844672b_aas
babus95620332babus
bads77048862b_ads
bags76645502b_ags
bals66354042b_als
bams87044452b_ams
bans66555132b_ans
baps86040842b_aps
bars66564092b_ars
bas58681752b_a_s
bass66146782b_ass
bats66962332b_ats
baud74928422b_aud
bauds85821042b_auds
bays97143912b_ays
beach124623892beach
bead75937922bea_d
beady114719922beady
beak106534382bea_k
beaky146118022beaky
beam86939232bea_m
beamy126218572beamy
bean66443862bea_n
beano75421552beano
beanos85516512beanos
bear66844642bea_r
beard86024962beard
beards94116672beards
beast76338642beast
beasts84519722beasts
beat66168302bea_t
beauish12268512beauish
beauty115410162beauty
becaps123811402becaps
because1136232because
becks135522012becks
bedaub1146032bedaub
bedaubs1233692bedaubs
beds75937782be_ds
bedu75923692bedu_
beefs105618562beefs
beeps95320972beeps
beers75628392beers
bees65453382be_es
beets76131442beets
begs75733832be_gs
begum105213922begum
begums11429492begums
begun85113442begun
belaud939132belaud
belauds1036642belauds
belays114313852belays
bells76432162bells
bels66142492be_ls
belts75931162belts
bemas96424282bemas
bemuse1038942bemuse
bends85628972bends
benes75536232benes
bens65945702be_ns
bents76033692bents
bergs84718042bergs
berks115423122berks
berms95323662berms
bes56557432be__s
beses75830722beses
bests75932612bests
betas75528762betas
beths105519222beths
bets67051442be_ts
beys913829552be_ys
bias64738152bia_s
blabs95619632blabs
blahs105616512blahs
blams95023852blams
blats75132502blats
blaws105620462blaws
bleaks125112432bleaks
blears85116452blears
bleats85518612bleats
boars75229602boars
boas66150832boa_s
boats75635152boats
bogus85616472bogus
bolus79125542bolus
bonus75324322bonus
brads85528292brads
braes75735052braes
brags85625102brags
brans75437432brans
bras65746452bra_s
brass75428022brass
brats75336012brats
braws106425192braws
brays106723112brays
breads95419202breads
breaks124816422breaks
breams104815042breams
bubus95115452bubus
bureaus979282bureaus
bus56950972b__us
deads75726912deads
deals65435342deals
deans66131392deans
dears65736882dears
ears46356592_ears
eats47054872_eats
eau37450942_eau_
eaux116618422_eaux
ecus65421462_ecus
emus66821682_emus
fears84829392fears
feats86432752feats
fetus85816542fetus
feus75830752fe_us
gears64628692gears
genus65319832genus
heads95127112heads
heals85733452heals
heaps105223222heaps
hears86737372hears
heats85838402heats
jeans126022112jeans
jehus15488572jehus
keas86337092kea_s
leads66028492leads
leafs85721182leafs
leaks95923912leaks
leans55536252leans
leaps75522932leaps
lears55938732lears
leas45954182lea_s
luaus54514902luaus
meads85425322meads
meals75933372meals
means75831222means
meats75034052meats
meatus85112922meatus
menus75822842menus
meous76120062meous
neaps75618322neaps
nears55529422nears
neats55931902neats
negus64513562negus
nevus84611392nevus
nexus124710662nexus
obeahs1135862obeahs
obelus8348402obelus
peags86122842peags
peaks114825622peaks
peals75235492peals
peans75437642peans
pears75138612pears
peas65755062pea_s
peats76140192peats
praus74621752praus
reads64835272reads
reals55038652reals
reams75729622reams
reaps75626192reaps
rears54739652rears
rebus75721112rebus
seals54839692seals
seams75731662seams
sears54744912sears
seas45755272sea_s
seats54844342seats
taus46342732_taus
teaks94222902teaks
teals56234132teals
teams75726512teams
tears55436462tears
teas45851492tea_s
teats55636812teats
unaus53216572unaus
vaus75928922_vaus
veals84926192veals
venus84918902venus
weals85428742weals
weans85326742weans
wears86030302wears
xerus12313332xerus
yeahs115214552yeahs
yeans86624882yeans
years84527672years
yeas78638422yea_s
zeals145320852zeals
zebus164610052zebus

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 Limit538002001.79629955.5
3Display Results2002000.0633174.6
 (SQL Overall)1786912001.95291542.5
 
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.