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

139 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
weaned10381615(None) 
beaned95621471beaned
deaned84620451deaned
jeaned143813461jeaned
leaned73422541leaned
waned95831781w_aned
weaner93816771weaner
weaved133913481weaved
weened104013731weened
yeaned103813901yeaned
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
sweated113411542sweated
teamed95418592teamed
teared75722152teared
teased74721152teased
teated74924022teated
tweaked1534402tweaked
unweaned1238592unweaned
vaned94622422_vaned
vealed103916322vealed
veined104413912veined
waded106024752w_aded
waged104822782w_aged
waked135626752w_aked
waled94330992w_aled
wand85833882w_an_d
wane76344722w_ane_
wanes85040882w_anes
waney115120322w_aney
wanked144517152w_anked
wanned104318012wanned
wanted104319722w_anted
wared96339872w_ared
warned104018912warned
waved125223582w_aved
waxed166018482w_axed
weaken13349602weaken
weakened1634822weakened
weaker134015442weaker
weald95615022wea_ld
wean75734352wean__
weaners104613832weaners
weans85326742wean_s
weaponed1445492weaponed
wearer94319402wearer
wearied112911802wearied
weasel93410522weasel
weave115218532weave_
weaver123916612weaver
weaves123616372weaves
webbed1436432webbed
webfed1535032webfed
wedded123811842wedded
wedged125110302wedged
weed85637512we__ed
weeded113914872weeded
weeted103913792weeted
weiner94214132weiner
welded114013382welded
welled103820212welled
welted103715822welted
wend85330452we_n_d
wended113616152wended
wetted103717022wetted
whaled134612032whaled
whanged15447612whanged
whined134715202whined
wined94434182w_ined
winned104017012winned
woaded115211602woaded
womaned1337212womaned
wonned104012062wonned
wreaked15369022wreaked
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.343520965.0
2DLD Change Limit825511392.23636919.1
3Display Results1391390.0304633.3
 (SQL Overall)1786911392.60968490.2
 
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.