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

58 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
kendo10511322(None) 
kendos114510661kendos
keno87926431ken_o
bend76435262bend_
bends85628972bends
bendy115017252bendy
bento75922952bento
cento76625172cento
condo85322592condo
eddo63411802_eddo
end46834352_end_
endow94510982_endow
ends56528522_ends
fend84832972fend_
fends96324972fends
genro64914032genro
ken76343982ken__
kenaf12316032kenaf
kench145513922kench
kenos95220622kenos
kens85435232ken_s
kent86846962ken_t
kente95821072kente
keto86223452ke_to
kiddo11398952kiddo
kind96128562kind_
kinds106221822kinds
kino86233622kin_o
kudo96115112k_udo
lend56233672lend_
lends65326252lends
leno47331392len_o
lento57223392lento
mend75334032mend_
mends84927692mends
meno66031362men_o
menudo945792menudo
mondo85721232mondo
pend75934532pend_
pends85527192pends
pengo84317592pengo
redo56029362re_do
rend56136572rend_
rends65129952rends
rondo65218372rondo
send55237292send_
sends65528242sends
tend56433772tend_
tendon7312032tendon
tends65425582tends
tendu67216002tendu
tondo69718682tondo
undo55620152_undo
vend86626422vend_
vendor10359802vendor
vends95520892vends
wend85330452wend_
wends95822812wends

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit53800581.32640573.2
3Display Results58580.0163625.0
 (SQL Overall)178691581.655107970.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.