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

174 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
beaned9562147(None) 
baned85436351b_aned
beaded104922421beaded
beaked135919491beaked
beamed115720731beamed
deaned84620451deaned
jeaned143813461jeaned
leaned73422541leaned
weaned103816151weaned
yeaned103813901yeaned
baaed85218162b_aaed
baked126130772b_aked
baled85436442b_aled
band76740922b_an_d
banded105223172b_anded
bane65250432b_ane_
banes74945582b_anes
banged104923732b_anged
banked135021442b_anked
banned94721342banned
bared85144482b_ared
barned95623582barned
based85331582b_ased
bated85935532b_ated
bayed115423022b_ayed
beached154516552beached
beaconed1336982beaconed
bead75937922bea__d
beader94623792beader
beaker125520692beaker
bean66443862bean__
beanery1237562beanery
beanie83618592beanie
beanies93821092beanies
beano75421552bean_o
beanos85516512beanos
beans75734692bean_s
beard86024962bea_rd
bearded114212132bearded
bearer85323912bearer
beaten84617062beaten
beater84729392beater
beaver114819252beaver
becked155417762becked
bedamned1434582bedamned
bedded115114072bedded
beefed123510872beefed
beeped115313452beeped
begazed2036202begazed
begged115013812begged
behaved16176682behaved
belaced124112152belaced
belated103520012belated
belayed133610082belayed
belied95022162belied
belled94626192belled
belted94020632belted
bemeaned1335782bemeaned
bemoaned1335552bemoaned
benamed122911092benamed
bend76435262be_n_d
bended105521232bended
bene66439492be_ne_
benes75536232be_nes
benne76521122benne_
bennes86019012bennes
bennet84823362bennet
beraked144312432beraked
berated104422132berated
bermed115217722bermed
bested94922762bested
betaxed17307022betaxed
betted94721162betted
bewared13310112bewared
biased94012222biased
binned94414542binned
bladed104717762bladed
blamed116017952blamed
bland85320452blan_d
blanked144011222blanked
blared95018242blared
blawed124713892blawed
blazed184314712blazed
bleared104211252bleared
bleated104015972bleated
boated94221972boated
boned85133242b_oned
braced115420602braced
brained103816102brained
braked135318692braked
brand85124492bran_d
branded114414102branded
branned104311692branned
braved124817442braved
brayed124615782brayed
brazed184717082brazed
breaded115014062breaded
breamed124011592breamed
brined95118412brined
burned95818962burned
caned85838092_caned
ceased94920782ceased
cleaned103512002cleaned
craned96121652craned
deaved114916552deaved
denned84215632denned
eared65139502_eared
earned74818332_earned
eased65430402_eased
eaved95924502_eaved
feared106320432feared
feased105718712feased
feazed195112632feazed
geared85317742geared
gleaned9349422gleaned
headed114020472headed
healed105121442healed
heaped124516902heaped
heated104525592heated
heaved134717862heaved
keened114013632keened
kenned114411272kenned
kerned114112932kerned
leaded84221542leaded
leafed105713872leafed
leaked114217702leaked
leaner64022192leaner
leaped94317772leaped
learned8329302learned
leased74722882leased
leaved105719022leaved
loaned73816292loaned
maned86634102_maned
meaner84617842meaner
meated94222402meated
moaned94514172moaned
neared75119812neared
neoned7311492neoned
paned85437182_paned
peaced115818912peaced
peaked136117402peaked
pealed95322812pealed
peened94318162peened
peined94918842peined
penned94217612penned
planed94420912planed
reamed94326122reamed
reaped94122452reaped
reared75930012reared
reaved104523922reaved
recaned102817202recaned
reined74425522reined
saned65636272_saned
seabed95017692seabed
sealed74328362sealed
seamed94823882seamed
seared75232842seared
seated75131062seated
seined74023062seined
speaned103411522speaned
staned74824642staned
teamed95418592teamed
teared75722152teared
teased74721152teased
teated74924022teated
vaned94622422_vaned
vealed103916322vealed
veined104413912veined
waned95831782_waned
weaner93816772weaner
weaved133913482weaved
weened104013732weened
yearned11327372yearned
yenned10409382yenned

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.346516448.0
2DLD Change Limit825511742.51332849.6
3Display Results1741740.0463782.6
 (SQL Overall)1786911742.90561511.5
 
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.