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

158 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
kayaked147405(None) 
kayaker1354501kayaker
awaked14579202_awaked
kayak1138362kayak__
kayakers1463612kayakers
kayaks1236332kayak_s
kayoed14416902kay_oed
aahed917816443_a_ahed
abased96514993_abased
abated95918453_abated
alated75625153_alated
amazed18519313_amazed
arcked136211943_arcked
asked106919313_a_sked
awake125014783_awake_
awaken13468863_awaken
awakes135012473_awakes
baaed85218163ba_a_ed
backed155725723ba_cked
baked126130773__baked
balked135219413ba_lked
banked135021443ba_nked
barked135027313ba_rked
basked135218603ba_sked
batiked1435963batiked
baulked14465623baulked
bayard124411663baya_rd
bayed115423023bay__ed
beaked135919493_beaked
beraked144312433beraked
braked135318693_braked
caked126128623__caked
calked134617403ca_lked
canaled103615563canaled
carked134024823ca_rked
casked134815513ca_sked
caulked14486673caulked
cloaked14368543cloaked
creaked143413233creaked
croaked143710533croaked
damaged1257463damaged
damasked1643753damasked
darked123919633da_rked
daybed13438673day_bed
dyked145310953_dy_ked
faked135225483__faked
fayed126422153fay__ed
flaked144715653_flaked
freaked15399703freaked
garaged1039253garaged
gawked15468763ga_wked
hacked164923513ha_cked
hanked144220603ha_nked
harked145422553ha_rked
hawked174712673ha_wked
hayed125822013hay__ed
haymaker20104773haymaker
hayseed1435633hayseed
jacked204817523ja_cked
jauked18489013ja_uked
jaywalked2741523jaywalked
kabaka11348503kabak_a
kabakas12367403kabakas
kaiak8310353kaiak__
kaiaks937043kaiak_s
kanaka9357523kanak_a
kanakas10327213kanakas
karakul1042553karakul
karaoke1044903karaoke_
karaokes1145013karaokes
karate105320923karate_
karates115617473karates
kayaking1534063kayaking
kayles134712003kay_les
kayoes134710823kay_oes
kecked125113173k_ecked
keeked104810123k_eeked
keyed1369393key__ed
kicked124415943k_icked
kinked104014753k_inked
knacked13287793knacked
kneaded13146473kneaded
knocked13236303knocked
konked104010583k_onked
kraaled12254983kraaled
kraken955883k_raken
kyak105213633k_yak__
kyaks11459163k_yak_s
kythed17407313k_ythed
lacked135324653la_cked
laked105731123__laked
lanated8313203lanated
larked114519473la_rked
layed95127383lay__ed
layered11259413layered
leaked114217703_leaked
managed113212603managed
marked133921623ma_rked
masked134316523ma_sked
mayed115522403may__ed
mayweed1634163mayweed
naked105320853__naked
narked114116743na_rked
okayed1434253okay__ed
packed154822603pa_cked
paiked135113433pa_iked
palaced124110783palaced
pancaked1734893pancaked
paraded114014263paraded
parbaked1735503parbaked
parked134425143pa_rked
payed115925933pay__ed
peaked136117403_peaked
quaked203910033_quaked
racked134526083ra_cked
raked105831423__raked
ranked114620743ra_nked
ravaged1236493ravaged
rayed95127503ray__ed
reawaked16366623reawaked
rewaked153811903rewaked
ryked13669513_ry_ked
sacked135525213sa_cked
savaged1236993savaged
sayed96127143say__ed
skanked11338103ska_nked
slaked114318273_slaked
snaked115017593_snaked
sneaked12329693sneaked
soaked114717593_soaked
staked114621943_staked
straked125415343straked
tacked134723943ta_cked
talcked1446343talcked
talked114015403ta_lked
tanked113919293ta_nked
tasked114714643ta_sked
troaked12438253troaked
tweaked1534403tweaked
unawaked1635903unawaked
unbaked143312893unbaked
uncaked143514353uncaked
unfaked153211173unfaked
unraked122914013unraked
unyoked1567123unyoked
vacated1349353vacated
voyaged1533513voyaged
waked135626753__waked
walked145313783wa_lked
wanked144517153wa_nked
warked144421213wa_rked
wauked144210573wa_uked
wreaked15369023wreaked
yacked164516793ya_cked
yakked13366093ya_kked
yanked144312243ya_nked
yawed126022453__yawed
yoked134821623__yoked

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.410435831.7
2DLD Change Limit1340271587.01319111.2
3Display Results1581580.0463434.8
 (SQL Overall)1786911587.46923924.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.