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

459 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
nankins115905(None) 
nandins8312001nandins
nankin1039671nankin_
napkins1336671napkins
banking144621352banking
bankings15489402bankings
bankits133410152bankits
calkins133814872calkins
canakins142010462canakins
canikins14219162canikins
catkins133012562catkins
gaskins123510772gaskins
hankies143617762hankies
hanking154619102hanking
malkins133311802malkins
manakins14209762manakins
manikins14189722manikins
mankind1437772mankind
nancies93516842nancies
nandin7313032nandin_
nandina838912nandina
nandinas936582nandinas
nankeens1243242nankeens
nannies73015202nannies
napkin1236902napkin_
narking124015382narking
punkins133111112punkins
ranking124320882ranking
rankings13389172rankings
takins105117402ta_kins
tanking123918792tanking
tankini11338922tankini
tankinis12245912tankinis
tannins72813222tannins
wanking154216782wanking
yanking154512462yanking
ablins8316193_ablins
actins86321103_actins
ains46158883_a__ins
akin86328033_a_kin_
alanins7315803alan_ins
algins74816433_algins
alkies104518093_alkies
alkine104916803_alkine
alkines114415733_alkines
aloins65022203_aloins
amins75534323_a_mins
anankes1138763anank_es
angina7413133_angina
anginas8310953_anginas
anilins7416793anilins
anils56326723_an_ils
anions64123033_anions
anis45746463_an_i_s
ankhs12116723_ank_hs
ankles104818383_ankles
ankling122912063_ankling
ankus91410683_ank_us
anoint6423633_anoint
anoints7311063_anoints
antics84621453_antics
anting75827023_anting
antings85015583_antings
antis55033313_anti_s
anvils9219713_anvils
anyons94513503_anyons
asking116017233_asking
askings12519173_askings
auxins13129813_auxins
ayins85321613_a_yins
backing165523443backing
backings174012213backings
baking135626623ba_king
bakings144312023ba_kings
balking143717353balking
bandies104124863bandies
banding114921413banding
bandits103814793bandits
banging114019863banging
banians9312033banians
baning95127833ban_ing
bankers133919093bankers
bankit123617043banki_t
banks115527903bank__s
banksias1445893banksias
banning103818233banning
banns75321233ban__ns
banties94324763banties
banyans1237913banyans
barking144724183barking
basins85722763ba_sins
basking144718613basking
benzins1838693benzins
blanking154411933blanking
bodkins1438313bodkins
bonking144116373bonking
bumkins15318013bumkins
bunking144016193bunking
buskins133310943buskins
cabins104418923ca_bins
cains75334303ca__ins
caking134624673ca_king
calkin123515493calkin_
calking144617783calking
calkings15289223calkings
canakin131810833canakin_
cancans11311873cancans
candids113812693candids
candies104125613candies
canids95118133can_ids
canikin13189753canikin_
canine83826703can_ine
canines93724033can_ines
caning94128623can_ing
cankers134418753cankers
cannikins15225683cannikins
canning103620133canning
cannings113710333cannings
cannons94412883cannons
canons85522063can_ons
cantina93417253cantina
cantinas102713783cantinas
canting104725903canting
cantons95221203cantons
canyons124511593canyons
caplins113515993caplins
carking144322853carking
carlins93921923carlins
caseins93115053caseins
casking144317353casking
catkin123512383catkin_
catlins93818843catlins
clanking154313063clanking
conins84327233con_ins
conking143618453conking
cranking154613073cranking
crankpins17133763crankpins
cyanins122910013cyan_ins
daikons12186693daikons
dancing113611563dancing
dandies94121443dandies
danging103716093danging
danios7314603dan_ios
darkens12409873darkens
darkies124015753darkies
darking134217343darking
dentins83419223dentins
dinkies123716033dinkies
dinking133618283dinking
dunking133813263dunking
dunlins849553dunlins
dyneins1134213dyneins
eanling81416673eanling
eanlings9128473eanlings
fadeins1168503fadeins
fagins10513863fa_gins
faking145520983fa_king
fakirs13468083fa_kirs
fancies124018783fancies
fanfics1535173fanfics
fanions103713073fanions
fannies103415643fannies
fanning113615073fanning
fanons96115213fan_ons
fanzine1937123fanzine
fanzines2036913fanzines
finking154016603finking
firkins1437663firkins
flanking164211083flanking
franking164310863franking
franklins1694763franklins
funkias1435383funkias
funking154013023funking
gains65729513ga__ins
gamins94420053ga_mins
ganging103216193ganging
ganoids939333ganoids
gaskin113610583gaskin_
gasking134415913gasking
gaskings14427473gaskings
gawkies15429123gawkies
gawking16398823gawking
guanins8810013guan_ins
hackies163418243hackies
hacking173720613hacking
haemins122811403haemins
hakims1537303ha_kims
handing123518893handing
hanging123518703hanging
hangings13258583hangings
hankers144218133hankers
hankie133915713hanki_e
hanks126226863hank__s
hanting114124483hanting
harkens144112863harkens
harking154120943harking
harmins123716723harmins
harpins123615703harpins
hatpins123410643hatpins
hawkies173311243hawkies
hawking183711423hawking
hawkings19336133hawkings
honkies143015143honkies
honking153414793honking
hunkies143214503hunkies
inking115119053_inking
jackies202912623jackies
jacking214515263jacking
jasmins1637083jasmins
jauking19418323jauking
jerkins18358253jerkins
jinking193613543jinking
junkies183711693junkies
junking193910073junking
kains96125643ka__ins
kakis86116843ka_ki_s
kamsins1346963kamsins
kanbans1337723kanbans
kanjis1735963kanji_s
kaolins1139363kaolins
kinins104014583kin_ins
kinking113615153kinking
kins85747913___kins
knacking14296713knacking
konking113510213konking
lacking143821543lacking
ladykins1643603ladykins
laking115027043la_king
lakings124713513la_kings
lambkins1664983lambkins
lanais6316793lanai_s
lancing103314123lancing
landing92819323landing
landings103110073landings
lankier113711633lankier
lankiest122912503lankiest
lankily1437123lankily
lankiness1338053lankiness
lanolins8310533lanolins
lapins84520683la_pins
larking123718253larking
lashins103915153lashins
lattins74115483lattins
layins93817653la_yins
linins65922143lin_ins
linking123818253linking
mains75635113ma__ins
making134823853ma_king
makings145413163ma_kings
malkin122913153malkin_
manakin131810643manakin_
manias84029033man_ias
manics103919933man_ics
manikin132110243manikin_
mannans93611523mannans
mannikins15215093mannikins
manning103616383manning
mansions1069793mansions
mantids103113623mantids
mantis83926033manti_s
margins103815193margins
marking144020133marking
markings153410243markings
marlins93420473marlins
martins93322063martins
masking145116613masking
maskings15448753maskings
matins84527783ma_tins
mattins93316143mattins
mavins115119183ma_vins
mayvins1535323mayvins
minikins14208323minikins
muntins92715133muntins
naans55815253na__ans
nabbing12299963nabbing
nabis76020583na_bi_s
nadirs7109003na_dirs
naffing14359033naffing
nagging102613043nagging
naifs87617423na__ifs
nailing83419963nailing
nails55730403na__ils
nakfas1334683na_kfas
naming93917893na_ming
nanas55928633nan__as
nances83618643nan_ces
nanism8311203nan_ism
nanisms938833nanisms
nankeen1135043nankeen
nannie63713223nanni_e
nanny84813813nan__ny
nans46139403na___ns
nappies114613403nappies
napping123514183napping
narceins1036413narceins
nardine82712573nardine
narine63422553na_rine
naris55735293na_ri_s
narks96026033nark__s
nasions73112383nasions
nasties73520493nasties
nations74720563nations
natrons73215663natrons
navaids1134803navaids
navies95218623na_vies
navvies1335323navvies
nazis145216083na_zi_s
necking143913893necking
neckings15346113neckings
niacins938543niacins
nicking143516323nicking
ninepins1045873ninepins
ninnies73713613ninnies
ninons64913773nin_ons
nocking143615113nocking
noggins9288453noggins
nonfans1037533nonfans
nookies113414963nookies
nubbins11268023nubbins
nuking113411253n_uking
nuncios937113nuncios
oinking123714713oinking
packing164420723packing
packings174310063packings
paiking143814813paiking
pains75138283pa__ins
pandies104224503pandies
pandits103914213pandits
pangens103112063pangens
panging113319113panging
panics103815363pan_ics
panini8314273pan_ini
panino8315683pan_ino
pannikins15204843pannikins
panning104019393panning
pansies94521983pansies
panties94230933panties
panting104025423panting
papains11312363papains
parking143423043parking
parkings153610683parkings
patins87528783pa_tins
paulins9312613paulins
pavins114919663pa_vins
pekins121812233_pekins
pinkens13419643pinkens
pinkies133818263pinkies
pinking143918943pinking
pinkings15338143pinkings
pipkins15328183pipkins
planking153513013planking
plankings16326113plankings
pranking153813383pranking
punkies134216803punkies
punkin123611523punkin_
rabbins112811343rabbins
racking144323663racking
rains55140233ra__ins
raisins72715343raisins
raking114728423ra_king
rakis95323443ra_ki_s
ramekins1466113ramekins
randans8313213randans
randies84225663randies
ranging94120263ranging
ranids75118703ran_ids
ranis55235833ran_i_s
rankers113217463rankers
rankish14510383rankish
rankles113114543rankles
rankling132610113rankling
ranks95225733rank__s
ranting84025413ranting
ratlins73615583ratlins
ravins94622563ra_vins
rawins95617623ra_wins
renins64526453ren_ins
rennins74013413rennins
sabins85521983sa_bins
sacking144122703sacking
sackings15389633sackings
saimins9312113saimins
sains55639973sa__ins
sakis95323673sa_ki_s
sanding93520603sanding
sanies63031953san_ies
saning75127643san_ing
santims9312603santims
santirs7312963santirs
sarins63932623sa_rins
sasins64923103sa_sins
satins64930483sa_tins
savins93923133sa_vins
shanking163612283shanking
sinking123320543sinking
siskins1159583siskins
skanking12288743skanking
skins94723463__skins
snacking153411703snacking
snaking123915303sna_king
spanking153911973spanking
spankings16215003spankings
swanking16399963swanking
swanskins1643283swanskins
tacking144421483tacking
tains54936323ta__ins
takin94921303ta_kin_
taking114725953ta_king
takings124512573ta_kings
talkies113415733talkies
talking123815823talking
talkings13358403talkings
tameins9311423tameins
tanging93419533tanging
tankas104613773tank_as
tankers113416913tankers
tanks94624743tank__s
tannin62613933tannin_
tanning83618253tanning
tannings9268633tannings
tansies74521243tansies
tanukis1134713tanuki_s
tasking124616323tasking
tenpins9410073tenpins
thanking16409523thanking
twankies1535893twankies
unakin10310963una_kin_
unkind113310573_unkind
unkink9308713_unkink
unkinks10265413_unkinks
unpins82312383_unpins
vakils1337593va_kils
vanning113912463vanning
venins93816703ven_ins
wains86930873wa__ins
wakens135012043wa_kens
waking144821383wa_king
walking154013303walking
walkings16327313walkings
wangans1149503wangans
wanguns1135023wanguns
waning103623803wan_ing
wanions104011373wanions
wankers144514713wankers
wanks126124483wank__s
wanning113816213wanning
wanting114220173wanting
wantons103713013wantons
warking153519573warking
wauking153410013wauking
welkins1437173welkins
winking153317963winking
xanthins1846943xanthins
yacking174315683yacking
yakking14376423yakking
yanks125316573yank__s
zanies153219673zan_ies
zayins18409713za_yins
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 Filter1786911340270.423422437.4
2DLD Change Limit1340274596.23321502.8
3Display Results4594590.1732653.2
 (SQL Overall)1786914596.82926166.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.