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

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

57 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
keynoted164278(None) 
keynote1443901keynote_
keynoter1542381keynoter
keynotes1543631keynotes
denoted93512762de_noted
keynoters1642312keynoters
beknotted1642353beknotted
besnowed14124413besnowed
cenote83715843ce_note_
cenotes92814543ce_notes
connoted1138863connoted
demoted114313543de_moted
denote74118043de_note_
denotes83817003de_notes
dented84120513de_n_ted
devoted124111093de_voted
emoted94614923_e_moted
escoted1038183_escoted
feinted11379623fein_ted
hented104218753he_n_ted
kayoed14416903kay_o_ed
keened114013633keen__ed
kenned114411273ke_n_ned
kenneled1334003kenneled
kenotic1359713ke_notic
kente95821073ke_n_te_
kentes105118653ke_n_tes
kerned114112933kern__ed
kerneled1344033kerneled
kernite1159473kernite_
kernites1269113kernites
keyboard1844503keyboard
keyed1369393key___ed
keyhole1764433keyhole_
keyholes1844593keyholes
keynoting1742813keynoting
keyster14256153key_ster
keyword1844563keywo_rd
knotted12357233k__notted
knouted12416773k__nouted
lenited8812433le_nited
noted65123843___noted
pennated11299543pennated
pennoned1136313pennoned
peyote1139853pey_ote_
peyotes1238483pey_otes
rebooted11248463rebooted
reknotted1443523reknotted
rented74426593re_n_ted
reunited939713reunited
revoted114314153re_voted
telneted935073telneted
tenoned839363te_noned
tented74221003te_n_ted
unnoted8311363_unnoted
venomed1336653ve_nomed
vented104617923ve_n_ted

Search took 7 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 Filter1786911461620.423422437.4
2DLD Change Limit146162576.03024239.1
3Display Results57570.0163562.5
 (SQL Overall)178691576.46927622.7
 
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.