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 “yeaned” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
yeaned10381390(None) 
beaned95621471beaned
deaned84620451deaned
jeaned143813461jeaned
leaned73422541leaned
weaned103816151weaned
yearned11327371yearned
yenned10409381yenned
baned85436352_baned
beaded104922422beaded
beaked135919492beaked
beamed115720732beamed
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
neared75119802neared
neoned7311482neoned
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
unyeaned1237742unyeaned
vaned94622422_vaned
vealed103916322vealed
veined104413912veined
waned95831782_waned
weaner93816772weaner
weaved133913482weaved
weened104013732weened
yanked144312242y_anked
yarned105514022yarned
yawed126022452y_awed
yawned13509842yawned
yean75834582yean__
yeans86624882yean_s
yearend11285702yearend
yearner10336872yearner
yeasted1138502yeasted
yelled104116252yelled
yelped12439362yelped
yerked14509372yerked
yessed104511162yessed
yeuked14456232yeuked

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.360496363.9
2DLD Change Limit82551992.62331472.0
3Display Results99990.0462152.2
 (SQL Overall)178691993.02958993.4
 
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.