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

154 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
blared9501824(None) 
bared85144481b_ared
bladed104717761bladed
blamed116017951blamed
blare75826231blare_
blares85021631blares
blawed124713891blawed
blazed184314711blazed
bleared104211251bleared
flared105317601flared
glared84715191glared
ablated102513442ablated
alarmed1037732alarmed
alated75625142alated
baaed85218162b_aaed
baked126130772b_aked
balded105417512balded
baled85436442b_aled
balked135219412balked
balled94926892balled
baned85436352b_aned
barbed115121312b_arbed
bard75648862b_ar_d
barde85330772b_arde
barded105426422b_arded
bare65460522b_are_
barer74535802b_arer
bares75457132b_ares
barfed125416382b_arfed
barged105822642b_arged
barked135027312b_arked
barned95623582b_arned
barred95725792barred
based85331582b_ased
bated85935532b_ated
bayed115423022b_ayed
beaded104922422beaded
beaked135919492beaked
beamed115720732beamed
beaned95621472beaned
beard86024962bear_d
bearded114212132bearded
bearer85323912bearer
belaced124112152belaced
belated103520012belated
belayed133610082belayed
bewared13310112bewared
biased94012222biased
birred94713202birred
blabbed11357812blabbed
blacked163613372blacked
blade85923332blade_
blader93618582blader
blades95221252blades
blae66134642bla_e_
blame95625492blame_
blamer104417142blamer
blames105121862blames
bland85320452bla_nd
blanked144011222blanked
blarney12174762blarney
blase75524232blase_
blasted104213472blasted
blate75933782blate_
blatted104812712blatted
blaze165520832blaze_
blazer174414022blazer
blazered2035062blazered
blazes174817352blazes
bleated104015972bleated
bled75729312bl__ed
bleed85019802bl_eed
bloated104513432bloated
blowed125016692blowed
blued84520322bl_ued
blumed114313642blumed
blurbed12337612blurbed
blurred10427802blurred
blurted10399782blurted
board85523002boar_d
boarded113910502boarded
boated94221972boated
bored85034302b_ored
braced115420602braced
braked135318692braked
braved124817442braved
brayed124615782brayed
brazed184717082brazed
bred75130972b__red
burred95820722burred
cared86050092_cared
chared125423692chared
claret84026572claret
clawed125115072clawed
clayed125013042clayed
cleared103612462cleared
dared75935012_dared
eared65139502_eared
elated74725822elated
fared95842342_fared
feared106320432feared
flaked144715652flaked
flamed124618972flamed
flare84823632flare_
flares94521702flares
flawed134712722flawed
flayed134414052flayed
geared85317742geared
glaired9387742glaired
glare65222952glare_
glares75518862glares
glazed174711772glazed
hared95742182_hared
laced87132642_laced
laded74232612_laded
laired75216812_laired
laked105731122_laked
lamed85235292_lamed
lard56742002_lar_d
larded84319092_larded
laree56036292_laree
lares54852632_lares
larked114519472_larked
lased65132342_lased
lated65240672_lated
laved95028592_laved
lawed96028322_lawed
layed95127382_layed
lazed154925842_lazed
lured65427492_lured
neared75119802neared
oared65030652_oared
pared86946762_pared
placed114318002placed
planed94420912planed
plated95225772plated
played124815032played
rared65738322_rared
reared75930012reared
roared75015392roared
scared95227292scared
seared75232842seared
shared105829062shared
slaked114318272slaked
slated75028312slated
slaved104017042slaved
slayed104716222slayed
snared74824552snared
soared74324292soared
spared95427492spared
stared75429872stared
tared69340052_tared
teared75722152teared
wared96339872_wared

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 Filter178691825510.360496363.9
2DLD Change Limit825511542.17337989.4
3Display Results1541540.0463347.8
 (SQL Overall)1786911542.57969286.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.