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

232 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
bardes9502693(None) 
barbes104526231barbes
barde85330771barde_
barded105426421barded
bards87139641bard_s
bares75457131bar_es
barges94528251barges
barres84427541barres
baryes116218501baryes
abides94719892abides
abodes94417512abodes
abrades10312072abrades
aedes64625142_aedes
aides65336602_aides
ardeb8314522_ardeb
ardebs937012_ardebs
ares45871022_ar_es
arles56735742_arles
arses55733872_arses
baases85218012baases
babes95834112ba_bes
babies106123642babies
baches135426942baches
badder103817512badder
baddest112611142baddest
baddies114017872baddies
bade75140882ba_de_
badges103917362badges
bads77048862ba_d_s
baizes174315052baizes
bakes117035372ba_kes
balded105417512balded
balder95318862balder
baldest102313532baldest
baldies105317702baldies
balds85524642bald_s
bales76250082ba_les
bandas95120542bandas
banded105223172banded
bander93928222bander
banders104324562banders
bandies104124862bandies
bands85233422band_s
banes74945582ba_nes
barbe95328282barbe_
barbed115121312barbed
barbel104317072barbel
barbels114514432barbels
barber104419322barber
barbers114317502barbers
barbet104427882barbet
barbets114915842barbets
barbies114519592barbies
barbs95928192bar_bs
barcas101016602barcas
bard75648862bard__
bardic11312922bardic
bare65460522bar_e_
bared85144482bar_ed
bareges105212032bareges
barer74535802bar_er
barest85327692bar_est
barfed125416382barfed
barfs104826002bar_fs
barge85631022barge_
barged105822642barged
bargee94624442bargee
bargees105415872bargees
barites94322332barites
barked135027312barked
barker124822862barker
barkers134318512barkers
barks115735812bar_ks
barless94317002barless
barley115116762barley
barleys125011842barleys
barmen105418532barmen
barms96128462bar_ms
barned95623582barned
barney115314452barney
barneys12569562barneys
barns76335142bar_ns
barons85025382barons
barques18259642barques
barre75929542barre_
barred95725792barred
barrel84517872barrel
barrels94514362barrels
barren85317612barren
barrens94414322barrens
barret84930482barret
barrets94917102barrets
bars66564092bar__s
barter85525372barter
barters94223032barters
barye105021492barye_
barytes124611152barytes
bases75644352ba_ses
bashes115631392bashes
basses85428302basses
bastes85330382bastes
bates75846342ba_tes
bathes116524832bathes
bauds85821042baud_s
bawdies134613392bawdies
bawds116115492bawd_s
bearded114212132bearded
beards94116672beard_s
bermes106023002bermes
bides85536772b_ides
birded104414302birded
birder94915492birder
birders103913262birders
birdies104016212birdies
birds85421332bird_s
birles84920642birles
birses84717732birses
blades95221252blades
blares85021632blar_es
boarded113910502boarded
boarder103910322boarder
boarders11408622boarders
boards94616932board_s
bodes84935102b_odes
bordel94514572bordel
bordels103911972bordels
border94419972border
borders104317532borders
bores76448252bor_es
borides10515152borides
braces108427772braces
brads85528292brad_s
braes75735052b_raes
brakes124923122brakes
braves115524082braves
brazes175522192brazes
bredes94818472bredes
brees75632552b_rees
brides94423512brides
bries74942152b_ries
burden9412472burden
burdens1039712burdens
burdies104117562burdies
burds84626062burd_s
buries84633272buries
burkes124421312burkes
burses84425512burses
byres104421382byr_es
cades85440732ca_des
cadres94017922cadres
carded105424902carded
carder94524182carder
carders104820352carders
cards85137932card_s
cares77369182car_es
caries85147622caries
carles85435082carles
carses85233652carses
cartes86239472cartes
carves115128452carves
dares66146702dar_es
fades94932862fa_des
farces115223322farces
farded114518952farded
fardel104712592fardel
fardels11389892fardels
fards96629842fard_s
fares85852872far_es
farles96025782farles
garden84215082garden
gardens93312092gardens
grades84926312grades
hades96035112ha_des
harden105718532harden
hardens113815022hardens
harder105022402harder
hardest113118412hardest
hardies114923232hardies
hards96435652hard_s
hares86255542har_es
hordes104921632hordes
irades74517392irades
jades135222112ja_des
lades65141272la_des
larded84319092larded
larder73720972larder
larders83516942larders
lards65331862lard_s
larees65323112larees
lares54852632lar_es
larges74824232larges
madres93718182madres
mares76457632mar_es
marges94525712marges
marses84827112marses
merdes94518602merdes
nards65928462nard_s
nares55544152nar_es
padres95016982padres
parades104121462parades
pardee93922022pardee
pards85634332pard_s
pares77164482par_es
parges94529542parges
paries84742512paries
parles86334392parles
parses85534702parses
rares55247442rar_es
sades65239892sa_des
sards64736182sard_s
sarees65329942sarees
sarges75128592sarges
sarodes84216142sarodes
tardies84225862tardies
tares57456562tar_es
targes74524592targes
tarres64723042tarres
trades75724492trades
varies94330872varies
varves124414782varves
wades95634142wa_des
warded115021042warded
warden104515512warden
wardens113711902wardens
warder104020272warder
warders113416812warders
wards97734402ward_s
wares88250582war_es
yarded114714022yarded
yarder103813972yarder
yarders113211592yarders
yards95324612yard_s

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 Filter178691825510.1061685764.2
2DLD Change Limit825512323.56323169.0
3Display Results2322320.0962416.7
 (SQL Overall)1786912323.76547461.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.