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

170 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
canakin13181083(None) 
canakins142010461canakins
canikin13189751canikin
manakin131810641manakin
calkin123515492ca_lkin
canaling112016412canaling
canikins14219162canikins
cannabin1266432cannabin
cannikin14196072cannikin
carabin11313212carabin
catkin123512382ca_tkin
manakins14209762manakins
manikin132110242manikin
nankin1039672nan_kin
unakin10310962_unakin
acrasin9311223acrasin
again65218123_aga_in
akin86328033___akin
alanin6317273_alanin
amain74922913_ama_in
anilin6417793_anilin
awaken13468863_awaken
awaking1547813_awaking
banking144621353ban_king
bankit123617043ban_kit
cabin94820943c__abin
caffein1535333caffein
cain65643913c__a_in
caking134624673c__aking
calami10313423calami_
calamine12314033calamine
calamint12315133calamint
calfskin1743213calfskin
calking144617783ca_lking
calkins133814873ca_lkins
calpain11310413calpain
camail10314833cama_il
canal75428043cana__l
canaled103615563canaled
canalise10816213canalise
canalize19914493canalize
canalling1239553canalling
canals84421673cana_ls
canape10913513cana_pe
canapes111213083canapes
canard9314763cana_rd
canards10311203canards
canaries10318943canaries
canary11314693cana_ry
canasta938363canasta
cancan10314103can_can
candid104517853can_did
candling122313873candling
candying15188993candying
canid85526343can__id
canine83826703can__ine
caning94128623can__ing
canker124422523can_ker
cannabic1474913cannabic
cannabins1365783cannabins
cannabis1266033cannabis
cannie83819363can_nie
cannikins15225683cannikins
canning103620133can_ning
cannon84514443can_non
canoeing11310213canoeing
canon74725303can__on
canonic11312933canonic
canopic1338803canopic
canteen9411083canteen
canthi11310973canthi_
cantic103920543can_tic
cantina93417253can_tina
canting104725903can_ting
canton85722993can_ton
cantrip112910043cantrip
canvasing1546433canvasing
canyon114512033can_yon
canzoni1836153canzoni
capelin11510973capelin
capeskin1644403capeskin
caplin103216303ca_plin
captain112111063captain
carabid12311333carabid
carabine12412393carabine
carabins12312363carabins
caravan1239233caravan
carking144322853ca_rking
carlin84421823ca_rlin
carnation11312943carnation
carotin92216733carotin
casein83216453ca_sein
casking144317353ca_sking
catkins133012563ca_tkins
catlin83819083ca_tlin
caulking1536803caulking
cavatina1347333cavatina
cavatine13310323cavatine
ceratin93020163ceratin
chain105723673c_ha_in
characin1547993characin
cinerin9313823cinerin
clanking154313063clan_king
cloaking15299713cloaking
cocain101315013coca_in
comaking1739993comaking
conation101420883conation
conin76232723con__in
conjoin1638203conjoin
conking143618453con_king
contain9315833contain
coonskin1444393coonskin
cowskin1645553cowskin
cranking154613073cran_king
crankpin16103753crankpin
creaking153414123creaking
creatin93618133creatin
croaking153712163croaking
cumarin1139263cumarin
cyanamid1644223cyanamid
cyanin113911453c_yanin
cycasin1445903cycasin
fanatic12610703fanatic
finikin14266863finikin
gaskin113610583ga_skin
halakic1656663halakic
hankie133915713han_kie
hanking154619103han_king
jalapin1645923jalapin
kanaka9357523kanak_a
kanakas10327213kanakas
kayaking1534063kayaking
ladykin1543963ladykin
lambkin1545243lambkin
lanai5319573lana_i_
lanais6316793lana_is
lanolin7310643lanolin
latakia1146093latakia
malkin122913153ma_lkin
managing1239093managing
mandarin11411023mandarin
manganin1147543manganin
manikins14189723manikins
mankind1437773man_kind
mannikin14215503mannikin
minikin13258983minikin
nandin7313033nan_din
nankins1159053nan_kins
napkin1236903na_pkin
paladin101011773paladin
pancaking1836383pancaking
pannikin14194923pannikin
papain10313793papa_in
punkin123611523pun_kin
ramekin13126493ramekin
ranking124320883ran_king
savarin10310003savarin
snaking123915303_snaking
swanskin1543533swanskin
takin94921303__takin
tamarin9311923tamarin
tanking123918793tan_king
tankini11338923tan_kini
tannin62613923tan_nin
tanuki1034913tanuki_
tanukis1134713tanukis
vanadic1336743vanadic
wanking154216783wan_king
xanthin1747043xanthin
yanking154512463yan_king

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271706.21621561.6
3Display Results1701700.0632698.4
 (SQL Overall)1786911706.70226662.3
 
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.