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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

104 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
wakeful173561(None) 
waeful1238121wa_eful
wameful1535671wameful
baleful1237992baleful
baneful1237892baneful
cageful1356482cageful
careful1249112careful
dareful1157052dareful
easeful1037292easeful
fateful1397512fateful
hateful13107682hateful
pageful1346352pageful
wailful1344952wailful
wakefully2243482wakefully
wamefuls1643862wamefuls
wasteful14104932wasteful
woeful1236362w_oeful
aidful1057073_aidful
aimful1166703_aimful
armful1167163_armful
artful968273_artful
awful1178143_a_wful
bagful1237213ba_gful
bagsful1344893bagsful
bashful1556553bashful
basketful1852133basketful
blameful1543813blameful
cagefuls1484343cagefuls
canful11610263ca_nful
cansful1236823cansful
capful1368173ca_pful
carful11610973ca_rful
direful1156613direful
doleful1146333doleful
earful958963ea_rful
eyeful1235903_eyeful
factful1536373factful
gainful1145833gainful
gleeful1144323gleeful
graceful1445393graceful
grateful1245403grateful
handful14127253handful
harmful1535763harmful
hasteful14105253hasteful
hatful12108743ha_tful
hatsful13106193hatsful
hopeful1545903hopeful
ireful948713_ireful
jarful1646683ja_rful
jarsful1744603jarsful
ladleful1243273ladleful
lapful1156483la_pful
lawful1235493la_wful
lifeful1344613lifeful
makeup1434863make_up
manful11610213ma_nful
museful1245883museful
pagefuls1474343pagefuls
pailful1236103pailful
painful1246403painful
palmful1445053palmful
panful1179743pa_nful
peaceful1545463peaceful
pipeful1445643pipeful
plateful1345433plateful
rackful1645873rackful
rueful948203_rueful
sackful1645353sackful
sacksful1742903sacksful
shameful1644283shameful
spadeful1443963spadeful
stageful1244453stageful
swayful1643003swa_yful
tableful1344153tableful
tactful1236163tactful
takeout1149873takeout
takeup1234583take_up
tankful1445153tankful
tasteful11115213tasteful
tuneful1046123tuneful
useful947013_useful
vakeel1335193vake_el
vatful12107083va_tful
wake114935703wake___
waked135626753wake__d
waken124818473wake__n
wakened1546873wakened
wakener1446913wakener
wakens135012043wake_ns
waker125526593wake__r
wakers134822493wake_rs
wakes126633653wake__s
wamefou1542293wamefou
wamefous1643763wamefous
watchful1943753watchful
waul76927313wa___ul
weariful1443573weariful
wilful1235963w_ilful
willful1344533willful
wishful1664503wishful
wistful1365703wistful
woful1158173w__oful
wrackful2043093wrackful
wrathful1743613wrathful

Search took 8 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 Filter1786911340270.1431249587.4
2DLD Change Limit1340271047.54617761.3
3Display Results1041040.0303466.7
 (SQL Overall)1786911047.71923149.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.