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

110 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
kenned11441127(None) 
denned84215631denned
keened114013631keened
kennel10369221kennel
kerned114112931kerned
penned94217611penned
yenned10409381yenned
banned94721342banned
beaned95621472beaned
bended105521232bended
benne76521122benne_
bennes86019012bennes
bennet84823362bennet
binned94414542binned
canned95022062canned
censed94016322censed
conned95119702conned
deaned84620452deaned
denied84318632denied
dented84120512dented
dinned84317612dinned
donned85015742donned
dunned85015522dunned
ended74421262_ended
ennead736252_ennead
fanned104117472fanned
fenced124412712fenced
fended114216912fended
fennec11326912fennec
fennel9429472fennel
finned104114602finned
funned103613952funned
ginned83813982ginned
gunned83513092gunned
hennaed1135102hennaed
hented104218752hented
inned64118422_inned
jeaned143813462jeaned
jennet134714952jennet
kecked125113172kecked
kedged13439752kedged
keeked104810122keeked
keeled114414272keeled
keener104012842keener
kegged13469262kegged
kelped13449552kelped
kenneled1334002kenneled
kennels11387192kennels
kente95821072kente_
kentes105118652kentes
kepped15309542kepped
kerbed13339702kerbed
kerfed14358232kerfed
kerne94718222kerne_
kernel104010592kernel
kernes104717532kernes
keyed1369392ke_yed
kilned11368392kilned
kinged124215292kinged
kinked104014752kinked
kirned11408622kirned
kneed104612052k_need
konked104010582konked
leaned73422542leaned
lensed74015472lensed
manned94418642manned
mended104418682mended
mensed93916542mensed
neoned7311482neoned
panned94123432panned
peened94318162peened
peined94918842peined
pended103819012pended
penne75423852penne_
penner84616662penner
pinned94818382pinned
punned93416192punned
reined74425522reined
rended84524102rended
rennet64624852rennet
rented74426592rented
seined74023062seined
sended85121232sended
sennet64224142sennet
sensed73918162sensed
sinned73818412sinned
skeined1236772skeined
skinned12387292skinned
sunned74216322sunned
tanned75219952tanned
tended83819482tended
tenner64117102tenner
tenoned839362tenoned
tensed74817832tensed
tented74221002tented
tinned74317532tinned
tunned74014492tunned
unkenned1336182unkenned
vanned104614482vanned
veined104413912veined
vended114416352vended
venged114011992venged
vented104617922vented
wanned104318012wanned
weaned103816152weaned
weened104013732weened
wended113616152wended
winned104017012winned
wonned104012062wonned
yeaned103813902yeaned

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.346516448.0
2DLD Change Limit825511102.39034540.2
3Display Results1101100.0303666.7
 (SQL Overall)1786911102.76664602.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.