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

448 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
kayaks123633(None) 
kaiaks937041kaiaks
kayak1138361kayak_
kyaks11459161k_yaks
araks94820882_araks
ayahs116813522_ayahs
galyaks1534622galyaks
gayals1039512gayals
kaas86531842ka_a_s
kababs14409772kababs
kabaka11348502kabaka
kabakas12367402kabakas
kabars124513952kabars
kaiak8310352kaiak_
kakas85117342kaka_s
kalams12310602kalams
kalpaks12366162kalpaks
kamiks11387912kamiks
kanaka9357522kanaka
kanakas10327212kanakas
kanas95326912kana_s
kapas116021732kapa_s
kapoks11347262kapoks
karats106420492karats
katas95922092kata_s
kavas125919952kava_s
kavass13517302kavass
kayaked1474052kayaked
kayaker1354502kayaker
kayakers1463612kayakers
kayles134712002kayles
kayoes134710822kayoes
kayos127714702kay_os
kays116032192kay__s
kulaks976112kulaks
kyacks14416062kyacks
kyak105213632k_yak_
kyars124813962k_yars
kyats125012442k_yats
mayas105924382maya_s
rayahs12579192rayahs
rayas85922052raya_s
yaks116025202__yaks
aahs716428563_a_ahs
aals49941143_a_als
aas310975393_a_a_s
abaka114313823_abaka
abakas123911743_abakas
abas68642083_aba_s
abayas114011703abaya_s
afars85716513_afars
agars66120643_agars
agas55938843_aga_s
alans55636173_alans
alas46358123_ala_s
amahs107819063_amahs
amas67746293_ama_s
amass77119683_amass
amoks11413553_amoks
anas46649863_ana_s
arak86929573_arak_
arks85936873_a_rks
asks85721213_a_sks
ataps76414833_ataps
auks85525263_a_uks
awake125014783_awake
awakes135012473_awakes
ayah108022993_aya_h
ayes76543513_ay_es
ayins85321613_ayins
ays67050293_ay__s
azans146516883_azans
baals76122703ba_als
baas66844673ba_a_s
babas96325733baba_s
babkas146010143babkas
backs135729623ba_cks
badass949293badass
bagass938933bagass
balas76937213bala_s
balks114926293ba_lks
banks115527903ba_nks
banyans1237913banyans
barks115735813ba_rks
basks115621763ba_sks
batiks1239373batiks
baulks12429373baulks
bayamo1335603bayamo
bayamos1434663bayamos
bayard124411663bayard
bayards13379683bayards
bayous11411153bayous
bays97143913bay__s
bazars174613113bazars
beaks115326623_beaks
bleaks125112433bleaks
boyars115611983boyars
breaks124816423breaks
cabals104020153cabals
cacaos104616183cacaos
cacas95627983caca_s
calks115421603ca_lks
camas96333523cama_s
camass104114183camass
canals84421673canals
caracks152211563caracks
carats85929023carats
carks115534213ca_rks
casas75327843casa_s
casks115720063ca_sks
caulks125611863caulks
caymans14349513caymans
cays95437673cay__s
cloaks124411263cloaks
creaks124315963creaks
croaks125812983croaks
cyans105714813_cyans
dadas75819863dada_s
daks97130603__daks
damans94715983damans
damars93815003damars
damask1335843damask
damasks1435073damasks
darks106727873da_rks
dawks135213493da_wks
days87637133day__s
dhaks13479703_dhaks
dryads11436623dryads
dyads10549973_dyads
eyas76427433_eya_s
eyass84410783_eyass
farads104713273farads
favas115618593fava_s
fays108535363fay__s
freaks134713063freaks
gagaku1243813gagaku
gagakus1342883gagakus
galahs105512683galahs
galas65731643gala_s
galyacs1335273galyacs
galyak1445333galyak_
gamas85431363gama_s
gamays126310913gamays
gawks136811633ga_wks
gayal9312713gaya_l
gaydars1235803gaydars
gays87338023gay__s
gazars164811553gazars
haafs115711163ha_afs
haars85620473ha_ars
haceks15447863haceks
hacks144928713ha_cks
hahas117118443haha_s
haiks125120933ha_iks
halals95018313halals
hamals114816833hamals
hanks126226863ha_nks
harass9313943harass
harks126333433ha_rks
hawks155415703ha_wks
hayers124415943hayers
hayracks2045313hayracks
hays106138073hay__s
hazans183411653hazans
hoyas115016163hoya_s
jacals1539873jacals
jacks185219833ja_cks
jalaps15299183jalaps
japans1539823japans
jauks165412463ja_uks
javas155915423java_s
jawans1657843jawans
jays146328343jay__s
jaywalks2542143jaywalks
kabab134814443kaba_b
kabala124011553kabala
kabalas133911063kabalas
kabar114815553kaba_r
kabaya15387123kabaya
kabayas16316803kabayas
kabiki1134783kabiki
kabikis1243863kabikis
kabobs14439303kabobs
kabs107130843k__abs
kabuki1143963kabuki
kabukis1243193kabukis
kadis105921063ka_dis
kaes85734063k__aes
kafirs13306983kafirs
kafs116423743k__afs
kaftans14185353kaftans
kagus105812033ka_gus
kaifs125715643ka_ifs
kails95525213ka_ils
kains96125643ka_ins
kaka76518683k__aka
kakapo1143853kakapo
kakapos1243673kakapos
kaki76520913k__aki
kakis86116843ka_kis
kalam11315113kala_m
kales95730983ka_les
kalians11310183kalians
kalifs134410983kalifs
kalpacs15327133kalpacs
kalpak11437243kalpak_
kalpas124112943kalpas
kamala12339963kamala
kamalas13339123kamalas
kames115024693ka_mes
kamik105011553kamik_
kana85928533kana__
kanbans1337723kanbans
kanes95529373ka_nes
kanjis1735963kanjis
kantars11310033kantars
kanzus1944603kanzus
kaons95014853ka_ons
kapa106021293kapa__
kaphs144911503ka_phs
kapok10448783kapok_
kappas144410363kappas
karakul1042553karakul
karakuls1142083karakuls
karaoke1044903karaoke
karaokes1145013karaokes
karat96837593kara_t
karate105320923karate
karates115617473karates
karmas123013733karmas
karns96624143ka_rns
karoos102415803karoos
kaross101910013kaross
karsts106012943karsts
karts97630113ka_rts
kas77058583k__a_s
kasbahs1634363kasbahs
kashas133311903kashas
kata85626023kata__
kats85944333k__ats
kauris103611533kauris
kava115819703kava__
kay106745543kay___
kayaking1534063kayaking
kayakings1642683kayakings
kayo116417553kay__o
kayoed14416903kayoed
kazoos19259113kazoos
kbars114612603k_bars
keas86337093k_ea_s
kebabs14418513kebabs
kebars124112493kebars
kecks105416573k_ecks
keeks84717253k_eeks
kenafs1337113kenafs
keypads1743343keypads
keypals1634353keypals
keys116322163key__s
keyways2043373keyways
khafs15648843k_hafs
khaki1157643k_haki
khakis1265853k_hakis
khans124615173k_hans
khats125316013k_hats
kicks104420083k_icks
kinas95626913kina_s
kinks84926083k_inks
kiosks934383kiosks
kirks84915263k_irks
kivas124614733kiva_s
klicks11468723klicks
kliks8398823k_liks
knacks11428543knacks
knaps115511173k_naps
knars94416113k_nars
kneads11357093kneads
knocks11397443knocks
koalas104011663koala_s
koans95818623k_oans
koas85635093k_oa_s
kolas94822233kola_s
konks84917113k_onks
kooks85217263k_ooks
kopeks1134603kopeks
koras95927113kora_s
korats105416063korats
kraals10378433kraals
kulak858823kulak_
kulaki984293kulaki
kvas117015943k_va_s
kvass12507273k_vass
kyack13468263k_yack
kyar116916843k_ya_r
kyat116025523k_ya_t
kyes115124933k_y_es
kytes125012913k_ytes
lacks116129203la_cks
lagans75717783lagans
lahars94013163lahars
lamas75532793lama_s
lanais6316793lanais
larks95227813la_rks
lauans65113533lauans
lavas85422223lava_s
layers93921183layers
layins93817653layins
lays76043253lay__s
layups1133993layups
lazars153812393lazars
leaks95923913_leaks
maars74621633ma_ars
macaws1337023macaws
macks135127603ma_cks
madams11310943madams
makars124612633makars
malars85020683malars
mamas95930773mama_s
manas76240433mana_s
manats84623463manats
maras75443293mara_s
markas124717003markas
marks115933483ma_rks
masas75630413masa_s
masks115320533ma_sks
maya95824593maya__
mayan105616903maya_n
maybes1339243maybes
maydays1634493maydays
mayors115714193mayors
mayos105521933may_os
mays96940033may__s
naans55815253na_ans
nadas66320813nada_s
naiads739013naiads
nalas55528363nala_s
nanas55928633nana_s
napas75924353napa_s
narks96026033na_rks
nasals63312463nasals
navars92810573navars
nawabs1185063nawabs
nays75931593nay__s
naysays1344123naysays
oaks86527903__oaks
okays12609443okay__s
pacas96029403paca_s
packs135528933pa_cks
padauks1443943padauks
paeans85118263paeans
pagans95717923pagans
paiks114719853pa_iks
palais8420423palais
papas94927493papa_s
papaws13419113papaws
paras76143043para_s
parkas125018023parkas
parks116134463pa_rks
pavans115715593pavans
paybacks2145493paybacks
paydays1634433paydays
payees114812903payees
payers114621823payers
payors114312643payors
pays95940223pay__s
peaks114825623_peaks
playas114612283playa_s
pyas96225703_pya_s
qanats154112813qanats
rabats83116223rabats
racks115028853ra_cks
radars71314673radars
ragas65326063raga_s
raias54631123raia_s
rajahs16497663rajahs
rajas127317723raja_s
ranks95225733ra_nks
ratals64219583ratals
ratans63819373ratans
raya75224823raya__
rayah116013503raya_h
rayons94113343rayons
rays77642353ray__s
riyals94111083riyals
royals93711263royals
ryas77224613_rya_s
sabals84618863sabals
sacks114228873sa_cks
sagas66025883saga_s
salads75316963salads
salals65120083salals
sameks12409323sameks
sanjaks1834963sanjaks
sarans64224433sarans
sarks96632463sa_rks
satays94411683satays
sayeds10469253sayeds
sayers94221593sayers
sayids104310973sayids
says75942103say__s
skanks94710833ska_nks
sneaks104312493sneaks
soaks95220293_soaks
soyas84520913soya_s
speaks125114583speaks
steaks104415853steaks
tacks115430133ta_cks
takas95520683taka_s
talars66021683talars
talas55935893tala_s
talks94322693ta_lks
taluks10418283taluks
tamals84116633tamals
tambaks15218153tambaks
tankas104613763tankas
tanks94624733ta_nks
tapas74627713tapa_s
taroks106115283taroks
tasks94917583ta_sks
tatars64619793tatars
teaks94222903_teaks
tilaks1097353tilaks
tokamaks1342133tokamaks
troaks104410603troaks
tweaks1335963tweaks
umiaks1244953umiaks
varas86028193vara_s
wacks146626283wa_cks
walks126218503wa_lks
wanks126124483wa_nks
warks127932403wa_rks
wataps11248683wataps
wauks125515163wa_uks
waylays1634673waylays
ways107737953way__s
wreaks134711113wreaks
yacks144419813ya_cks
yags86632293__yags
yak107038563__yak_
yams95330733__yams
yanks125316573ya_nks
yapoks15346783yapoks
yaps95933523__yaps
yasmaks1633653yasmaks
yaws105531213__yaws
yays105728913__yays
yoks116223743__yoks
yuks116418023__yuks
zayins18409713zayins

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 Filter1786911127160.393454684.5
2DLD Change Limit1127164485.51320445.5
3Display Results4484480.1732589.6
 (SQL Overall)1786914486.07929394.8
 
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.