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

283 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
beads8542950(None) 
bads77048861b_ads
bead75937921bead_
beady114719921beady
beaks115326621beaks
beams95328171beams
beans75734691beans
beards94116671beards
bears75739041bears
beats76042241beats
beaus75127111beaus
beds75937781be_ds
bends85628971bends
brads85528291brads
breads95419201breads
deads75726911deads
heads95127111heads
leads66028491leads
meads85425321meads
reads64835271reads
ads49755732__ads
baals76122702baals
baas66844672b_aas
bad67763152b_ad_
bade75140882b_ade
bags76645502b_ags
balds85524642balds
bals66354042b_als
bams87044452b_ams
bands85233422bands
bans66555132b_ans
baps86040842b_aps
bards87139642bards
bars66564092b_ars
bas58681752b_a_s
bass66146782b_ass
bats66962332b_ats
bauds85821042bauds
bawds116115492bawds
bays97143912b_ays
beach124623892beach
beaded104922422beaded
beader94623792beader
beaders104120182beaders
beadle93314682beadle
beadles103414722beadles
beak106534382bea_k
beaky146118022beaky
beam86939232bea_m
beamy126218572beamy
bean66443862bea_n
beano75421552beano
beanos85516512beanos
bear66844642bea_r
beard86024962beard
beast76338642beast
beasts84519722beasts
beat66168302bea_t
beau66137272bea_u
beaut75135212beaut
beauts86015282beauts
beaux146513212beaux
becaps123811402becaps
becks135522012becks
bed67950622be_d_
bedu75923692be_du
beedi8711662beedi
beefs105618562beefs
beeps95320972beeps
beers75628392beers
bees65453382be_es
beets76131442beets
beglads11127262beglads
begs75733832be_gs
beheads1338522beheads
belady12489932belady
belauds1036642belauds
belays114313852belays
bells76432162bells
bels66142492be_ls
belts75931162belts
bemas96424282bemas
bend76435262bend_
bendy115017252bendy
bendys12518382bendys
benes75536232benes
bens65945702be_ns
bents76033692bents
bergs84718042bergs
berks115423122berks
berms95323662berms
bes56557432be__s
beses75830722beses
bests75932612bests
betas75528762betas
beths105519222beths
bets67051442be_ts
beys913829552be_ys
bias64738152bia_s
bids75838422b_ids
bields94110002bields
binds86627472binds
birds85421332birds
blabs95619632blabs
blade85923332blade
blades95221252blades
blahs105616512blahs
blams95023852blams
blats75132502blats
blaws105620462blaws
bleaks125112432bleaks
blears85116452blears
bleats85518612bleats
bleeds95211592bleeds
blends96012882blends
boards94616932boards
boars75229602boars
boas66150832boa_s
boats75635152boats
bods76244712b_ods
bolds85825282bolds
bonds86126842bonds
brad75234342brad_
braes75735052braes
brags85625102brags
braids95015682braids
brands95118942brands
brans75437432brans
bras65746452bra_s
brass75428022brass
brats75336012brats
braws106425192braws
brays106723112brays
bread85523112bread_
bready124511182bready
breaks124816422breaks
breams104815042breams
breeds94914882breeds
broads94515142broads
buds75235172b_uds
bunds85523542bunds
burds84626062burds
cads76144522_cads
chads116122232chads
clads85722732clads
dads67442772_dads
dead65434242dead_
deals65435342deals
deans66131392deans
dears65736882dears
deeds75423762deeds
dreads84115022dreads
duads76515342duads
dyads10549972dyads
ears46356592_ears
eats47054872_eats
eds46638922_e_ds
egads74610922egads
elds56324852_elds
ends56528522_ends
fads86939872_fads
fears84829392fears
feats86432752feats
feds85234312fe_ds
feeds94921142feeds
fends96324972fends
feods99516852feods
feuds95914882feuds
gads67843382_gads
gears64628692gears
geds66730812ge_ds
gelds75118342gelds
glads75620612glads
goads77022852goads
grads75625752grads
head87137172head_
heady125117262heady
heals85733452heals
heaps105223222heaps
hears86737372hears
heats85838402heats
heeds95420422heeds
herds96424682herds
hexads17468192hexads
jeans126022112jeans
jehads1735832jehads
keas86337092kea_s
kneads11357092kneads
lads56549132_lads
lead56038852lead_
leady95618602leady
leafs85721182leafs
leaks95923912leaks
leans55536252leans
leaps75522932leaps
lears55938732lears
leas45954182lea_s
lends65326252lends
leuds66214812leuds
loads65323372loads
mads76845362_mads
mead75531602mead_
meals75933372meals
means75831222means
meats75034052meats
meds75735362me_ds
meeds84920272meeds
melds84822382melds
menads95514382menads
mends84927692mends
neaps75618322neaps
nears55529422nears
neats55931902neats
needs65719632needs
nerds65719252nerds
obeahs1135862obeahs
oreads73915772oreads
pads76742952_pads
peags86122842peags
peaks114825622peaks
peals75235492peals
peans75437642peans
pears75138612pears
peas65755062pea_s
peats76140192peats
peds75835242pe_ds
pends85527192pends
pleads94613952pleads
quads154515842quads
rads56046602_rads
read55942532read_
readd74617132readd
readds84111642readds
ready94821502ready
reals55038652reals
reams75729622reams
reaps75626192reaps
rears54739652rears
redds74617832redds
reds56042862re_ds
reeds65430902reeds
rends65129952rends
roads66523612roads
scads85419952scads
seals54839692seals
seams75731662seams
sears54744912sears
seas45755272sea_s
seats54844342seats
seeds64330062seeds
sends65528242sends
shads95124482shads
steads74116222steads
tads57143942_tads
teaks94222902teaks
teals56234132teals
teams75726512teams
tears55436462tears
teas45851492tea_s
teats55636812teats
teds54932572te_ds
tends65425582tends
toads65621062toads
treads74817912treads
veals84926192veals
velds95615582velds
vends95520892vends
wads87343142_wads
wealds10459102wealds
weals85428742weals
weans85326742weans
wears86030302wears
weds86628932we_ds
weeds95222212weeds
welds94719162welds
wends95822812wends
woads94818442woads
yeahs115214552yeahs
yeans86624882yeans
years84527672years
yeas78638422yea_s
zeals145320852zeals
zeds145821802ze_ds

Search took 3 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.0802233637.5
2DLD Change Limit538002831.90628226.7
3Display Results2832830.0763723.7
 (SQL Overall)1786912832.06286659.1
 
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.