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

113 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
beards9411667(None) 
bards87139641b_ards
beads85429501bea_ds
beard86024961beard_
bears75739041bear_s
boards94616931boards
awards107113452awards
bads77048872b_a_ds
balds85524642b_alds
bands85233432b_ands
barbs95928192b_arbs
bard75648862b_ard_
barde85330772b_arde
bardes95026932b_ardes
bares75457132b_ares
barfs104826002b_arfs
barks115735812b_arks
barms96128462b_arms
barns76335142b_arns
bars66564092b_ar_s
bauds85821042b_auds
bawds116115492b_awds
bayards13379682bayards
bead75937922bea_d_
beady114719922bea_dy
beaks115326622bea_ks
beams95328172bea_ms
beanos85516512beanos
beans75734692bea_ns
bear66844642bear__
bearded114212132bearded
bearer85323912bearer
bearers94619592bearers
bearish123013272bearish
beasts84519722beasts
beats76042242bea_ts
beaus75127112bea_us
beauts86015282beauts
beds75937792be__ds
bedwards1596392bedwards
beers75628392beer_s
beeyards1444592beeyards
begirds1134882begirds
belauds1036642belauds
bends85628972be_nds
bergs84718042be_rgs
berks115423122be_rks
berms95323662be_rms
bewares12313372bewares
birds85421342b_irds
blares85021632blares
blears85116452blear_s
board85523002board_
boars75229602boar_s
boarts84716872boarts
boyards13399322boyards
brads85528292bra_ds
braids95015692braids
brands95118942brands
breads95419202brea_ds
briards10398552briards
burds84626062b_urds
cards85137932_cards
chards125119732chards
deads75726912dea_ds
dears65736882dear_s
debeards1235502debeards
earls56127512_earls
earns55927562_earns
ears46356592_ear_s
fards96629842_fards
fears84829392fear_s
gears64628692gear_s
guards84611572guards
hards96435652_hards
heads95127112hea_ds
heard95222752heard_
hears86737372hear_s
hearts96218942hearts
herds96424682he_rds
hoards104912622hoards
lards65331862_lards
leads66028492lea_ds
learns65513742learns
lears55938732lear_s
liards75212612liards
meads85425322mea_ds
nards65928462_nards
nears55529422near_s
nerds65719252ne_rds
pards85634332_pards
pearls84715392pearls
pears75138612pear_s
petards104311152petards
readds84111642readds
reads64835272rea_ds
rearms85114652rearms
rears54739652rear_s
regards94112562regards
retards85015002retards
rewards114813992rewards
sards64736182_sards
sears54744912sear_s
shards104319172shards
swards105415132swards
tears55436462tear_s
wards97734402_wards
wealds10459102wealds
wears86030302wear_s
weirds10478052weirds
yards95324612_yards
yearns9509542yearns
years84527672year_s

Search took 5 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.343520965.0
2DLD Change Limit825511134.23619488.0
3Display Results1131130.0303766.7
 (SQL Overall)1786911134.60938770.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.