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

122 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
kayakers146361(None) 
kayaker1354501kayaker_
haymakers21104552haymakers
kayaked1474052kayake_d
kayaks1236332kayak__s
abasers95311973_abasers
abaters95115203_abaters
askers105915403_a_skers
awakens14416153_awakens
awakes135012473_awake_s
backers153821883ba_ckers
bakers125323453__bakers
balkers134915723ba_lkers
bankers133919093ba_nkers
barkers134318513ba_rkers
bayadeers1541963bayadeers
bayadere1443373bayadere
bayaderes1543583bayaderes
beakers134216873_beakers
breakers143810973breakers
cadavers1435893cadavers
calkers134414693ca_lkers
cankers134418753ca_nkers
capmakers1944723capmakers
carmakers1736923carmakers
caulkers14375653caulkers
comakers16339173comakers
croakers14288523croakers
dackers143417043da_ckers
daikers124010313da_ikers
damagers1237063damagers
fakers134219533__fakers
flakers143613273_flakers
gawkers15347453ga_wkers
hackers164619043ha_ckers
hanapers1346963hanapers
hankers144218133ha_nkers
hatmakers18105173hatmakers
hawkers174210333ha_wkers
hayers124415943hay__ers
haymaker20104773haymaker_
jackers204214453ja_ckers
jayhawkers3051123jayhawkers
jaywalkers2751733jaywalkers
kabakas12367403kabak_as
kabars124513953kaba__rs
kaiaks937043kaiak__s
kaisers11369273ka_isers
kanakas10327213kanak_as
karakuls1142083karakuls
karaokes1145013karaoke_s
karates115617473karate_s
kashers143914023ka_shers
kayak1138363kayak___
kayaking1534063kayaking
kayakings1642683kayakings
kayles134712003kay_le_s
kayoes134710823kay_oe_s
keysters15326333keysters
kickers124013293k_ickers
knackers13286843knackers
kneaders1384713kneaders
knickers13306723knickers
knockers13285733knockers
krakens1034293k_rakens
kraters114212343k_raters
kyaks11459163k_yak__s
kyars124813963k_ya__rs
laagers83411253la_agers
lackers134120543la_ckers
lakers105225153__lakers
larkers113014513la_rkers
lawmakers1843893lawmakers
layers93921183lay__ers
layovers1434073layovers
leakers113415423_leakers
makers123921733__makers
managers112911003managers
mapmakers1944043mapmakers
markers133516103ma_rkers
maskers133913843ma_skers
naysayers1542353naysayers
packers153818893pa_ckers
palavers1337993palavers
paraders113113113paraders
parkers133816873pa_rkers
partakers1536563partakers
payers114621823pay__ers
playmakers2143103playmakers
quakers20309693_quakers
rackers134320453ra_ckers
rakers104123573__rakers
rankers113217463ra_nkers
ravagers1235583ravagers
remakers143811303remakers
retakers123511133retakers
sackers133820223sa_ckers
sakers104125433__sakers
sayers94221593say__ers
shakers144015563_shakers
skankers11316483ska_nkers
slakers114115753_slakers
sneakers12308643sneakers
soakers114114953_soakers
speakers14299453speakers
tackers134319623ta_ckers
takers103923743__takers
talkers113513213ta_lkers
tanagers9259003tanagers
tankers113416913ta_nkers
teamakers1544873teamakers
unmakers14256653unmakers
voyagers1532813voyagers
wakers134822493__wakers
walkers143411473wa_lkers
wankers144514713wa_nkers
warmakers1845633warmakers
wayfarers1842623wayfarers
waylayers1842943waylayers
wreakers15328423wreakers
yagers105114533__yagers
yakkers13304273ya_kkers

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.406440125.6
2DLD Change Limit1461621226.15623743.0
3Display Results1221220.0462652.2
 (SQL Overall)1786911226.60827041.6
 
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.