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

472 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
nankin103967(None) 
nandin7313031nandin
nankins1159051nankins
napkin1236901napkin
akin86328032_a_kin
banking144621352banking
bankit123617042bankit
calkin123515492calkin
canakin131810832canakin
canikin13189752canikin
catkin123512382catkin
gaskin113610582gaskin
hankie133915712hankie
hanking154619102hanking
malkin122913152malkin
manakin131810642manakin
manikin132110242manikin
mankind1437772mankind
nandina838912nandina
nandins8312002nandins
nankeen1135042nankeen
nannie63713222nannie
napkins1336672napkins
narking124015382narking
punkin123611522punkin
ranking124320882ranking
takin94921302ta_kin
tanking123918792tanking
tankini11338922tankini
tannin62613922tannin
unakin10310962una_kin
wanking154216782wanking
yanking154512462yanking
actin74922553_actin
again65218123_again
agin56132713_a_gin
ain37579093_a__in
alanin6317273alan_in
algin65718763_algin
alkie95520033_alkie
alkine104916803_alkine
aloin55227423_aloin
amain74922913_amain
amin66042253_a_min
ananke1038283anank_e
anankes1138763anankes
ancon75718233_ancon
angina7413133_angina
ani37751183_an_i_
anil46437433_an_il
anilin6417793anilin
anion55028813_anion
anis45746463_an_is
ankh111114413_ank_h
ankhs12116723_ankhs
ankle95220253_ankle
ankling122912063_ankling
ankus91410683_ankus
anoint6423633_anoint
anon46134853_an_on
anti45536363_anti_
antic75728863_antic
anting75827023_anting
antis55033313_antis
anvil82712603_anvil
anyon85615223_anyon
asking116017233_asking
auxin121411913_auxin
ayin76331743_a_yin
backing165523443backing
baking135626623ba_king
balking143717353balking
banding114921413banding
bandit93821133bandit
banging114019863banging
bani65334963ban_i_
banian8315383banian
baning95127833ban_ing
bank105835753bank__
banked135021443banked
banker124222733banker
bankings15489403bankings
bankits133410153bankits
banks115527903bank_s
banksia1335943banksia
banning103818233banning
banyan1139483banyan
barking144724183barking
basin75026923ba_sin
basking144718613basking
benzin1738933benzin
blanking154411933blanking
bodkin1338923bodkin
bonking144116373bonking
bumkin14308083bumkin
bunking144016193bunking
buskin123811493buskin
cabin94820943ca_bin
cain65643913ca__in
caking134624673ca_king
calking144617783calking
calkins133814873calkins
canakins142010463canakins
cancan10314103cancan
candid104517853candid
canid85526343can_id
canikins14219163canikins
canine83826703can_ine
caning94128623can_ing
canker124422523canker
cannie83819363cannie
cannikin14196073cannikin
canning103620133canning
cannon84514443cannon
canon74725303can_on
cantic103920543cantic
cantina93417253cantina
canting104725903canting
canton85722993canton
canyon114512033canyon
caplin103216303caplin
carking144322853carking
carlin84421823carlin
casein83216453casein
casking144317353casking
catkins133012563catkins
catlin83819083catlin
clanking154313063clanking
conin76232723con_in
conking143618453conking
cranking154613073cranking
crankpin16103753crankpin
cyanin113911453cyan_in
daikon11217243daikon
dancing113611563dancing
danging103716093danging
danio6319783dan_io
dank95828243dank__
danker114319663danker
dankly14419463dankly
darken114013443darken
darkie113714013darkie
darking134217343darking
dentin73919573dentin
dinking133618283dinking
dunking133813263dunking
dunlin739723dunlin
dynein1035563dynein
eanling81416673eanling
fadein1068843fadein
fagin9216573fa_gin
fain75840563fa__in
faking145520983fa_king
fakir125111493fa_kir
fanfic1436313fanfic
fanion94514323fanion
fanning113615073fanning
fanon84619013fan_on
fanzine1937123fanzine
finikin14266863finikin
finking154016603finking
firkin1337823firkin
flanken14226763flanken
flanking164211083flanking
franking164310863franking
franklin15104603franklin
funkia1336343funkia
funking154013023funking
gaijin1445983gaijin
gain56042163ga__in
gamin84423003ga_min
ganging103216193ganging
ganoid8314443ganoid
gasking134415913gasking
gaskins123510773gaskins
gawking16398823gawking
guanin7610803guan_in
hackie154615623hackie
hacking173720613hacking
haemin113412663haemin
hakim14311833ha_kim
handing123518893handing
hanging123518703hanging
hank115134143hank__
hanked144220603hanked
hanker134622093hanker
hankies143617763hankies
hanks126226863hank_s
hanky155418293hank_y
hanting114124483hanting
harken135116343harken
harking154120943harking
harmin113117393harmin
harpin113614383harpin
hatpin112610613hatpin
hawkie163810093hawkie
hawking183711423hawking
honkie133011673honkie
honking153414793honking
hunkie133812383hunkie
inking115119053_inking
jacking214515263jacking
jasmin1538073jasmin
jauking19418323jauking
jerkin17258113jerkin
jinking193613543jinking
junkie17339603junkie
junking193910073junking
kain85334293ka__in
kaki76520913ka_ki_
kakis86116843ka_kis
kamsin1238323kamsin
kanban1238623kanban
kanji1647453kanji_
kanjis1735963kanjis
kaolin1039583kaolin
kin76353973___kin
kinin94917323kin_in
kinking113615153kinking
knacking14296713knacking
konking113510213konking
lacking143821543lacking
ladykin1543963ladykin
lain46146283la__in
laking115027043la_king
lambkin1545243lambkin
lanai5319573lanai_
lanais6316793lanais
lancing103314123lancing
landing92819323landing
lank84734453lank__
lanker104123003lanker
lankier113711633lankier
lankily1437123lankily
lankly13439623lankly
lanky125517483lank_y
lanolin7310643lanolin
lapin75222923la_pin
larking123718253larking
lattin64316223lattin
layin84720333la_yin
linin58025523lin_in
linking123818253linking
main65345523ma__in
making134823853ma_king
malkins133311803malkins
manakins14209763manakins
mania75634153man_ia
manic94629443man_ic
manikins14189723manikins
mannan85413623mannan
mannikin14215503mannikin
manning103616383manning
mansion9611543mansion
mantic104120903mantic
mantid93820383mantid
mantis83926033mantis
margin94016843margin
marking144020133marking
marlin84220903marlin
martin84122523martin
masking145116613masking
matin75132853ma_tin
mattin84416633mattin
mavin105722953ma_vin
mayvin1436523mayvin
minikin13258983minikin
muntin82915183muntin
naan47621933na__an
nabbing12299963nabbing
nabis76020583na_bis
nadir61012973na_dir
naevi867873naevi_
naffing14359033naffing
nagging102613043nagging
naif76839023na__if
nail45838653na__il
nailing83419963nailing
naked105320853na_ked
nakfa1236093na_kfa
naming93917893na_ming
nan37854883na___n
nana46632903nan__a
nanas55928633nan_as
nance74721843nan_ce
nances83618643nances
nancies93516843nancies
nancy105214923nan_cy
nandinas936573nandinas
nanism8311203nanism
nankeens1243243nankeens
nannies73015203nannies
nanny84813813nan_ny
nans46139403nan__s
naoi46024633na_oi_
nappie104112263nappie
napping123514183napping
narcein936293narcein
nardine82712573nardine
naric76824173na_ric
narine63422553na_rine
naris55735293na_ris
nark85230063nark__
narked114116743narked
narks96026033nark_s
narky126017803nark_y
nasion63914083nasion
nastic82915973nastic
nation64322803nation
natron64116023natron
navaid1037653navaid
nazi136219873na_zi_
nazis145216083na_zis
necking143913893necking
niacin8310223niacin
nicking143516323nicking
ninepin945573ninepin
ninon55517383nin_on
nocking143615113nocking
noggin8288883noggin
nonfan948293nonfan
nonman8412363nonman
nonmen8412833nonmen
nonskid1246383nonskid
nookie103712433nookie
nubbin10308293nubbin
nuking113411253n_uking
nuncio837973nuncio
oaken95814383oa_ken
oinking123714713oinking
packing164420723packing
paiking143814813paiking
pain65647243pa__in
pandit93820753pandit
pangen94115913pangen
panging113319113panging
panic93923903pan_ic
panini8314273pan_ini
panino8315683pan_ino
pannikin14194923pannikin
panning104019393panning
pantie84326473pantie
panting104025423panting
papain10313793papain
parking143423043parking
patin76832853pa_tin
paulin8312983paulin
pavin105623203pa_vin
pekin111514423_pekin
pinken124513283pinken
pinkie124414273pinkie
pinking143918943pinking
pinyin112710613pinyin
pipkin14248603pipkin
planking153513013planking
pranking153813383pranking
punkie123513613punkie
punkins133111113punkins
rabbin103112303rabbin
racking144323663racking
rain46251733ra__in
raisin62716923raisin
raki87127833ra_ki_
raking114728423ra_king
rakis95323443ra_kis
ramekin13126493ramekin
rancid9513863rancid
randan7315253randan
ranging94120263ranging
rani46640113ran_i_
ranid66429333ran_id
ranis55235833ran_is
rank85135533rank__
ranked114620743ranked
ranker105021903ranker
rankings13389173rankings
rankish14510383rankish
rankle103414883rankle
rankling132610113rankling
rankly133910453rankly
ranks95225733rank_s
ranting84025413ranting
ratlin64116523ratlin
ravin85624653ra_vin
rawin85521473ra_win
renin54830033ren_in
rennin63914033rennin
sabin74924953sa_bin
sacking144122703sacking
saimin8313663saimin
sain45551293sa__in
saki85628483sa_ki_
sakis95323673sa_kis
sanding93520603sanding
saning75127643san_ing
sank85236833sank__
santir6315253santir
sarin55239253sa_rin
sasin54626573sa_sin
satin55935223sa_tin
savin84625083sa_vin
shanking163612283shanking
sinking123320543sinking
siskin1079783siskin
skanking12288743skanking
skin85927533__skin
snacking153411703snacking
snaking123915303sna_king
spanking153911973spanking
sunken103511783sunken
swanking16399963swanking
swanskin1543533swanskin
tacking144421483tacking
tain45548073ta__in
taken94819143ta_ken
taking114725953ta_king
takins105117403ta_kins
talkie103914443talkie
talking123815823talking
tamein8313093tamein
tanging93419523tanging
tank85134023tank__
tanka93817483tank_a
tankas104613763tankas
tanked113919293tanked
tanker104521123tanker
tankinis12245913tankinis
tanks94624733tank_s
tannic82811473tannic
tanning83618253tanning
tannins72813223tannins
tanuki1034913tanuki_
tanukis1134713tanukis
tasking124616323tasking
tenpin8310583tenpin
thanking16409523thanking
unkind113310573_unkind
unkink9308713_unkink
unpin72613243_unpin
vain75233003va__in
vakil1259793va_kil
vanman1139793vanman
vanmen1138403vanmen
vanning113912463vanning
venin85118663ven_in
wain75840203wa__in
waken124818473wa_ken
waking144821383wa_king
walking154013303walking
wangan10311223wangan
wangun1037103wangun
waning103623803wan_ing
wanion93213063wanion
wank115632513wank__
wanked144517153wanked
wanker134219973wanker
wanks126124483wank_s
wanning113816213wanning
wanting114220173wanting
wanton94413813wanton
warking153519573warking
wauking153410013wauking
welkin1337313welkin
winking153317963winking
xanthin1747043xanthin
yacking174315683yacking
yakking14376423yakking
yank115423673yank__
yanked144312243yanked
yanks125316573yank_s
zayin174512043za_yin
zonking21359113zonking

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.390458182.1
2DLD Change Limit1127164725.92319030.2
3Display Results4724720.1533085.0
 (SQL Overall)1786914726.46627635.5
 
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.